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 includes:
- 3+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
Course Description
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 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.
This course includes:
- 3+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
System Requirements
This course includes:
- 3+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
What to know before class
This course includes:
- 3+ hours hours of training
- Access on mobile and browser
- Certificate of Completion