Azure Data Factory Training: Designing and Implementing Data Integration Solutions

Level: Intermediate

This course covers all key aspects of the Azure Data Factory v2 platform.

It is ideal for architects, developers, administrators, IT managers, and anyone else who would like to make the best possible use of this Azure service. Key areas covered include ADF v2 architecture, UI-based and automated data movement mechanisms, 10+ data transformation approaches, control-flow activities, reuse options, operational best-practices, and a multi-tiered approach to ADF security.

Special attention is paid to covering Azure services which are commonly used with ADF v2 solutions. These services are Azure Data Lake Storage Gen 2, Azure SQL Database, Azure Databricks, Azure Key Vault, Azure Functions, and a few others.

6 hands-on instructor-led labs are included with the course. These allow students to practice applying ADF v2 concepts and prepare them for real-world Azure data integration projects.

Key Features of this Azure Data Factory Training:

  • After-course instructor coaching benefit
  • Hands-on labs included

You Will Learn How To:

  • Build end-to-end ETL and ELT solutions using Azure Data Factory v2
  • Architect, develop and deploy sophisticated, high-performance, easy-to-maintain and secure pipelines that integrate data from a variety of Azure and non-Azure data sources.
  • Apply the latest DevOps best practices available for the ADF v2 platform.

Choose the Training Solution That Best Fits Your Individual Needs or Organizational Goals


In Class & Live, Online Training

  • 3-day instructor-led training course
  • One-on-one after-course instructor coaching
  • Tuition can be paid later by invoice -OR- at the time of checkout by credit card
View Course Details & Schedule

Standard $2745 CAD

Government $2415 CAD




Team Training

  • Bring this or any training to your organization
  • Full - scale program development
  • Delivered when, where, and how you want it
  • Blended learning models
  • Tailored content
  • Expert team coaching

Customize Your Team Training Experience


Save More On Training with FlexVouchers – A Unique Training Savings Account

Our FlexVouchers help you lock in your training budgets without having to commit to a traditional 1 voucher = 1 course classroom-only attendance. FlexVouchers expand your purchasing power to modern blended solutions and services that are completely customizable. For details, please call 888-843-8733 or chat live.

In Class & Live, Online Training

Time Zone Legend:
Eastern Time Zone Central Time Zone
Mountain Time Zone Pacific Time Zone

Note: This course runs for 3 Days

  • Nov 3 - 5 9:00 AM - 4:30 PM EDT Online (AnyWare) Online (AnyWare) Reserve Your Seat

  • Dec 1 - 3 9:00 AM - 4:30 PM EST Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

  • Dec 15 - 17 9:00 AM - 4:30 PM PST Bellevue / Online (AnyWare) Bellevue / Online (AnyWare) Reserve Your Seat

  • Jan 5 - 7 9:00 AM - 4:30 PM EST New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

  • Feb 2 - 4 9:00 AM - 4:30 PM EST Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

  • Feb 23 - 25 9:00 AM - 4:30 PM EST Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

  • Apr 6 - 8 9:00 AM - 4:30 PM MDT Aurora / Online (AnyWare) Aurora / Online (AnyWare) Reserve Your Seat

  • May 4 - 6 9:00 AM - 4:30 PM EDT Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

  • Jun 1 - 3 9:00 AM - 4:30 PM EDT Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

  • Jun 15 - 17 9:00 AM - 4:30 PM PDT Bellevue / Online (AnyWare) Bellevue / Online (AnyWare) Reserve Your Seat

  • Jul 6 - 8 9:00 AM - 4:30 PM EDT New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

  • Aug 3 - 5 9:00 AM - 4:30 PM EDT Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

  • Aug 31 - Sep 2 9:00 AM - 4:30 PM EDT Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

Guaranteed to Run

When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time — will run. Guaranteed.

Important Azure Data Factory Training Information

Azure Data Factory Training Outline

  • Introduction to ADF

    • Historical background: SSIS, ADF v1, other ETL/ELT tools
    • Key capabilities and benefits of ADF v2
    • Recent feature updates and enhancements
  • Core Architectural Components 

    • Connectors: Azure services, databases, NoSQL, files, generic protocols, services & apps, custom
    • Pipelines
    • Activities: data movement, data transformation, control flow
    • Datasets: source, sink
    • Integration Runtimes: Azure, Self-Hosted, Azure-SSIS
  • Building and Executing Your First Pipeline

    • Creating ADF v2 instance
    • Creating a pipeline and associated activities
    • Executing the pipeline
    • Monitoring execution
    • Reviewing results
  • Data Movement

    Copying Tools and SDKS

    • Copy Data Tool/Wizard
    • Copy activity
    • SDKs: Python, .NET
    • Automation: PowerShell, REST API, ARM Templates

    Copying Considerations

    • File formats: Avro, binary, delimited, JSON, ORC, Parquet
    • Data store support matrix
    • Write behaviour: append, upsert, overwrite, write with custom logic
    • Schema and data type mapping
    • Fault tolerance options
  • Data Transformation

    Transformation with Mapping Data Flows

    • Introduction to mapping data flows
    • Data flow canvas
    • Debug mode
    • Dealing with schema drift
    • Expression builder & language
    • Transformation types: Aggregate, Alter row, Conditional split, Derived column, Exists, Filter, Flatten, Join, Lookup, New branch, Pivot, Select, Sink, Sort, Source, Surrogate key, Union, Unpivot, Window

    Transformation with External Services

    • Databricks: Notebook, Jar, Python
    • HDInsight: Hive, Pig, MapReduce, Streaming, Spark
    • Azure Machine Learning service
    • SQL Stored procedures
    • Azure Data Lake Analytics U-SQL
    • Custom activities with .NET or R
  • Control Flow

    • Purpose of activity dependencies: branching and chaining
    • Activity dependency conditions: succeeded, failed, skipped, completed
    • Control flow activities: Append Variable, Azure Function, Execute Pipeline, Filter, ForEach, Get Metadata, If Condition, Lookup, Set Variable, Until, Wait, Web
  • Runtime and Operations

    • Debugging
    • Monitoring: visual, Azure Monitor, SDKs, runtime-specific best practices
    • Scheduling execution with triggers: event-based, schedule, tumbling window
    • Performance, scalability, tuning
    • Common troubleshooting scenarios in activities, connectors, data flows and integration runtimes
  • DevOps with ADF

    • Quick introduction to source control with Git
    • Integration with GitHub and Azure DevOps platforms
    • Environment management: Development, QA, Production
    • Iterative development best practices
    • Continuous Integration (CI) pipelines
    • Continuous Delivery (CD) pipelines
  • Promoting Reuse

    • Templates: out-of-the-box and organizational
    • Parameters
    • Naming convention
  • Security

    • Data movement security
    • Azure Key Vault
    • Self-hosted IR considerations
    • IP address blocks
    • Managed identity

Team Training

Azure Data Factory Training FAQs

  • What is Azure Data Factory?

    Azure Data Factory (ADF) v2 is an Azure data integration service which allows creation of data-driven workflows to orchestrate and automate data movement and transformation across cloud, on-prem and hybrid environments.

  • How much ADF experience do I need to sit for this course?

    While this new course is designed to bring students from zero expertise with ADF v2 to an intermediate or even advanced level of knowledge, Microsoft Azure Fundamentals Training (AZ-900T00) or equivalent is expected.

Online (AnyWare)
Herndon, VA / Online (AnyWare)
Bellevue / Online (AnyWare)
New York / Online (AnyWare)
Ottawa / Online (AnyWare)
Herndon, VA / Online (AnyWare)
Aurora / Online (AnyWare)
Ottawa / Online (AnyWare)
Herndon, VA / Online (AnyWare)
Bellevue / Online (AnyWare)
New York / Online (AnyWare)
Ottawa / Online (AnyWare)
Herndon, VA / Online (AnyWare)
Why do we require your location?

It allows us to direct your request to the appropriate Customer Care team.

Preferred method of contact:
Chat Now

Please Choose a Language

Canada - English

Canada - Français