<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=612681139262614&amp;ev=PageView&amp;noscript=1">
Skip to content

Need help? Talk to an expert: phone(904) 638-5743

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.

Pipelines and Data Flows in Azure Synapse Analytics
  • Course Info
  • Instructor
  • System Requirements
  • What to know beforehand

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.

Course Outline ( Free Preview)

What you need to get started

Module 00 - Setup (Environment Setup) 1 min.

Module 01 - ETL in Azure Synapse Analytics (What is ETL)

Module 02A - Integration Runtimes (What are Integration Runtimes)

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

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 of training
  • 21 Modules
  • * Access on mobile and browser
  • Certificate of Completion