You need to build a modern data warehouse but want to avoid the complexity of traditional on-premises solutions? Microsoft Fabric offers a fully managed data warehouse experience with T-SQL compatibility and seamless integration with the broader analytics platform. Without proper skills, designing an efficient warehouse architecture in Fabric can lead to performance and cost issues.
This official Microsoft DP-602 Applied Skills training enables you in 1 day to implement a data warehouse using Microsoft Fabric. Guided by MCT-certified trainers, you learn to design and create warehouse schemas, ingest data using pipelines and COPY INTO statements, implement slowly changing dimensions, manage security with row-level and column-level controls, and query data across lakehouses and warehouses. This hands-on credential validates your data warehousing skills on Microsoft Fabric. Sessions are available in person in Geneva and Lausanne or via virtual classroom.
Module 1 : Introduction to end-to-end analytics using Microsoft Fabric
Module 2 : Get started with data warehouses in Microsoft Fabric
Module 3 : Load data into a Microsoft Fabric data warehouse
Module 4 : Query a data warehouse in Microsoft Fabric
Module 5 : Monitor a Microsoft Fabric data warehouse
Module 6 : Secure a Microsoft Fabric data warehouse
The data warehouse in Microsoft Fabric provides a familiar T-SQL experience with the advantages of a cloud-native, fully managed platform. Unlike traditional warehouses, Fabric warehouses integrate seamlessly with lakehouses, share data through OneLake and benefit from automatic performance optimization. This DP-602 Applied Skills credential validates your ability to implement and manage data warehouses in Fabric, a key skill for data professionals in Switzerland.
This hands-on training focuses entirely on practical warehouse implementation in Fabric. You design and create warehouse schemas, ingest data using pipelines and COPY INTO statements, implement slowly changing dimensions, configure security with row-level and column-level controls, and query data across warehouses and lakehouses. All exercises are performed on real Fabric environments with MCT-certified trainer guidance.
You should have working knowledge of T-SQL and familiarity with data warehousing concepts such as star schemas and dimension tables. Basic understanding of Microsoft Fabric is helpful.
DP-602 is a Microsoft Applied Skills credential, validating specific hands-on warehouse implementation skills through a practical scenario-based assessment.
Yes, the Fabric data warehouse supports standard T-SQL syntax. If you already know T-SQL from SQL Server or Azure SQL, you can apply most of that knowledge directly. This training covers the Fabric-specific features and best practices.
Monday to Friday
8:30 AM to 6:00 PM
Tel. 058 307 73 00
ITTA
Route des jeunes 35
1227 Carouge, Suisse
Monday to Friday, from 8:30 am to 06:00 pm.
