From Zero to ADF

Pittsburgh SQL Server Users Group

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

Pittsburgh Technical College

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 &amp; Analytics
Andy Leonard is founder and Chief Data Engineer at Enterprise Data &amp; 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.

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

From Zero to ADF

More events from Pittsburgh SQL Server Users Group

Discover more events from Pittsburgh SQL Server Users Group, from Science & Tech to other experiences you might love.

From Zero to ADF

More events from Pittsburgh SQL Server Users Group

Discover more events from Pittsburgh SQL Server Users Group, from Science & Tech to other experiences you might love.

More Science & Tech events

Browse more Science & Tech events with different dates, prices, and formats to find your next great experience.