DP-602 Implement a Data Warehouse with Microsoft Fabric

Opi mitä tarkoittaa Microsoft Fabric Data Warehouse.

Tavoite

Tällä Microsoft Applied Skills -koulutuksella on tavoitteena saada yleiskäsitys Microsoft Fabricista keskittyen sen Data Warehouse -konseptiin. Kurssin lopussa suoritetaan Applied Skills Assessment, jolla voi osoittaa osaamisensa.

Koulutuksen sisältö

Module1. 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.

Learning objectives

• 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

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.

Learning objectives

• 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

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.

Learning objectives

• 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

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.

Learning objectives

• 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.

Assessment test