6.04 Data Modelling in Synapse Warehouse

   • Microsoft Fabric For Beginners  
In this video, I explain fundamental concepts of data modelling, like schema normalization, primary keys, unique keys and foreign keys. I also explain dimensional modelling principles by Kimball and explore different types of Slowly-Chaning Dimensions. I also explain how to build relationships between facts and SCD type-2 dimensions. Next, I demonstrate the creation of primary, unique keys and foreign keys in Synapse Warehouse
Chapters:
00:00- Introduction
00:31- Preview
02:38- Modelling basics-Schema normalization
05:42- Primary keys, foreign keys, star schema, one-to-many relationships
06:35- What are the benefits of primary keys, unique keys and foreign keys in OLTP databases
07:43- How modelling is different in Data Warehouses
09:50- Slowly-Changing Dimensions(SCD). Common SCD types
11:28- Typical SCD Type 2 table structure, surrogate keys vs natural keys
13:17- How to build relationships between facts and type 2 SCD dimensions
14:03- Demo 1: Creating Primary keys, Unique keys and Foreign keys in Synapse Warehouse
17:22- Using system views to get information on table constraints
19:08- How to generate unique values
22:46- Creating constraints and table relationships visually

You can download the demo artifacts here:
SQL Script: https://github.com/fazizov/youtube/bl...

Please subscribe:    / @fazizov  
Follow me on Linkedin: www.linkedin.com/in/fikrat-azizov-865a0528
and X: @fikrat_azizov


Official Documentation:
https://learn.microsoft.com/en-us/fab...
https://www.kimballgroup.com/data-war...
https://learn.microsoft.com/en-us/azu...

Hashtags:
#microsoftfabric ,#datawarehouse, #dataengineering, #azure,#microsoft,#cloudcomputing, #dataanalytics, #lakehouse, #azuretutorial, #azuretraining, #datapipeline, #dataextraction , #dataintegration, #datatransfer, #dataflow, #spark, #deltalake, #synapse, #synapsedataenginering, #demo, #datalake, #transformation, #ingested, #dataintegration, #azuredatabricks ,#databricks, #bigdata, #bigdatatechnologies, #pyspark, #sparksql, #notebook ,#transformationvideo, #bronze, #medallion , #modeling, #facts, #silver, #gold, #historical data, #timetravel, #incremental,#datafactory, #dataactivator, #mirroring, #dimensions, #datamodeling