Boot Camp Details
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 boot camp, you will learn how to create data-driven pipelines to direct the movement of data in your organization and how it can be used as an orchestration tool. You will learn the various options you have to perform enterprise scale Extract-Transform-Load (ETL) operations using Data flows.
The class will use Azure SQL DB, Azure Data Lake Store, Azure Logic Apps, and Azure Key Vault and the student will learn how each of these services integrate with Azure Data Factory.
Prerequisites
No prior experience is required.
System Requirements
Course Outline
- Azure Overview
- Navigating the Azure Portal and documentation
- Azure Resources
- ARM Templates
- Deploy class resources
- Resource Groups
- Overview of Azure Data Factory
- Provisioning Azure Data Factory Instance
- Data Factory Navigation
- Pipelines
- Dataflows
- Understanding Linked Services
- Basics of Integration Datasets
- Pipeline Basics
- Copy Data Activity Wizard
- Get Metadata Activity
- Stored Procedure Activity
- More Advanced Designs with Pipelines
- Parent/Child Design patterns
- Using expressions
- Restartability
- Creating Dynamic Datasets
- Integration Runtimes
- Azure Integration Runtime
- Self-hosted Integration Runtime
- Azure-SSIS RuntimeIntegration Runtimes
- Working with On-Prem Data using Pipelines
- Self-Hosted Integration Runtime
- Creating Linked services for On-Prem sources
- Data Flow Basics
- Navigating the design area
- Source’s
- Transformations
- Sinks (Destinations)
- Mapping Data Flows
- Creating your first Data Flow
- Data Flow Debug
- Advanced Data Flow Designs
- Expressions
- Rule Based Mapping
- Flowlets
