Introduction to Azure Data Factory

$95.00

Category:

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.

Instructor

MITCHELL PEARSONMITCHELL PEARSON

BI Consultant and Trainer
As a Business Intelligence Consultant and Trainer for Pragmatic Works, Mitchell’s focus is on the full BI Stack (SSIS, SSAS and SSRS). In addition to the BI Stack, he also has experience with Data Modeling, T-SQL, MDX, Power Pivot and the Power BI Tools. Mitchell graduated from the University of North Florida in 2007 and is constantly expanding his knowledge on all things SQL Server.

 

What to Know Before the 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.


Duration: 8:16:25
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.
Introduction to Data Factory - What you need to get started
Module 00 - Class Introduction
08:21
Module 01A - Getting Started with Azure (Navigating the Azure Portal)
15:01
Module 01B - Getting Started with Azure (Resource Groups)
06:46
Module 01C - Getting Started with Azure (Setting up an Azure SQL Database and Azure Storage)
16:05
Module 02A - Working with Data Factory (Provisioning Data Factory)
10:06
Module 02B - Working with Data Factory (Data Factory Navigation)
11:25
Module 02C - Working with Data Factory (Self-Hosted Integration Runtime)
20:44
Module 02D - Working with Data Factory (Copy Activity Wizard)
21:43
Module 02E - Working with Data Factory (Azure Blob to Azure SQL DB)
17:01
Module 02F - Working with Data Factory (Factory Resources)
15:54
Module 02G - Working with Data Factory (Copy Activity)
26:29
Module 02H - Working with Data Factory (Get Metadata Activity)
09:05
Module 02I - Working with Data Factory (Stored Procedure Activity)
13:33
Module 02J - Working with Data Factory (Lookup Activity)
20:51
Module 02K - Working with Data Factory (If Condition Activity)
14:06
Module 02L - Working with Data Factory (If Condition Activity Completion)
16:50
Module 02M - Working with Data Factory (ForEach Activity)
29:06
Module 02N - Working with Data Factory (Creating Dynamic Datasets)
23:36
Module 02O - Working with Data Factory (Filter Activity)
12:48
Module 03A - Data Flows (Overview)
16:18
Module 03B - Data Flows (Source)
25:29
Module 03C - Data Flows (Transformations)
24:59
Module 03D - Data Flows (Sink)
29:08
Module 04A - Azure Lift and Shift (Provisioning Azure - SSIS Integration Runtime)
18:06
Module 04B - Azure Lift and Shift (Visual Studio Deployment)
10:49
Module 04C - Azure Lift & Shift (Execute SSIS Package from Azure)
08:15
Module 05 - Triggers (Schedule Triggers)
12:19
Module 06A - Monitoring (Azure Data Factory)
08:45
Module 06B - Monitoring (SSIS Lift and Shift)
08:07
Module 07 - Notification (Azure Logic Apps)
24:40
Class Survey

 

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)