Azure Data Factory Training: Designing and Implementing Data Integration Solutions

Nivå: Intermediate

This course covers all key aspects of the Azure Data Factory v2 platform.

It is ideal for architects, developers, administrators, IT managers, and anyone else who would like to make the best possible use of this Azure service. Key areas covered include ADF v2 architecture, UI-based and automated data movement mechanisms, 10+ data transformation approaches, control-flow activities, reuse options, operational best-practises, and a multi-tiered approach to ADF security.

Special attention is paid to covering Azure services which are commonly used with ADF v2 solutions. These services are Azure Data Lake Storage Gen 2, Azure SQL Database, Azure Databricks, Azure Key Vault, Azure Functions, and a few others.

6 hands-on instructor-led labs are included with the course. These allow students to practise applying ADF v2 concepts and prepare them for real-world Azure data integration projects.

Page Sections

Du kommer lära dig att

Utbildningar

Innehåll och datum

FAQs

Relaterade kurser

Börja här

Nyckelfunktioner:

After-course instructor coaching benefit
Hands-on labs included

Du kommer lära dig att:

Build end-to-end ETL and ELT solutions using Azure Data Factory v2
Architect, develop and deploy sophisticated, high-performance, easy-to-maintain and secure pipelines that integrate data from a variety of Azure and non-Azure data sources.
Apply the latest DevOps best practises available for the ADF v2 platform.

Välj den utbildningsform som passar dig bäst

LIVE, LÄRARLEDD

I klass & Live, Online-utbildning

3-day instructor-led training course
One-on-one after-course instructor coaching
Tuition fee can be paid later by invoice -OR- at the time of checkout by credit card

Klicka här för kursinnehåll och datum

23950 SEK

Reservera din plats

PRODUCT #1231

UTBILDNING PÅ DIN ARBETSPLATS

Teamträning

Använd denna eller någon annan utbildning i ditt företag
Fullskalig programutveckling
Levereras när, var och hur du vill
Blandade utbildningsmodeller
Skräddarsytt innehåll
Coaching av ett expertteam

Anpassa kurs och innehåll efter teamets behov

Kontakta oss

Utveckla dig och ditt team med anpassade eller öppna kurser alternativt e-learning

Learning Tree erbjuder kundanpassad utbildning hos er, öppna kurser i Stockholm, London eller Washington, möjlighet att delta via våra Anywhere centers (Malmö, Göteborg, Linköping, Stockholm eller Borlänge) eller olika former av e-learning med lärarstöd. Läs mer på www.learningtree.se/priser .

I klass & Live, Online-utbildning

Timezone

Location

Date

Note: This course runs for 3 dagar

17 - 19 nov 9:00 - 16:30 CET Stockholm / Online (AnyWare) Boka Din Kursplats
30 mar - 1 apr 9:00 - 16:30 CEST Stockholm / Online (AnyWare) Boka Din Kursplats
Kurser i Storbritannien, när du deltar online via AnyWare går kursen 10:00-17:30 CET (svensk tid)

23 - 25 nov 9:00 - 16:30 GMT Online (AnyWare) Boka Din Kursplats
Kurser i Storbritannien, när du deltar online via AnyWare går kursen 10:00-17:30 CET (svensk tid)

15 - 17 feb 9:00 - 16:30 GMT Online (AnyWare) Boka Din Kursplats
Kurser i Storbritannien, när du deltar online via AnyWare går kursen 10:00-17:30 CET (svensk tid)

3 - 5 maj 9:00 - 16:30 BST Online (AnyWare) Boka Din Kursplats
Kurser i Storbritannien, när du deltar online via AnyWare går kursen 10:00-17:30 CET (svensk tid)

19 - 21 jul 9:00 - 16:30 BST Online (AnyWare) Boka Din Kursplats
Kurser i USA/Kanada, när du deltar online via AnyWare går kursen 15:00-22:30 CET (svensk tid)

3 - 5 nov 14:00 - 21:30 CCET Online (AnyWare) Boka Din Kursplats
Kurser i USA/Kanada, när du deltar online via AnyWare går kursen 15:00-22:30 CET (svensk tid)

1 - 3 dec 15:00 - 22:30 CCET Herndon, VA / Online (AnyWare) Boka Din Kursplats
Kurser i USA/Kanada, när du deltar online via AnyWare går kursen 15:00-22:30 CET (svensk tid)

5 - 7 jan 15:00 - 22:30 CCET New York / Online (AnyWare) Boka Din Kursplats
Kurser i USA/Kanada, när du deltar online via AnyWare går kursen 15:00-22:30 CET (svensk tid)

2 - 4 feb 15:00 - 22:30 CCET Ottawa / Online (AnyWare) Boka Din Kursplats
Kurser i USA/Kanada, när du deltar online via AnyWare går kursen 15:00-22:30 CET (svensk tid)

23 - 25 feb 15:00 - 22:30 CCET Herndon, VA / Online (AnyWare) Boka Din Kursplats
Kurser i USA/Kanada, när du deltar online via AnyWare går kursen 15:00-22:30 CET (svensk tid)

4 - 6 maj 15:00 - 22:30 CCST Ottawa / Online (AnyWare) Boka Din Kursplats
Kurser i USA/Kanada, när du deltar online via AnyWare går kursen 15:00-22:30 CET (svensk tid)

1 - 3 jun 15:00 - 22:30 CCST Herndon, VA / Online (AnyWare) Boka Din Kursplats
Kurser i USA/Kanada, när du deltar online via AnyWare går kursen 15:00-22:30 CET (svensk tid)

6 - 8 jul 15:00 - 22:30 CCST New York / Online (AnyWare) Boka Din Kursplats
Kurser i USA/Kanada, när du deltar online via AnyWare går kursen 15:00-22:30 CET (svensk tid)

3 - 5 aug 15:00 - 22:30 CCST Ottawa / Online (AnyWare) Boka Din Kursplats
Kurser i USA/Kanada, när du deltar online via AnyWare går kursen 15:00-22:30 CET (svensk tid)

31 aug - 2 sep 15:00 - 22:30 CCST Herndon, VA / Online (AnyWare) Boka Din Kursplats

Kurs med startgaranti

När du ser symbolen för “Guaranteed to Run” vid ett kurstillfälle vet du att kursen blir av. Garanterat.

Important Azure Data Factory Training Information

Prerequisites

Microsoft Azure Fundamentals Training (AZ-900T00) or equivalent experience.

Azure Data Factory Training Outline

Introduction to ADF
- Historical background: SSIS, ADF v1, other ETL/ELT tools
- Key capabilities and benefits of ADF v2
- Recent feature updates and enhancements
Core Architectural Components
- Connectors: Azure services, databases, NoSQL, files, generic protocols, services & apps, custom
- Pipelines
- Activities: data movement, data transformation, control flow
- Datasets: source, sink
- Integration Runtimes: Azure, Self-Hosted, Azure-SSIS
Building and Executing Your First Pipeline
- Creating ADF v2 instance
- Creating a pipeline and associated activities
- Executing the pipeline
- Monitoring execution
- Reviewing results
Data Movement
Copying Tools and SDKS
- Copy Data Tool/Wizard
- Copy activity
- SDKs: Python, .NET
- Automation: PowerShell, REST API, ARM Templates
Copying Considerations
- File formats: Avro, binary, delimited, JSON, ORC, Parquet
- Data store support matrix
- Write behaviour: append, upsert, overwrite, write with custom logic
- Schema and data type mapping
- Fault tolerance options
Data Transformation
Transformation with Mapping Data Flows
- Introduction to mapping data flows
- Data flow canvas
- Debug mode
- Dealing with schema drift
- Expression builder & language
- Transformation types: Aggregate, Alter row, Conditional split, Derived column, Exists, Filter, Flatten, Join, Lookup, New branch, Pivot, Select, Sink, Sort, Source, Surrogate key, Union, Unpivot, Window
Transformation with External Services
- Databricks: Notebook, Jar, Python
- HDInsight: Hive, Pig, MapReduce, Streaming, Spark
- Azure Machine Learning service
- SQL Stored procedures
- Azure Data Lake Analytics U-SQL
- Custom activities with .NET or R
Control Flow
- Purpose of activity dependencies: branching and chaining
- Activity dependency conditions: succeeded, failed, skipped, completed
- Control flow activities: Append Variable, Azure Function, Execute Pipeline, Filter, ForEach, Get Metadata, If Condition, Lookup, Set Variable, Until, Wait, Web
Runtime and Operations
- Debugging
- Monitoring: visual, Azure Monitor, SDKs, runtime-specific best practises
- Scheduling execution with triggers: event-based, schedule, tumbling window
- Performance, scalability, tuning
- Common troubleshooting scenarios in activities, connectors, data flows and integration runtimes
DevOps with ADF
- Quick introduction to source control with Git
- Integration with GitHub and Azure DevOps platforms
- Environment management: Development, QA, Production
- Iterative development best practises
- Continuous Integration (CI) pipelines
- Continuous Delivery (CD) pipelines
Promoting Reuse
- Templates: out-of-the-box and organisational
- Parameters
- Naming convention
Security
- Data movement security
- Azure Key Vault
- Self-hosted IR considerations
- IP address blocks
- Managed identity

Teamträning

Azure Data Factory Training FAQs

What is Azure Data Factory?

Azure Data Factory (ADF) v2 is an Azure data integration service which allows creation of data-driven workflows to orchestrate and automate data movement and transformation across cloud, on-prem and hybrid environments.
How much ADF experience do I need to sit for this course?

While this new course is designed to bring students from zero expertise with ADF v2 to an intermediate or even advanced level of knowledge, Microsoft Azure Fundamentals Training (AZ-900T00) or equivalent is expected.

Hur föredrar du att bli kontaktad:

Telefon E-post

Azure Data Factory Training: Designing and Implementing Data Integration Solutions

Nivå: Intermediate

Du kommer lära dig att

Utbildningar

Innehåll och datum

FAQs

Relaterade kurser

Börja här

Nyckelfunktioner:

Du kommer lära dig att:

Välj den utbildningsform som passar dig bäst

I klass & Live, Online-utbildning

Teamträning

Utveckla dig och ditt team med anpassade eller öppna kurser alternativt e-learning

I klass & Live, Online-utbildning

Note: This course runs for 3 dagar

Important Azure Data Factory Training Information

Prerequisites

Azure Data Factory Training Outline

Introduction to ADF

Core Architectural Components

Building and Executing Your First Pipeline

Data Movement

Data Transformation

Control Flow

Runtime and Operations

DevOps with ADF

Promoting Reuse

Security

Teamträning

Azure Data Factory Training FAQs

What is Azure Data Factory?

How much ADF experience do I need to sit for this course?

Relaterade kurser

Why do we require your location?

Kontakta oss

Utbildning och organisationsutveckling

Företag eller organisation

FÖLJ OSS PÅ

Please Choose a Language

Canada - English

Canada - Français