After this day you can build a data warehouse in Microsoft Fabric and maintain it with familiar T-SQL. You load data through pipelines, T-SQL or Dataflow Gen2, choose between full and incremental loads and handle changing dimensions. You query the warehouse with different editors, monitor activity and protect sensitive data with masking and row-level or column-level security. The course suits data analysts and data engineers who know SQL and are introducing Fabric as their analytics platform.
What you’ll take away.
- Understand the structure and T-SQL capabilities of a Fabric data warehouse
- Load data fully or incrementally with pipelines, T-SQL and Dataflow Gen2
- Query the warehouse with the SQL editor, the visual query editor and external tools
- Monitor activity in the warehouse
- Protect data with dynamic data masking and row-level and column-level security
Your training in detail
- Who is it for?
- Data analysts and data engineers who build or maintain a relational data warehouse in Microsoft Fabric.
- Prerequisites
- You know the basics of data modelling, extraction and analysis, can write simple SQL queries and have already found your way around the Fabric interface.
- Format & planning
- Standard length: 1 training day. A different length can be arranged for companies.
Agenda: from understanding to application
Our independently developed agenda proposal. Focus areas, lab environment and scope are agreed before booking.
Overview of end-to-end analytics with Microsoft Fabric
Data warehouses in Fabric: tables, views and T-SQL
Loading data: pipelines, T-SQL and Dataflow Gen2, full and incremental
Slowly changing dimensions in the load process
Querying with the SQL editor, the visual editor and SQL Server Management Studio
Copilot for T-SQL, monitoring and securing the warehouse
You build a small star schema for sales data, load it incrementally, answer business questions in T-SQL and use row-level security to hide other regions from a sales role.
Exams, licences & credentials
There is no Microsoft exam for this course, so the course ends without a certification exam. It is not an official Microsoft course unless the offer explicitly says so.
Vendor references & review date
Sources checked on 2026-11-10. These sources describe the technology or external exam requirements. They do not imply a partnership with NextNowa.
Your learning content
These objectives describe the training topic. The specific syllabus, dates and trainer are agreed before booking; the written offer is binding.
Frequently asked questions
When should I use a warehouse rather than a lakehouse in Fabric?
The warehouse offers full T-SQL support including transactions and suits teams that work relationally with SQL. The course focuses on the warehouse.
Do I need prior Fabric experience?
You should be able to find your way around the Fabric interface. The course starts with a short overview of Fabric before moving to the warehouse.
Does DP-602 Implement a Data Warehouse with Microsoft Fabric: loading, querying and securing with T-SQL include a certificate?
There is no Microsoft exam for this course, so the course ends without a certification exam. It is not an official Microsoft course unless the offer explicitly says so.