Data Warehouse | Azure | Data Modeling | Azure Data Engineer
In this video, you’ll learn Azure Data Warehouse from the scratch. We’ll cover everything—from the basics like ETL, incremental data loading, dimensional modeling, and medallion architecture, to advanced concepts like Azure Pipelines, PySpark transformations, external tables, and slowly changing dimensions. It’s all packed into one complete video!
Timestamps:
0:00 Introduction
08:10 What is a Cloud Data Warehouse?
18:22 Azure SQL Database vs Azure Datawarehouse
21:11 What is Cloud Data Warehousing?
26:20 ETL - Extract Transform Load
37:00 Azure Free Account
40:01 Azure Overview
46:17 Creating Azure Synapse Analytics Resource
58:14 Azure Synapse Analytics Overview
1:01:58 ETL Pipelines in Azure
1:11:36 Incremental Data Loading in Azure
1:21:43 Data Transformation using PySpark Data Flows
1:41:02 Serverless SQL Datawarehouse in Azure
1:47:50 External Data Sources in Azure
2:08:01 Openrowset Function
2:13:16 External Tables in Azure Synapse Analytics
2:24:27 Schema Handling
2:33:06 Azure End-To-End Data Pipeline
2:37:43 Data Modeling
2:42:55 Dimensional Data Modeling
2:47:45 STAR schema vs SNOWFLAKE schema
2:51:09 Creating Dimension Tables using CETAS
3:19:17 Creating Fact Table
3:32:09 STAR schema in Azure
3:42:14 Slowly Changing Dimensions
WATCH MY PREVIOUS VIDEOS
➡️Azure End To End Data Project
https://youtu.be/uc-u_juRg-w?si=sO_CavjnhNaSnZri
➡️Databricks Tutorial
https://youtu.be/7pee6_Sq3VY?si=pPBrTnE2R8PhhHu5
➡️PySpark Full Course
https://youtu.be/94w6hPk7nkM?si=i3u_8ZWkGf6fiGyh
REPOSITORY
➡️GitHub
https://github.com/anshlambagit/Azure-Datawarehouse
=======================================
Join this channel to SUPPORT MY HARDWORK:
https://www.youtube.com/channel/UCu7lQE-L5gzt8aD7zuuufjw/join
=======================================
Connect with ME
LinkedIn - https://www.linkedin.com/in/ansh-lamba-793681184/
Telegram - https://t.me/anshlambadatafam
Twitter - https://x.com/AnshLambaJSR
=========================
For COLLABORATION 👇
[email protected]
=========================
⭐Hashtags⭐
#azure #datawarehouse #datamodeling #dataengineering