Skip to Scheduled Dates
Course Overview
Explore the data warehousing process and learn how to load, monitor, and query a warehouse in Microsoft Fabric.
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 - Monitor a Microsoft Fabric data warehouse
- Monitor capacity metrics
- Monitor current activity
- Monitor queries
- Module assessment
6 - 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