Mastering Azure Data Factory: ETL & Data Engineering for Beginners

Categories: Microsoft Azure
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

In this course you will primarily be using Azure Data Factory on Microsoft Azure and Microsoft Fabric in addition to other services such as Azure Blob Storage, Azure Data Lake Storage Gen 2 and Azure SQL Database.

The course is packed with lectures, code-along videos and a dedicated course project. As an added benefit you will also have lifetime access to all of the lectures…

 

Outcome of This Course

By the end, students will:

  • Understand data engineering and ETL concepts deeply

  • Be confident in building, monitoring, and managing ADF pipelines

  • Have multiple hands-on projects in their portfolio

  • Be ready for entry-level data engineering interviews

Show More

What Will You Learn?

  • You will learn how to build a real-world data pipeline in Azure Data Factory (ADF).
  • You will acquire good Data Engineering skills in Azure using Azure Data Factory (ADF), Azure Data Lake Storage Gen2, Azure SQL Database and Azure Monitor.
  • You will learn how to ingest data from sources such as HTTP and Azure Blob Storage into Azure Data Lake Gen2 using Azure Data Factory (ADF).
  • You will learn how to transform data using Data Flows in Azure Data Factory (ADF) and load into Azure Data Lake Storage Gen2.
  • You will learn how to transform data using Databricks Notebook Activity in Azure Data Factory (ADF) and load into Azure Data Lake Storage Gen2.
  • You will learn how to transform data using Azure HDInsight Activity in Azure Data Factory (ADF) and load into Azure Data Lake Storage Gen2.
  • You will learn how to load transformed data from Azure Data Lake Storage Gen2 to Azure SQL Database using Azure Data Factory (ADF).
  • You will learn extensively about Triggers in Azure Data Factory (ADF) and how to use them to schedule the data pipelines.
  • You will learn how to monitor pipelines using Azure Data Factory (ADF), Azure Monitor and Log Analytics with a real-world project.
  • You will learn how to build production ready pipelines and good practices and naming standards.
  • You will learn the topics required on Azure Data Factory to pass the Azure Data Engineer Associate Certification Exam DP203.
  • You will learn about how to create CI/CD pipelines in Azure Devops to release ADF pipelines to higher environments (Testing/ Production).

Course Content

Welcome & Course Introduction

  • Welcome to the Course
  • What You Will Learn
  • Tools You’ll Need
  • How to Make the Most Out of This Course

Introduction to Data Engineering & ETL Concepts
Objective: Build strong foundational knowledge

Introduction to Azure Ecosystem
Objective: Provide context around where ADF fits

Azure Data Factory Basics
Objective: Hands-on ADF usage

Source & Sink Integrations
Objective: Work with real data sources

Transformation Activities
Objective: Build simple to complex pipelines

Real-time Scenarios with Data Flows
Objective: Work on realistic data transformation scenarios

Parameterization & Reusability
Objective: Make pipelines dynamic

Monitoring, Triggers & Error Handling
Objective: Production-ready practices

DevOps & CI/CD with ADF
Objective: Bring ADF to enterprise level

Capstone Projects
Objective: Apply all the knowledge in real-life scenarios

Career Guidance & Next Steps
Objective: Help students take the next step

Student Ratings & Reviews

No Review Yet
No Review Yet