$125

Event Information

Share this event

Date and Time

Location

Location

Pittsburgh Technical College

1111 McKee Road

Oakdale, PA 15071

View Map

Refund Policy

Refund Policy

Contact the organizer to request a refund.

Eventbrite's fee is nonrefundable.

Event description
From Zero to ADF is designed to jumpstart data engineering and data integration developers, introducing them to Azure Data Factory (ADF).

About this Event

From Zero to ADF is designed to jumpstart data engineering and data integration developers, introducing them to Azure Data Factory (ADF). ADF is a cloud data engineering and data integration platform designed to orchestrate data-related activities and move data between sources and sinks in the cloud, on-premises, and combinations thereof.

Course Outline

Lesson 0: Introduction

Training overview, expectations, and introductions.

Lesson 1: Provision a Data Factory

Examine Azure Portal

Examine ARM template

Survey ADF artefacts

Create Your First ADF Pipeline

Lesson 2: Basic Data Movement

Copy Data Activity

Delete Activity

Stored Procedure Activity

Lesson 3: Pipeline Orchestration

Conditional, Lookup, ForEach Activities

Debugging

Manual triggers

Triggers

Lesson 4: Introduction to Mapping Data Flows

Lesson 5: Monitoring ADF

ADF Portal

Lesson 6: Azure-SSIS

Provision Azure-SSIS instance

Lifting and shifting on-premises SSIS to Azure-SSIS

Lesson 7: Enterprise ADF Execution Patterns

Leveraging the Parent-Child design pattern to build a metadata-driven SSIS execution engine.

Mixing pipeline and SSIS execution

About the Speaker

Andy Leonard

Chief Data Engineer, Enterprise Data & Analytics

Andy Leonard is founder and Chief Data Engineer at Enterprise Data & Analytics, Microsoft Data Platform MVP, author, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS Trainer, Consultant, and developer, a Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of The Biml Book and SQL Server Integration Services Design Patterns and author of Managing Geeks - A Journey of Leading by Doing, Data Integration Lifecycle Management with SSIS, Building Custom Tasks for SSIS, and the Stairway to Integration Services. Andy blogs at andyleonard.blog where you can learn more on the About Andy page. He may be followed on Twitter @AndyLeonard.

Share with friends

Date and Time

Location

Pittsburgh Technical College

1111 McKee Road

Oakdale, PA 15071

View Map

Refund Policy

Contact the organizer to request a refund.

Eventbrite's fee is nonrefundable.

Save This Event

Event Saved