The DP-602T00: Implement a Data Warehouse with Microsoft Fabric course teaches data professionals to build data warehouse solutions in Microsoft Fabric. This 8-hour applied skills course covers warehouse creation, T-SQL development, data loading, table design, query optimization, and security configuration. Esamatic srl, a Microsoft Learning Partner in Milan, delivers this course with Microsoft Certified Trainers.

Fabric Data Warehouse: create and manage warehouses in Microsoft Fabric workspaces
T-SQL Development: write queries, create views, stored procedures, and functions
Data Loading: ingest data using COPY, pipelines, and dataflows Gen2
Table Design: dimensional modeling, distribution strategies, and partitioning

Course Overview: DP-602T00

The Microsoft Fabric data warehouse provides a modern SQL-based analytics experience on top of OneLake. The DP-602T00 course teaches practical skills in building enterprise data warehouses using familiar T-SQL within the Fabric unified analytics platform.

Learning Objectives

Create a Fabric warehouse — set up workspace, create warehouse, and understand the SQL analytics endpoint
Load and transform data — use COPY command, pipelines, and T-SQL for data ingestion and transformation
Design tables and models — implement star schema, manage tables, and optimize for query performance
Secure and monitor — configure column-level security, dynamic data masking, and monitor warehouse performance

Who Should Attend

The DP-602T00 is for data engineers, SQL developers, and BI professionals building data warehouses with Microsoft Fabric.

Frequently Asked Questions

What is a data warehouse in Microsoft Fabric?

A Fabric data warehouse is a SQL-based analytics store within the Fabric platform that supports full T-SQL querying, dimensional modeling, and integration with Power BI for enterprise business intelligence on OneLake data.