We provide online course about DP-602 Implement a Data warehouse with Microsoft Fabric. Explore the data warehousing process and learn how to load, monitor, and query a warehouse in Microsoft Fabric.
Objectives:
Students will learn 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
Agenda:
Module 1 - Get started with warehouses in Microsoft Fabric:
• Describe data warehouses in Fabric
• Understand a data warehouse vs a data Lakehouse
• Work with data warehouses in Fabric
• Create and manage fact tables and dimensions within a data warehouse
Module 2 - Load data in to a Fabric data warehouse:
• Learn different strategies to load data into a data warehouse in Microsoft Fabric
• Learn how to build a data pipeline to load a warehouse in Microsoft Fabric
• Learn how to load data in a warehouse using T-SQL
• Learn how to load and transform data with dataflow (Gen 2)
Module 3 - Query a data warehouse in Microsoft Fabric:
• Use SQL query editor to query a data warehouse
• Explore how visual query editor works
• Learn how to connect and query a data warehouse using SQL Server Management Studio
Module 4 - Monitor a Microsoft Fabric data warehouse:
• Monitor capacity unit usage with the Microsoft Fabric Capacity Metrics app
• Monitor current activity in the data warehouse with dynamic management views
• Monitor querying trends with query insights views
Target audience:
Students wishing to Implement a data warehouse with Microsoft Fabric