Course Overview
TOPThis learning path helps prepare you for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric (beta).
Scheduled Classes
TOP05/13/24 - GVT - Virtual Classroom - Virtual Instructor-Led | |
06/03/24 - GVT - Virtual Classroom - Virtual Instructor-Led | |
07/22/24 - GVT - Virtual Classroom - Virtual Instructor-Led | |
08/19/24 - GVT - Virtual Classroom - Virtual Instructor-Led | |
09/16/24 - GVT - Virtual Classroom - Virtual Instructor-Led | |
10/14/24 - GVT - Virtual Classroom - Virtual Instructor-Led | |
11/25/24 - GVT - Virtual Classroom - Virtual Instructor-Led | |
12/02/24 - GVT - Virtual Classroom - Virtual Instructor-Led |
Outline
TOPModule 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.
Prerequisites
TOPYou should be familiar with basic data concepts and terminology.
Who Should Attend
TOPStudents wishing to Implement a data warehouse with Microsoft Fabric