Implement a Data Warehouse with Microsoft Fabric (DP-602)

Course Outline

Explore the data warehousing process within Microsoft Fabric in this comprehensive 1-day course. You'll learn to load, monitor, and query a data warehouse efficiently, leveraging Microsoft Fabric's robust features.

Implement a Data Warehouse with Microsoft Fabric (DP-602) Benefits

In this course, you will learn how to:
- 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.
Prerequisites
- Familiarity with data modeling, data transformation, and exploratory data analytics.
- Ability to query and change data using T-SQL.
Certification Information

This course does not directly prepare you for a certification exam but is part of Microsoft's applied skills program, enhancing data engineering competencies.

DP-602 Course Outline

Introduction to Data Warehouses in Microsoft Fabric

Understand the fundamentals of data warehouses and their role in Microsoft Fabric for analytical purposes.

Load Data into a Microsoft Fabric Data Warehouse

Explore strategies for loading data into a data warehouse in Microsoft Fabric, utilizing data pipelines, T-SQL, and Dataflow Gen for efficient data management.

Query a Data Warehouse in Microsoft Fabric

Learn to query data warehouses in Microsoft Fabric using SQL query editors, visual query editors, and client tools for effective data analysis and retrieval.

Monitor a Microsoft Fabric Data Warehouse

Discover how to monitor capacity metrics, current activity, and queries in a Microsoft Fabric data warehouse to ensure efficient operation and performance optimization.

Implement a Data Warehouse with Microsoft Fabric (DP-602)

Course Outline