Back

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

-
+

NOK 9.900


Explore the data warehousing process and learn how to load, monitor, and query a warehouse in Microsoft Fabric.
This learning path helps prepare you for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric (beta).

TARGET AUDIENCE:
Students wishing to Implement a data warehouse with Microsoft Fabric

COURSE PREREQUISITES:
You should be familiar with basic data concepts and terminology.

COURSE CONTENT:
Module 1: Get started with data 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 into a Microsoft 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.

COURSE OBJECTIVE:
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

FOLLOW ON COURSES:
Not available. Please contact.