DP-602T00 Implement a Data Warehouse with Microsoft Fabric
Description
Explore the data warehousing process and learn how to load, monitor, and query a warehouse in Microsoft Fabric.
Additional Course Information
Schedule and Pricing
Target Audience
Pre-Requisites
You should be familiar with basic data concepts and terminology.
Objectives
Course Delivery Modality
VILT
Duration in Hours
8
Credits Eligible
1
Course Vendor
Course Outline
1 - Introduction to end-to-end analytics using Microsoft Fabric
- Explore end-to-end analytics with Microsoft Fabric
- Explore data teams and Microsoft Fabric
- Enable and use Microsoft Fabric
- Module assessment
2 - Get started with data warehouses in Microsoft Fabric
- Understand data warehouses
- Understand data warehouses in Fabric
- Query and transform data
- Model data in a warehouse
- Secure and monitor a warehouse
- Module assessment
3 - Load data into a Microsoft Fabric data warehouse
- Explore data load strategies
- Use data pipelines to load a warehouse
- Load data using T-SQL
- Load and transform data with Dataflow Gen2
- Module assessment
4 - Query a data warehouse in Microsoft Fabric
- Query data
- Use the SQL query editor
- Explore the visual query editor
- Use client tools to query a warehouse
- Module assessment
5 - Get started with Copilot in Microsoft Fabric for Data Warehouse
- Use Copilot code completion in Microsoft Fabric's Data Warehouse
- Use Copilot chat in Microsoft Fabric's Data Warehouse
- Use Copilot quick actions in Microsoft Fabric's Data Warehouse
- Review best practices using Copilot in Microsoft Fabric's Data Warehouse
- Module assessment
6 - Monitor a Microsoft Fabric data warehouse
- Monitor capacity metrics
- Monitor current activity
- Monitor queries
- Module assessment
7 - Secure a Microsoft Fabric data warehouse
- Explore dynamic data masking
- Implement row-level security
- Implement column-level security
- Configure SQL granular permissions using T-SQL
- Module assessment