We provide virtual course about DP-602: Implement a Data Warehouse with Microsoft Fabric. DP-602: Implement a Data Warehouse with Microsoft Fabric provides a practical and structured introduction to designing, building, and managing a data warehouse using Microsoft Fabric.
Course description:
The course focuses on how modern data warehousing supports analytics at scale, and how Microsoft Fabric brings together ingestion, transformation, storage, and security in a unified platform. Participants learn how to load and transform data, work with SQL-based analytics, manage performance and scalability, and apply governance and security controls within a Fabric-based data warehouse.
The course combines conceptual understanding with hands-on exercises, enabling participants to translate theory into real-world implementation scenarios. This course is designed to help professionals understand how a data warehouse is implemented as part of a modern analytics architecture.
You will work with common data warehousing patterns, explore how Microsoft Fabric supports enterprise analytics workloads, and learn how to manage and optimize a warehouse for reporting and analytical use cases. By the end of the course, participants will have a clear understanding of how to build reliable, scalable, and secure data warehouse solutions in Microsoft Fabric, and how these solutions integrate with broader analytics and reporting environments.
Course outline:
Module 1 - Get started with data warehouses in Microsoft Fabric:
• Data warehouses are analytical stores built on a relational schema to support SQL queries. Microsoft Fabric enables you to create a relational data warehouse in your workspace and integrate it easily with other elements of your end-to-end analytics solution.
Module 2 - Load data into a Microsoft Fabric data warehouse:
• Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transactional T-SQL capabilities for easy data management and analysis.
Module 3 - Query a data warehouse in Microsoft Fabric:
• Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transactional T-SQL capabilities for easy data management and analysis.
Module 4 - Monitor a Microsoft Fabric data warehouse:
• A data warehouse is a vital component of an enterprise analytics solution. It's important to learn how to monitor a data warehouse so you can better understand the activity that occurs in it.
Module 5 - Secure a Microsoft Fabric data warehouse:
• Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transactional T-SQL capabilities for easy data management and analysis.
Target audience:
This course is intended for:
• Data Engineers working with analytics and data platforms
• BI and Database Developers who want to implement modern data warehouses
• Data Analysts with strong SQL skills who want to understand warehouse design and implementation
• IT professionals involved in designing, building, or operating analytics solutions
• Team members working with Microsoft Fabric or transitioning from traditional data warehouse platforms
Prerequisites:
• You should be familiar with basic data concepts and terminology
Language:
• English course material, norwegian or english speaking instructor
Level:
• Intermediate level
Course material:
The course fee includes digital course documentation