<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

Advanced Data Flows in Azure Synapse Analytics

Simplify ETL with Synapse! Learn Mapping Data Flows in Azure Synapse Analytics for visual data transformations. No coding needed. Explore principles, basic JSON handling, and advanced Window transformations.

  • Course Info
  • Instructor
  • System Requirements
  • What to know beforehand

Course Description

ETL can be easy with Synapse. Mapping data flows are visually designed data transformations in Azure Synapse Analytics. Data flows provide an entirely visual experience with no coding required. This course goes through the principles of a data flow and then covers the different transformations that are available for users to move and transform their data. Whether you are working with JSON or building out advanced data flows with Window transformations this course is here to assist you.

Course Outline ( Free Preview)

What you need to get started

Module 00 - Course Introduction 9 min.

Module 01A - Data Flows (Introduction) 12 min.

Module 01B - Data Flows (Cost & Compute) 16 min.

Module 01C - Data Flows (Creating & Running) 35 min.

Module 01D - Data Flows (Scheduling & Monitoring) 12 min.

Module 01E - Data Flows (Parameterizing Data Flows) 18 min.

Module 02A - Basic Transformations (Select, Filter, and Sort) 24 min.

Module 02B - Basic Transformations (Aggregate vs. Window) 22 min.

Module 02C - Basic Transformations (Derived Column) 8 min.

Module 02D - Basic Transformations (Cast) 12 min.

Module 03A - Joining Data (Lookup) 12 min.

Module 03B - Joining Data (Joins) 13 min.

Module 03C - Joining Data (Union) 17 min.

Module 04A - Multiple Branches (New Branch) 12 min.

Module 04B - Multiple Branches (Conditional Split) 14 min.

Module 05A - Working with JSON (Flatten) 18 min.

Module 05B - Working with JSON (Stringify) 11 min.

Module 05C - Working with JSON (Parse) 11 min.

Module 06A - Pivoting Data (Pivot) 17 min.

Module 06B - Pivoting Data (Unpivot) 9 min.

Module 07A - Flowlets 7 min.

Wrap Up 2 min.

This course includes:

  • 5+ hours of training
  • 23 Modules
  • * Access on mobile and browser
  • Certificate of Completion