DP-602 - Implement a Data Warehouse with Microsoft Fabric
Course Duration: 7 Hours
Delivery Methods: Classroom Training - Instructor Led or Online
COURSE OVERVIEW
This course introduces fundamentals concepts related to data warehousing process. Participants will explore the data warehousing process and learn how to load, monitor, and query a warehouse in Microsoft Fabric.
WHO SHOULD ATTEND?
Anyone can participate. It will help if you are familiar with basic data concepts and terminology.
COURSE OBJECTIVES
- Get started with data warehouses in Microsoft Fabric
- Load data into a Microsoft Fabric data warehouse
- Query a data warehouse in Microsoft Fabric
- Monitor a Microsoft Fabric data warehouse
Course Outline
- 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
- Explore data load strategies
- Use data pipelines to load a warehouse
- Load data using T-SQL
- Load and transform data with Dataflow Gen2
- Use the SQL query editor
- Explore the visual query editor
- Use client tools to query a warehouse
- Monitor capacity metrics
- Monitor current activity
- Monitor queries
| Dates & Times |
|---|
* Actual dates may vary.