Virtual Azure Data Factory Bootcamp
Event 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 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** - Azure Subscription (Trial or Paid) - Azure Storage Explorer https://aka.ms/StorageExplorer - (Optional) SQL Server Management Studio v17.5 or Later www.aka.ms/ssms
Prerequisites
System Requirements
- *Price is in USD and any discount applied is for new purchases only. Offers are subject to change with/without notice and are for a limited time only.”
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
- Wrangling Data Flows
- Creating your first Wrangling Data Flow
- Power Query Editor Online
- Scheduling and Monitoring
- Triggers
- Azure Logic Apps Integration
- Azure Log Analytics
- Logic Apps for Notification Framework
- Azure Logic Apps
- Introduction to Azure Logic Apps
- Working with Templates
- Azure Key Vault
- Setting up Azure Key Vault
- Understanding Secrets
- Azure Data Factory Integration
- Managed Identity
Get tickets:
| Ticket type | Price | Quantity |
|---|---|---|
| Virtual Azure Data Factory Bootcamp (Jul 15, 2024 – 7/17/24) | $1,995.00 | |
Add an event to your calendar
Instructor – Manuel Quintana
As a Training Content Manager and Trainer with Pragmatic Works, Manuel uses his extensive knowledge of the BI Stack (SSRS, SSIS, SSAS etc.) to deliver exciting and engaging content. He also has experience with T-SQL, DAX, Power Platform and Azure Data Services. Manuel, however, is known for his impressive knowledge of the Microsoft Power BI tool. A native of Puerto Rico, He graduated from the University of Central Florida and loves being involved in the world of business intelligence. Manuel is a thought leader in the BI community.