DP-602T00 Implement a Data Warehouse with Microsoft Fabric
- 1 Day Course
- Language: English
Introduction:
Explore the data warehousing process and learn how to load, monitor, and query a warehouse in Microsoft Fabric.
Objectives:
Course Outline:
1 – Introduction to end-to-end analytics using Microsoft Fabric
- Explore end-to-end analytics with Microsoft Fabric
- Explore data teams and Microsoft Fabric
- Enable and use Microsoft Fabric
- Module assessment
2 – Get started with data warehouses in Microsoft Fabric
- Understand data warehouses
- Understand data warehouses in Fabric
- Query and transform data
- Model data in a warehouse
- Secure and monitor a warehouse
- Module assessment
3 – Load data into a Microsoft Fabric data warehouse
- Explore data load strategies
- Use data pipelines to load a warehouse
- Load data using T-SQL
- Load and transform data with Dataflow Gen2
- Module assessment
4 – Query a data warehouse in Microsoft Fabric
- Query data
- Use the SQL query editor
- Explore the visual query editor
- Use client tools to query a warehouse
- Module assessment
5 – Monitor a Microsoft Fabric data warehouse
- Monitor capacity metrics
- Monitor current activity
- Monitor queries
- Module assessment
6 – Secure a Microsoft Fabric data warehouse
- Explore dynamic data masking
- Implement row-level security
- Implement column-level security
- Configure SQL granular permissions using T-SQL
- Module assessment
Enroll in this course
$695.00