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-fabric/classroom/4a13f708?md=6db397d9a85740ef954720a69d7ede88 Catch-up on the DP-700 Exam Prep Playlist: https://www.youtube.com/playlist?list=PLug2zSFKZmV2Ue5udYFeKnyf1Jj0-y5Gy 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