Introduction to Azure Data Factory

Part Of The On-Demand Courses


  • Create data-driven pipelines to direct movement of data and to integrate disparate data sources across your organization
  • Working with Data Factory activities
  • Difference between hosting SSIS on-premises vs. Azure Lift and Shift
  • Triggers, monitoring and notification
This course includes:

Course Description

Azure Data Factory (ADF) is a cloud-based service for data integration. ADF is used to integrate disparate data sources from across your organization including data in the cloud and data that is stored on-premises. In this course, you will learn how to create data-driven pipelines to direct the movement of data. You will also be introduced to an alternative option to Azure Data Factory and that is using SSIS to work with your cloud resources. Once packages have been developed in SSIS you must choose between storing and executing those packages on-premises or in the cloud. You will then learn about the difference between hosting SSIS on-premises vs. Azure Lift and Shift.


Click here for a downloadable PDF



Module 00 | Class Introduction
08m 21s total


Module 00A | Class Introduction
08m 521s


Module 01 | Getting Started with Azure
37m 52s total


Module 01A | Navigating the Azure Portal
15m 01s


Module 01B | Resource Groups
06m 46s


Module 01C | Setting up an Azure SQL Database and Azure Storage
16m 05s


Module 02 | Working with Data Factory
260m 37s total


Module 02A | Provisioning Data Factory
10m 06s


Module 02B | Data Factory Navigation
11m 25s


Module 02C | Self-Hosted Integration Runtime
20m 44s


Module 02D | Copy Activity Wizard
21m 43s


Module 02E | Azure Blob to Azure SQL DB
17m 01s


Module 02F | Factory Resources
15m 54s


Module 02G | Copy Activity
26m 29s


Module 02H | Get Metadata Activity
09m 05s


Module 02I | Stored Procedure Activity
13m 33s


Module 02J | Lookup Activity
20m 51s


Module 02K | If Condition Activity
14m 06s


Module 02L | If Condition Activity Completion
16m 50s


Module 02M | ForEach Activity
29m 06s


Module 02N | Creating Dynamic Datasets
23m 36s


Module 02O | Filter Activity
12m 48s


Module 03 | Data Flows
95m 14s total


Module 03A | Overview
16m 18s


Module 03B | Source
25m 29s


Module 03C | Transformations
24m 59s


Module 03D | Sink
29m 08s


Module 04 | Azure Lift and Shift
96m 14s total


Module 04A | Provisioning Azure – SSIS Integration Runtime
18m 06s


Module 04B | Visual Studio Deployment
10m 49s


Module 04C | Execute SSIS Package from Azure
08m 15s


Module 05 | Triggers
12m 19s total


Module 05A | Schedule Triggers
12m 19s


Module 06 | Monitoring
16m 52s total


Module 06A | Azure Data Factory
08m 45s


Module 06B | SSIS Lift and Shift
08m 07s


Module 07 | Notification
24m 40s total


Module 07A | Azure Logic Apps
24m 40s



Training Content Manager

Mitchell Pearson has been with Pragmatic Works for 8 years as a Data Platform Consultant and the Training Content manager. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform and Microsoft Azure.


System Requirements

  • Microsoft Azure Account (Paid or Trial)
  • **Optional**
    • SQL Server Management Studio 17.5+
    • Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7 or Windows 8, Windows 10
    • 1 GHz or faster CPU
    • 1 GB of available RAM (recommended 2 GB)
    • 20 GB of free hard drive space
    • SQL Server Developer, Standard or Enterprise Edition 2012/2014/2016/2017
    • SQL Server Database Engine
    • SQL Server Integration Services
    • SQL Server Data Tools (SQL 2012/2014/2016/2017)
    • To ensure all items are installed correctly, follow this guide: (

What to Know Before Class

The target audience of this class is the data integration professional who is tasked with orchestrating data movement processes within the organization. This class assumes that you have no previous knowledge of Microsoft’s Azure Platform or Azure Data Factory. Some experience using SSIS or another ETL tool could be helpful but is not necessary. Most course work will be performed using Azure resources and therefore there are not many pre-requisites for this course.

"Very good class"

Sreenivasa K.

"Excellent class and demo. I've learned quite a bit."


"Overall I loved it; thank you!"

Ian B.

Start With The Free Community Plan

Pragmatic Works free community plan gives you lifetime access to 7 Microsoft “in a day” courses on Power BI, Excel, Power Apps, Azure Synapse, Power Automate, Paginated Reports and Chatbots.



• Get preview access to all 70+ courses & custom Learning Paths for 7 days

• Labs and files included

• Access courses from our mobile app or desktop

• Access quizzes to practice while you learn

Get Instant Access Now!