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 – Get started with data warehouses in Microsoft Fabric
- Understand data warehouse fundamentals
- Understand data warehouses in Fabric
- Query and transform data
- Prepare data for analysis and reporting
- Secure and monitor your data warehouse
2 – Load data into a Microsoft Fabric data warehouse
- Explore data load strategies
- Use data pipelines to load a warehousev
- Load data using T-SQL
- Load and transform data with Dataflow Gen2
3 – Query a data warehouse in Microsoft Fabric
- Use the SQL query editor
- Explore the visual query editor
- Use client tools to query a warehouse
4 – Monitor a Microsoft Fabric data warehouse
- Monitor capacity metrics
- Monitor current activity
- Monitor queries