Azure Data Factory Training: Designing and Implementing Data Integration Solutions

Course 1231

Duration: 3 days
Labs: Yes
Language: English
Level: Intermediate

This Azure Data Factory Training covers all key aspects of the Azure Data Factory v2 platform. 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.

Azure Data Factory Training Delivery Methods

In-Person
Online

Azure Data Factory Training Information

In this Azure Data Factory course, 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.

Prerequisites

Learning Tree course 8566, Introduction to Microsoft Azure (AZ-900), or equivalent experience.

Azure Data Factory Training Outline

Module 1: Introduction to ADF

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

Module 2: 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

Module 3: Building and Executing Your First Pipeline

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

Module 4: 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 behavior: append, upsert, overwrite, write with custom logic
Schema and data type mapping
Fault tolerance options

Module 5: 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

Module 6: 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

Module 7: 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

Module 8: 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

Module 9: Promoting Reuse

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

Module 10: Security

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

Get This Course $2,885 GOV $2,539

3-day instructor-led training course
Hands-on labs included
One-on-one after-course instructor coaching

#1231

Aug 27 - 29 9:00 AM - 4:30 PM EDT

Herndon, VA or Virtual
Sep 24 - 26 9:00 AM - 4:30 PM EDT

Ottawa or Virtual
Nov 24 - 26 9:00 AM - 4:30 PM EST

Herndon, VA or Virtual
Dec 10 - 12 9:00 AM - 4:30 PM EST

Ottawa or Virtual
Mar 4 - 6 9:00 AM - 4:30 PM EST

Herndon, VA or Virtual
Mar 25 - 27 9:00 AM - 4:30 PM EDT

Ottawa or Virtual

3-day instructor-led training course
Hands-on labs included
One-on-one after-course instructor coaching

#1231

Aug 27 - 29 9:00 AM - 4:30 PM EDT

Herndon, VA or Virtual
Sep 24 - 26 9:00 AM - 4:30 PM EDT

Ottawa or Virtual
Nov 24 - 26 9:00 AM - 4:30 PM EST

Herndon, VA or Virtual
Dec 10 - 12 9:00 AM - 4:30 PM EST

Ottawa or Virtual
Mar 4 - 6 9:00 AM - 4:30 PM EST

Herndon, VA or Virtual
Mar 25 - 27 9:00 AM - 4:30 PM EDT

Ottawa or Virtual

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

#1231

Questions about this course?

Inquiring For

Myself

Team/Group

First Name*

Last Name*

Email*

Phone Number*

Company*

Job Title

I'm interested In

* Required Fields

Customize Your Team Training Experience

Fill out the form below or call 888-843-8733

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Azure Data Factory Training FAQs

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.

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

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.

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.

Certification candidates and existing credential holders are responsible for reporting all Continuing Certification Requirements Program (CCR) activities to PMI (Project Management Institute). To report the completion of a Learning Tree course, you can use the Online PDU (Professional Development Units) Resources System.

Go to the PMI Continuing Certification Requirements System https://ccrs.pmi.org/
Log in with your username and password
Locate the claim code associated with your course in the table in this document
Click on “Report PDU for this activity”
Fill in the date started and date completed
Click on the box agreeing that this claim is accurate and then submit

PDU Information for This Course:

Total PDUs: 11
Ways of Working PDUs: 11
Power Skills PDUs: 0
Business Acumen PDUs: 0
PMI Claim Code: 11541E8YVO

Azure Data Factory Training: Designing and Implementing Data Integration Solutions

Azure Data Factory Training Delivery Methods

Azure Data Factory Training Information

Azure Data Factory Training Outline

Module 1: Introduction to ADF

Module 2: Core Architectural Components

Module 3: Building and Executing Your First Pipeline

Module 4: Data Movement

Module 5: Data Transformation

Module 6: Control Flow

Module 7: Runtime and Operations

Module 8: DevOps with ADF

Module 9: Promoting Reuse

Module 10: Security

Azure Data Factory Training FAQs

What is Azure Data Factory?

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

Who should take this Azure Data Factory course?

What labs are included with this training?

How do I earn Professional Development Units (PDUs) for this course?

Related Courses