Intermediate

ETL Pipelines with Azure Databricks and Data Factory

Build ETL with Spark and PySpark, Unity Catalog governance, Delta Lake and Databricks vs Data Factory.

Course: Build and Run ETL Pipelines with Azure Databricks and Azure Data Factory Level: Intermediate / Advanced | Platform: Azure Databricks + Azure Data Factory

Sign in to read this course

A free account unlocks all 514 courses. 20 are readable without one.

What's inside

36 sections
  1. 1 Table of Contents
  2. 2 Introduction to ETL and Apache Spark
  3. 3 Azure Databricks Architecture
  4. 4 Unity Catalog — Centralized Governance
  5. 5 Databricks vs Azure Data Factory
  6. 6 Environment Setup
  7. 7 Connecting to Azure Data Lake Storage from Databricks
  8. 8 Apache Spark DataFrames — Fundamentals
  9. 9 Schema Definition
  10. 10 Data Analysis and Cleaning
  11. 11 Business Transformations with PySpark
  12. 12 SQL Queries on DataFrames
  13. 13 Handling Corrupted Data
  14. 14 Delta Lake — Foundations and Architecture
  15. 15 Writing to Data Lake and Delta Tables
  16. 16 DML Operations on Delta Tables
  17. 17 Delta Lake Performance Optimizations
  18. 18 Delta Lake Auto-Optimization
  19. 19 Automation with Databricks Workflows
  20. 20 Parameterizing Notebooks with Widgets
  21. 21 Task Values and Dependencies Between Tasks
  22. 22 Triggers and Job Automation
  23. 23 Git Integration with Databricks
  24. 24 Orchestration with Azure Data Factory
  25. 25 Invoking Databricks from Data Factory
  26. 26 Automating ADF Pipelines with Triggers
  27. 27 Advanced ETL Architecture Patterns
  28. 28 Summary and Best Practices
  29. 29 Glossary
  30. 30 Module 2 – Transforming Data with PySpark
  31. 31 Module 3 – Delta Lake
  32. 32 Module 4 – Delta Performance Optimization
  33. 33 Module 5 – Automating Pipelines (Databricks Workflows)
  34. 34 Module 6 – Orchestration with Azure Data Factory
  35. 35 General Best Practices
  36. 36 Module 7 – ETL Architecture with Databricks: Medallion Architecture

Interested in this course?

Contact us to book it or get a custom training plan for your team.