Pipelines and Data Flows in Azure Synapse Analytics
Join our course to simplify ETL with Azure Synapse Analytics. Cover the basics of Synapse pipelines, linked services, copy data activities, scheduling pipelines, and using Data Flows for effortless data transformations.
- What you'll learn
- Course Description
- Course Outline
- Instructor
- System Requirements
- What to know beforehand
What you'll learn
This course includes:
- 5+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
Course Description
This course includes:
- 5+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
Course Outline
What you need to get started
Module 00 - Setup (Environment Setup) 1 min.
Module 01 - ETL in Azure Synapse Analytics (What is ETL) 13 min.
Module 02A - Integration Runtimes (What are Integration Runtimes) 8 min.
Module 02B - Integration Runtimes (Self Hosted Integration Runtime) 8 min.
Module 03A - Copy Activity (Azure Integration Runtime) 30 min.
Module 03B - Copy Activity (Self Hosted Integration Runtime) 22 min.
Module 04A - Activities (Get Metadata Activity) 17 min.
Module 04B - Activities (Stored Procedure Activity) 23 min.
Module 04C - Activities (Lookup Activity) 14 min.
Module 04D - Activities (If Condition Activity) 23 min.
Module 04E - Activities (Filter Activity) 19 min.
Module 04F - Activities (For Each Activity) 18 min.
Module 05A - Data Flows (Introduction to Data Flows) 28 min.
Module 05B - Data Flows (Aggregate Transform) 15 min.
Module 05C - Data Flows (Windows Transform) 9 min.
Module 05D - Data Flows (Join Transform) 18 min.
Module 05E - Data Flows (Select Transform) 11 min.
Module 05F - Data Flows (Derived Column Transform) 15 min.
Module 06A - Scheduling and Monitoring (Scheduling Pipelines) 21 min.
Module 06B - Scheduling and Monitoring (Monitoring) 15 min.
This course includes:
- 5+ 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:
- 5+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
System Requirements
This course includes:
- 5+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
What to know before class
This course includes:
- 5+ hours hours of training
- Access on mobile and browser
- Certificate of Completion