Implement a Data Warehouse with Microsoft Fabric (DP-602)
- Course Code M-DP602
- Duration 1 day
Course Delivery
Jump to:
Course Delivery
This course is available in the following formats:
-
Company Event
Event at company
-
Public Classroom
Traditional Classroom Learning
-
Virtual Learning
Learning that is virtual
Request this course in a different delivery format.
Course Overview
TopExplore 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).
Virtual Learning
This interactive training can be taken from any location, your office or home and is delivered by a trainer. This training does not have any delegates in the class with the instructor, since all delegates are virtually connected. Virtual delegates do not travel to this course, Global Knowledge will send you all the information needed before the start of the course and you can test the logins.
Course Schedule
Top-
- Delivery Format: Virtual Learning
- Date: 19 August, 2025
- Location: Virtual
-
- Delivery Format: Virtual Learning
- Date: 14 October, 2025
- Location: Virtual
-
- Delivery Format: Virtual Learning
- Date: 25 November, 2025
- Location: Virtual
Target Audience
TopStudents wishing to Implement a data warehouse with Microsoft Fabric
Course Objectives
TopStudents 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
TopModule 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
TopYou should be familiar with basic data concepts and terminology.
Test Certification
TopExam DP-600: Implementing Analytics Solutions Using Microsoft Fabric (beta)
- /-/media/global-knowledge/rte-images/campaigns-and-promotions/aws_awardwebbanner.jpg?sc_lang=en-be https://www.globalknowledge.com/us-en/company/awards/ #000000
