Duration: 2 days or afternoon/evening sessions
Introduction
Dive into Azure Data Factory / Microsoft Fabric Pipelines and elevate your data engineering capabilities to the next level! Discover advanced techniques and best practices essential for the modern data engineer.
Target Audience
Data Engineers who want to delve into building and managing data integration solutions with Azure Data Factory and/or Microsoft Fabric Pipelines.
Prerequisites
Basic knowledge of ETL processes: Understanding of fundamental concepts like Extract, Transform, and Load.
Information
Interested in this training? Click here for more information.
Topics
Introduction
- Architecture of Azure Data Factory / Pipelines
- Integration runtime
- Datasources / Linked Services: SQL Server, Azure, Blob Storage (CSV, XLSX), Web
ETL Pipelines
- Copy data: Datasets, Source, Sink, Mapping
- Transform data: Data flows, Power Query
- SQL Activities: Stored Procedures, Lookup, Script
- Parameters, Variables, ADF Expression language
- Iteration & conditionals: Foreach / if / Switch
- Web: Call Web API
Management
- Schedule execution: Triggers
- Monitoring / logging
- Deployment
- Debugging
- OTAP