Скачать или смотреть T-SQL & Dimensional Modeling in Microsoft Fabric | DP-700 EXAM PREP (7 of 11)

Access DP-700 study notes, 90+ Fabric tutorials and live study sessions: https://skool.com/fabricdojo/about

The notebook for this exercise has also been placed in our free Skool community: https://www.skool.com/microsoft-fabri...

Catch-up on the DP-700 Exam Prep Playlist:    • DP-700 Exam Preparation  

This series is aimed at helping you pass the DP-700 exam, to become a certified Microsoft Fabric Data Engineer.

In this video, we cover T-SQL and Dimensional Modelling techniques:
Table Creation / Data Ingestion Methods for a Fabric Data Warehouse
Primary Keys and Surrogate Keys
Dimensional modeling in T-SQL (Joins, SCDs, Facts)
implementing security in a Fabric Data Warehouse

Timeline:
0:00 Intro
2:47 Data creation & ingestion
7:30 Primary Key Constraints and Surrogate Keys
15:11 Dimensional Modeling Intro
17:59 Joins
22:05 Construction of Facts & Dimensions
23:31 Slowly-Changing Dimensions
28:11 Implement RLS, OLS, CLS
31:20 Implement dynamic data masking
33:07 Outro

#microsoftfabric #dp700 #dataengineering