T-SQL & Dimensional Modeling in Microsoft Fabric | DP-700 EXAM PREP (7 of 11)
Автор: Learn Microsoft Fabric with Will
Загружено: 2025-03-04
Просмотров: 6877
Описание:
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
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: