Prices shown in US dollars.
Find my training Basket 0
Microsoft

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

Explore the data warehousing process and learn how to load, monitor, and query a warehouse in Microsoft Fabric. This learning path helps prepare you for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric (beta).

GK #M-DP602Company EventPublic ClassroomVirtual Learning
Duration1 dayFormatsCompany Event · Public Classroom · Virtual LearningTopicsApplied Skills · Cloud Computing · Data · Ms Elite · Polaris Discovery

What you’ll learn

Target Audience

Students wishing to Implement a data warehouse with Microsoft Fabric

Course Objectives

Students will learn 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

 

Course Content

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 Prerequisites

You should be familiar with basic data concepts and terminology.

Test Certification

Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric (beta)

Upcoming training

Dates and availability are confirmed by Bolt when we follow up. All times are shown in the provider’s stated time zone.

2026-12-18 — 2026-12-189:00 AM to 5:00 PM
Virtual LearningVirtual (Eastern Standard Time) · English
2027-03-10 — 2027-03-108:30 AM to 4:30 PM
Virtual LearningVirtual (Eastern Standard Time) · English
2027-06-11 — 2027-06-118:30 AM to 4:30 PM
Virtual LearningVirtual (Eastern Standard Time) · English
2027-08-30 — 2027-08-308:30 AM to 4:30 PM
Virtual LearningVirtual (Eastern Standard Time) · English
2027-11-24 — 2027-11-248:30 AM to 4:30 PM
Virtual LearningVirtual (Eastern Standard Time) · English