NEED HELP? TALK TO AN EXPERT (904) 638-5743

Introduction to Azure Data Factory

Part Of The On-Demand Courses

WHAT YOU'LL LEARN

  • 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

Outline

 

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

Instructor

MITCHELL PEARSON

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: (https://file.ac/z_cSfNDJsgw/Pragmatic%20SSIS%20Installation%20Guide.docx)

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.

REVIEWS
"Very good class"

Sreenivasa K.

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

Anonymous

"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.

 

Bonus:

• 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!