DP-602: Implement a Data Warehouse with Microsoft Fabric

Overview This class offers a comprehensive understanding of implementing a data warehouse using Microsoft Fabric, a powerful platform for data and analytics. Participants will gain practical knowledge in setting up, managing, and optimizing a data warehouse, ensuring seamless integration with other analytics tools. The curriculum covers essential topics like data loading, querying, monitoring, and securing your data warehouse, providing a well-rounded education in modern data warehousing techniques. _ Designed for professionals seeking to enhance their data management skills, this course equips learners with the expertise to handle complex data environments efficiently. By the end of the course, attendees will be proficient in using Microsoft Fabric to support robust data analytics solutions, driving better business insights and decision-making. Audience Profile This course is ideal for data professionals, including data engineers, data analysts, and database administrators, who are looking to deepen their understanding of data warehousing and analytics using Microsoft Fabric. It is also suitable for IT professionals responsible for managing data infrastructure and ensuring data security within an organization. Prerequisites You should be familiar with basic data concepts and terminology. COURSE OUTLINE Module 1: Get started with data warehouses in Microsoft Fabric Understand data warehouse fundamentals Understand data warehouses in Fabric Query and transform data Prepare data for analysis and reporting Secure and monitor your data warehouse Exercise - Analyze data in a data warehouse Module 2: Load data into a Microsoft Fabric data warehouse Explore data load strategies Use data pipelines to load a warehouse Load data using T-SQL Load and transform data with Dataflow Gen2 Exercise: Load data into a warehouse in Microsoft Fabric Module 3: Query a data warehouse in Microsoft Fabric Use the SQL query editor Explore the visual query editor Use client tools to query a warehouse Exercise: Query a data warehouse in Microsoft Fabric Module 4: Monitor a Microsoft Fabric data warehouse Monitor capacity metrics Monitor current activity Monitor queries Exercise - Monitor a data warehouse in Microsoft Fabric Module 5: Monitor a Microsoft Fabric data warehouse Explore dynamic data masking Implement row-level security Implement column-level security Configure SQL granular permissions using T-SQL Exercise: Secure a warehouse in Microsoft Fabric