Implement a Data Warehouse with Microsoft Fabric (DP-602)
The DP-602T00: Implement a Data Warehouse with Microsoft Fabric course teaches participants how to implement data warehouses using Microsoft
Fabric, focusing on data storage, ETL processes, and optimizing query performance for analytics.
Retail Price: $795.00
Next Date: 10/14/2025
Course Days: 1
Enroll in Next Date
Request Custom Course
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
Target Audience
• Data Analyst
• Data Engineer
Prerequisites Recommended:
• You should be familiar with basic data concepts and terminology.
COURSE OUTLINE
Module 1: Get started with data warehouses in Microsoft Fabric
- Describe data warehouses in Fabric
- Understand a data warehouse vs a data Lakehouse
- Work with data warehouses in Fabric
- Create and manage fact tables and dimensions within a data warehouse
Module 2: Load data into a Microsoft Fabric data warehouse
- Learn different strategies to load data into a data warehouse in Microsoft Fabric.
- Learn how to build a data pipeline to load a warehouse in Microsoft Fabric.
- Learn how to load data in a warehouse using T-SQL.
- Learn how to load and transform data with dataflow (Gen 2).
Module 3: Query a data warehouse in Microsoft Fabric
- Use SQL query editor to query a data warehouse.
- Explore how visual query editor works.
- Learn how to connect and query a data warehouse using SQL Server Management Studio.
Module 4: Monitor a Microsoft Fabric data warehouse
- Monitor capacity unit usage with the Microsoft Fabric Capacity Metrics app.
- Monitor current activity in the data warehouse with dynamic management views.
- Monitor querying trends with query insights views.
Course Dates | Course Times (EST) | Delivery Mode | GTR | |
---|---|---|---|---|
10/14/2025 - 10/14/2025 | 10:00 AM - 6:00 PM | Virtual | Enroll | |
12/11/2025 - 12/11/2025 | 10:00 AM - 6:00 PM | Virtual | Enroll | |
2/4/2026 - 2/4/2026 | 10:00 AM - 6:00 PM | Virtual | Enroll | |
4/1/2026 - 4/1/2026 | 10:00 AM - 6:00 PM | Virtual | Enroll | |
6/3/2026 - 6/3/2026 | 10:00 AM - 6:00 PM | Virtual | Enroll |