Azure Synapse Analytics Deep-Dive

27. oktober 2020 09:00
29. oktober 2020 17:00
Kanalvej 7, 2800 Kongens Lyngby   Vis kort

16.500 DKK 13.500 DKK

På lager



Azure Synapse is the limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives you the freedom to query data on your terms, using either serverless or provisioned resources—at scale. Azure Synapse brings these two worlds together with a unified experience to ingest, prepare, manage, and serve data for immediate BI and machine learning needs.

This course is designed to take a Microsoft data professional to an Synapse Analytics expert in just 3 days. You will leave this course with all the advanced skills you need to get going on your Big Data Journey. You will learn by experimentation, this is a lab heavy training session. The course will be delivered by Simon Whiteley, Data Platform MVP (Microsoft MVP). Simon is recognised for his ability to convert deep technical material in to bite sized understandable chunks.


  • A background as a Microsoft data professional
  • A basic understanding of Synapse Analytics
  • A laptop with a subscription to Azure


We aim to deliver the latest and greatest of Synapse Analytics and as the service is still in preview the content of this agenda might be updated.

Lakehouse Architectures

  • Designing Data Lakes
  • Synapse Overview
  • Big Data Processing Techniques

Synapse Setup & Config

  • Provisioning Studio
  • Connecting to the Lake
  • Linked Services & Workspace
  • Security, Access & Monitoring
  • The Synapse Metastore

Provisioned SQL Pools

  • MPP Architecture
  • Tables & Distribution
  • Performance Tuning
  • Workload Management
  • Successful Patterns

On-demand SQL Pools

  • On-demand SQL Pools Overview
  • Performance & Cost
  • Supported T-SQL
  • Query and Create files in the Lake
  • Use Cases & Scenarios

Spark Pools & Pyspark Basics

  • Spark Pools Overview
  • Reading / Writing Data
  • The Languages
  • PySpark Deep Dive
  • Design Patterns

Orchestration & Data Acquisition

  • Data Factory Overview
  • Connecting & Loading Data
  • Data Driven Orchestration

Power BI & Integrations

  • Power BI Development
  • Workspace Integrations
  • Data Access Patterns

Yderligere information


3 dage