Microsoft Data & Power BI
DP-602T00 Implement a Data Warehouse with Microsoft Fabric
Implement a data warehouse in Microsoft Fabric.
1 dayIntermediate7 modulesDP-602T00
About this course
Implement a data warehouse in Microsoft Fabric. In one day you will create warehouses, load and query data, get started with Copilot for data warehousing, and monitor and secure the warehouse.
Curriculum
7 modules
- Explore end-to-end analytics with Microsoft Fabric
- Explore data teams and Microsoft Fabric
- Enable and use Microsoft Fabric
- Module assessment
- Understand data warehouses
- Understand data warehouses in Fabric
- Query and transform data
- Model data in a warehouse
- Secure and monitor a warehouse
- Module assessment
- 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
- Query data
- Use the SQL query editor
- Explore the visual query editor
- Use client tools to query a warehouse
- Module assessment
- 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
- Monitor capacity metrics
- Monitor current activity
- Monitor queries
- Module assessment
- Explore dynamic data masking
- Implement row-level security
- Implement column-level security
- Configure SQL granular permissions using T-SQL
- Module assessment
Who it's for
Data engineers and BI developers.
Before you start
- You should be familiar with basic data concepts and terminology.
Related courses
More in Microsoft Data & Power BI →Intermediate
55128 Writing Reports with Report Builder and SSRS Level 2
Microsoft Data & Power BI
View course →Intermediate
55232 Writing Analytical Queries for Business Intelligence
Microsoft Data & Power BI
View course →Foundation
55315 Introduction to SQL Databases
Microsoft Data & Power BI
View course →Intermediate55353
Administering a SQL Database Infrastructure (55353)
Microsoft Data & Power BI
View course →IntermediateDP-300 Exam Prep/DP-300T00
Administering Microsoft Azure SQL Solutions (DP-300 Exam Prep/DP-300T00)
Microsoft Data & Power BI
View course →Foundation
Data Analysis using Power BI Desktop - Level 1: Report Builder
Microsoft Data & Power BI
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.