Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Master Data Warehousing | Dimensional Modeling, ETL & SQL
New
10 students

Master Data Warehousing | Dimensional Modeling, ETL & SQL

Master SCD Types 0–6, Fact & Dimension Tables, Surrogate Keys and Data Warehouse Fundamentals
New
Created byAtchyut Kumar, Edufulness EFN
Last updated 8/2026
English
French [Auto],Italian [Auto],

What you'll learn

  • You will learn how to build a real time data pipeline in Azure Data Factory (ADF).
  • You will learn how to transform data using Data Flows in Azure Data Factory (ADF) and load into ADLS2, Blob storage.
  • You will learn how to ingest JSON data from SQL Server to API end point.
  • You will learn how to build production ready pipelines and good practices and naming standards.
  • 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 about manual/Triggers in Azure Data Factory (ADF) and how to use them to schedule the data pipelines.
  • Create Data driven, fully integrated, dynamic and automated production grade pipeline creation and orchestration.
  • Data Warehousing Concepts like Fact & dimension tables, SCD type1, type2, Incremental loading and implement using ADF.
  • Connect & copy data from On Premise data stores, On premise SQL server via Self Hosted Integration Runtime to cloud.
  • How to ingest data from sources such as REST API, Azure Blob Storage, SQL DB into Azure Data Lake Gen2 using Azure Data Factory (ADF)
  • Learn Azure Data Factory(ADF) with real time projects - ADF, SQL Server, Blob Storage, Datalake G1,G2, REST API.

Course content

4 sections • 14 lectures • 1h 58m total length

  • Introduction2:22
  • What is a Data warehouse4:12

Requirements

  • Basic concepts about cloud computing will be useful, but not mandatory.
  • An Azure Account is required, If not, we will create a free account in the course.

Description

Master Slowly Changing Dimensions (SCD Types 0–6) in Data Warehousing

Learn one of the most important concepts in Data Warehousing and Data Engineering with simple explanations and real-world examples.

This course covers everything you need to understand Slowly Changing Dimensions (SCD Types 0–6), along with essential Data Warehouse concepts such as Candidate Key, Primary Key, Foreign Key, Surrogate Key, Fact Tables, and Dimension Tables.

Whether you're preparing for Data Engineering interviews, working with ETL tools like Azure Data Factory, or building a strong foundation in Data Warehousing, this course will help you understand when and why each SCD type is used in real-world projects.

What You'll Learn

  • Data Warehouse Fundamentals

  • Candidate, Primary, Foreign & Surrogate Keys

  • Fact & Dimension Tables

  • Introduction to Slowly Changing Dimensions

  • SCD Types 0, 1, 2, 3, 4, 5 & 6

  • Real-world business scenarios

  • Interview-focused discussions and best practices

Who Should Enrol?

  • Data Engineers

  • ETL Developers

  • Azure Data Factory Developers

  • SQL Developers

  • BI Professionals

  • Computer Science Students

  • Anyone preparing for Data Engineering interviews

After Completing This Course

You will be able to:

  • Understand Data Warehouse fundamentals

  • Differentiate Fact and Dimension tables

  • Select appropriate keys for warehouse design

  • Explain every Slowly Changing Dimension type

  • Decide which SCD strategy fits a business requirement

  • Answer SCD interview questions confidently

  • Build a strong foundation for advanced Data Warehousing concepts

By the end of this course, you'll have a solid understanding of Slowly Changing Dimensions and be ready to apply these concepts confidently in Data Warehousing projects and interviews.

Who this course is for:

  • For all levels.
  • Students, Working Professionals

Report abuse