• 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 SlowlyChaning Dimensions. I also explain how to build relationships between facts and SCD type2 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 basicsSchema normalization
05:42 Primary keys, foreign keys, star schema, onetomany 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 SlowlyChanging 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/fikratazizov865a0528
and X: @fikrat_azizov


Official Documentation:
https://learn.microsoft.com/enus/fab...
https://www.kimballgroup.com/datawar...
https://learn.microsoft.com/enus/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