NEED HELP? TALK TO AN EXPERT (904) 638-5743

Pipelines and Data Flows in Azure Synapse Analytics

Part Of The On-Demand Courses

WHAT YOU'LL LEARN

  • The basics of ETL inside of Synapse pipelines
  • Create linked services to external data sets
  • Move data with copy data activities inside of pipelines
  • Trigger pipelines based on schedules
This course includes:

Course Description

Azure Synapse Analytics can be your one stop shop for ETL (Extract, Transform, and Load). In this course you will walk through the basics of ETL inside of Synapse pipelines. You will create linked services to external data sets, move data with copy data activities inside of pipelines, and trigger pipelines based on schedules. Synapse also contains Data Flows, an incredibly powerful tool to develop data transformation logic without writing code. Pipelines and data flows make data movement easy inside of Synapse.

Outline

 

Module 00 | Setup (Environment Setup)

 

Module 01 | ETL in Azure Synapse Analytics – What is ETL

 

Module 02 | ETL in Azure Synapse Analytics

 

Module 02A | ETL in Azure Synapse Analytics (What is ETLe?)

 

Module 02B | Integration Runtimes (Self Hosted Integration Runtime)

 

Module 03 | Copy Activity

 

Module 03A | Copy Activity (Azure Integration Runtime)

 

Module 03B | Copy Activity (Self-Hosted Integration Runtime)

 

Module 04 | Activities

 

Module 04A | Activities (Get Metadata Activity)

 

Module 04B | Activities (Stored Procedure Activity)

 

Module 04C | Activities (Lookup Activity)

 

Module 04D | Activities (If Condition Activity)

 

Module 04E | Activities (Filter Activity)

 

Module 04F | Activities (ForEach Activity)

 

Module 05 | Data Flows

 

Module 05A | Data Flows (Introduction to Data Flows)

 

Module 05B | Data Flows (Aggregate Transform)

 

Module 05C | Data Flows (Window Functions)

 

Module 05D | Data Flows (Join Transform)

 

Module 05E | Data Flows (Select Transform)

 

Module 05F | Data Flows (Derived Column Transform)

 

Module 06 | Scheduling and Monitoring

 

Module 06A | Scheduling and Monitoring (Scheduling Pipelines)

 

Module 06B | Scheduling and Monitoring (Monitoring)

Instructor

MITCHELL PEARSON

Training Content Manager
Mitchell Pearson has been with Pragmatic Works for 8 years as a Data Platform Consultant and the Training Content manager. 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 and Microsoft Azure.

 

Click Here To Learn More About Mitchell And See Certifications And Reviews

System Requirements

  • Microsoft Azure Account (Paid or Trial)

What to Know Before Class

  • This course assumes you have completed the Introduction to Azure Synapse Analytic course.
  • Complete the Azure Synapse Analytics set-up course before taking this one.
REVIEWS

Pending reviews - check back later

Pending reviews - check back later

Pending reviews - check back later

Start With The Free Community Plan

Pragmatic Works free community plan gives you lifetime access to 7 Microsoft “in a day” courses on Power BI, Excel, Power Apps, Azure Synapse, Power Automate, Paginated Reports and Chatbots.

 

Bonus:

• Get preview access to all 70+ courses & custom Learning Paths for 7 days

• Labs and files included

• Access courses from our mobile app or desktop

• Access quizzes to practice while you learn

Get Instant Access Now!