Introduction to Azure Synapse Analytics

This course covers deployment, data querying with serverless and dedicated SQL pools, ETL with pipelines and data flows, multi-language Notebooks, and more in a unified environment.

What you'll learn
Course Description
Course Outline
Instructor
System Requirements
What to know beforehand

What you'll learn

This course covers deployment, data querying with serverless and dedicated SQL pools, ETL with pipelines and data flows, multi-language Notebooks, and more in a unified environment.

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Description

Azure Synapse Analytics is a limitless analytics service that brings together data integration, enterprise data warehousing, and big data analytics into a unified enviornment. In this course you will start with the basics of how to deploy an Azure Synapse Workspace in the Azure portal, look at the options for querying data within Synapse with serverless SQL pools and dedicated SQL pools, perform ETL with pipelines and data flows, work with multiple code languages in Notebooks, and connect it all together with Power BI. Synapse is a vast and powerful tool and this is the perfect introduction for where to begin.

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Outline

What you need to get started

Module 00 - Environment Setup 12 min.

Module 01A - Introduction (Introduction to ASA Services) 17 min.

Module 01B - Introduction (Why Synapse Analytics) 12 min.

Module 01C - Introduction (Provisioning ASA) 18 min.

Module 02A - ADLS (Provisioning ADLS) 21 min.

Module 02B - ADLS (Bring Your Own Data) 9 min.

Module 03 - Serverless - SQL On-Demand 20 min.

Module 04 - SQL Pools 24 min.

Module 05A - ETL (Introduction to ETL in Synapse) 15 min.

Module 05B - ETL (Creating Your First Pipeline) 24 min.

Module 06A - Notebooks (Apache Spark Pools) 25 min.

Module 06B - Notebooks (Introduction to Notebooks) 16 min.

Module 07A - Power BI (Connecting from Power BI Desktop) 9 min.

Module 07B - Power BI (Connecting to Power BI Workspaces) 7 min.

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion

Instructor

Mitchell Pearson

Data Engineer (Azure) Trainer

Mitchell Pearson has been with Pragmatic Works for 11 years as a Data Platform Consultant, Trainer and Team Lead. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform, Microsoft Azure and Fabric.

Learn More

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion

System Requirements

Microsoft Azure Account (Paid or Trial)

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion

What to know before class

This course assumes you have no or minimal prior knowledge of Azure.

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion