Implement a Data Warehouse with Microsoft Fabric (DP-602)

Explore the data warehousing process within Microsoft Fabric in this comprehensive 1-day course. You'll learn to load, monitor, and query a data warehouse efficiently, leveraging Microsoft Fabric's robust features. Implement a Data Warehouse with Microsoft Fabric (DP-602) Benefits In this course, you will learn how to: Get started with data warehouses in Microsoft Fabric. Load data into a Microsoft Fabric data warehouse. Query a data warehouse in Microsoft Fabric. Monitor a Microsoft Fabric data warehouse. Prerequisites Familiarity with data modeling, data transformation, and exploratory data analytics. Ability to query and change data using T-SQL. Certification Information This course does not directly prepare you for a certification exam but is part of Microsoft's applied skills program, enhancing data engineering competencies. DP-602 Course Outline Introduction to Data Warehouses in Microsoft Fabric Understand the fundamentals of data warehouses and their role in Microsoft Fabric for analytical purposes. Load Data into a Microsoft Fabric Data Warehouse Explore strategies for loading data into a data warehouse in Microsoft Fabric, utilizing data pipelines, T-SQL, and Dataflow Gen for efficient data management. Query a Data Warehouse in Microsoft Fabric Learn to query data warehouses in Microsoft Fabric using SQL query editors, visual query editors, and client tools for effective data analysis and retrieval. Monitor a Microsoft Fabric Data Warehouse Discover how to monitor capacity metrics, current activity, and queries in a Microsoft Fabric data warehouse to ensure efficient operation and performance optimization.