- Module 1: Understand the key components and design considerations for implementation of data warehouses in Microsoft Fabric.
In this module, you'll learn how to:
- Describe data warehouses in Fabric
- Understand a data warehouse vs a data Lakehouse
- Work with data warehouses in Fabric
- Create and manage datasets within a data warehouse
- Module 2: Explore the process of loading data into a warehouse in Microsoft Fabric.
In this module, you'll:
- 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: Learn how to query a data warehouse in Microsoft Fabric using different tools.
In this module, you'll:
- 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: 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.
After completing this module, you'll be able to:
- 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.
Overview
Syllabus
- Module 1: Module 1: Get started with data warehouses in Microsoft Fabric
- Introduction
- Understand data warehouse fundamentals
- Understand data warehouses in Fabric
- Query and transform data
- Prepare data for analysis and reporting
- Secure and monitor your data warehouse
- Exercise - Analyze data in a data warehouse
- Knowledge check
- Summary
- Module 2: Module 2: Load data into a Microsoft Fabric data warehouse
- Introduction
- Explore data load strategies
- Use data pipelines to load a warehouse
- Load data using T-SQL
- Load and transform data with Dataflow Gen2
- Exercise: Load data into a warehouse in Microsoft Fabric
- Knowledge check
- Summary
- Module 3: Module 3: Query a data warehouse in Microsoft Fabric
- Introduction
- Use the SQL query editor
- Explore the visual query editor
- Use client tools to query a warehouse
- Exercise: Query a data warehouse in Microsoft Fabric
- Knowledge check
- Summary
- Module 4: Module 4: Monitor a Microsoft Fabric data warehouse
- Introduction
- Monitor capacity metrics
- Monitor current activity
- Monitor queries
- Exercise - Monitor a data warehouse in Microsoft Fabric
- Knowledge check
- Summary