Microsoft Private Public

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

1 day
Microsoft FabricDatabases

Learn to implement a Microsoft Fabric data warehouse, load and query data, use Copilot, monitor performance, and apply granular warehouse security controls.

Talk to a Learning ConsultantRegister for a Public ClassRequest a Private Class

Register or Request Training

Price per student
$681.10
Guaranteed to run
Select a date
Please select a class.
Interested in a private class?
  • Private class for your team
  • Live expert instructor
  • Online or on‑location
  • Customizable agenda
  • Proposal responses same day as request
Request Proposal

Course Overview

Explore the end-to-end data warehousing process in Microsoft Fabric. Learn how to load, transform, model, query, monitor, and secure warehouse data, and use Copilot features to support data warehouse development.

Course Benefits

  • Understand end-to-end analytics and data warehousing in Microsoft Fabric.
  • Load and transform warehouse data with pipelines, T-SQL, and Dataflow Gen2.
  • Query warehouse data using SQL, visual tools, and client applications.
  • Use Copilot code completion, chat, and quick actions for data warehouse tasks.
  • Monitor capacity, activity, and queries.
  • Protect warehouse data with dynamic data masking, row-level security, column-level security, and granular SQL permissions.

Delivery Methods

Public Class
Live expert-led online training from anywhere. Guaranteed to run .
Private Class
Delivered for your team at your site or online.

Microsoft Certified Partner

Webucator is a Microsoft Certified Partner. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).

Microsoft Certified Partner

Course Outline

  1. Introduction to end-to-end analytics using Microsoft Fabric
    1. Explore end-to-end analytics with Microsoft Fabric
    2. Explore data teams and Microsoft Fabric
    3. Enable and use Microsoft Fabric
    4. Module assessment
  2. Get started with data warehouses in Microsoft Fabric
    1. Understand data warehouses
    2. Understand data warehouses in Fabric
    3. Query and transform data
    4. Model data in a warehouse
    5. Secure and monitor a warehouse
    6. Module assessment
  3. Load data into a Microsoft Fabric data warehouse
    1. Explore data load strategies
    2. Use data pipelines to load a warehouse
    3. Load data using T-SQL
    4. Load and transform data with Dataflow Gen2
    5. Module assessment
  4. Query a data warehouse in Microsoft Fabric
    1. Query data
    2. Use the SQL query editor
    3. Explore the visual query editor
    4. Use client tools to query a warehouse
    5. Module assessment
  5. Get started with Copilot in Microsoft Fabric for Data Warehouse
    1. Use Copilot code completion in Microsoft Fabric's Data Warehouse
    2. Use Copilot chat in Microsoft Fabric's Data Warehouse
    3. Use Copilot quick actions in Microsoft Fabric's Data Warehouse
    4. Review best practices using Copilot in Microsoft Fabric's Data Warehouse
    5. Module assessment
  6. Monitor a Microsoft Fabric data warehouse
    1. Monitor capacity metrics
    2. Monitor current activity
    3. Monitor queries
    4. Module assessment
  7. Secure a Microsoft Fabric data warehouse
    1. Explore dynamic data masking
    2. Implement row-level security
    3. Implement column-level security
    4. Configure granular SQL permissions using T-SQL
    5. Module assessment

Class Materials

Each student receives a comprehensive set of materials, including course notes and all class examples.

Class Prerequisites

Experience in the following would be useful for this Microsoft Fabric class:

Familiarity with basic data concepts and terminology is recommended.

Have questions about this course?

We can help with curriculum details, delivery options, pricing, or anything else. Reach out and we’ll point you in the right direction.

Talk to a Learning Consultant