Implement a Data Warehouse with Microsoft Fabric
DP-602T00: Implement a Data Warehouse with Microsoft Fabric course offers detailed training on using Microsoft Fabric for data warehousing. You’ll learn the basics of what data warehouses and Lakehouse are, how they differ, and how to work with them. DP-602 training covers how to handle fact tables and dimensions, and how to analyze warehouse data. You’ll get to know about different ways to load data, create data pipelines, and modify data with T-SQL and dataflow techniques. It also teaches how to use SQL editors and visual tools for queries, and how to keep an eye on warehouse operations through Microsoft Fabric’s monitoring tools. With practical lab sessions, this course equips you with the skills needed for data warehouse implementation effectively.
- Duration 1 Days
Objectives
- Get started with data warehouses in Microsoft Fabric
- Load data into a Microsoft Fabric data warehouse
- Query a data warehouse in Microsoft Fabric
- Monitor a Microsoft Fabric data warehouse Design a data partitioning strategy
Target Audience
- Data Analyst
- Data Engineer
PREREQUISITE
Recommended:
- You should be familiar with basic data concepts and terminology.
About the course
COURSE OUTLINE
Module: 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
- Lab Analyze data in 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 TSQL
- Learn how to load and transform data with dataflow Gen 2
- Lab Load data into a warehouse in Microsoft Fabric
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
- Lab Query a data warehouse in Microsoft Fabric
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
- Lab Monitor a data warehouse in Microsoft Fabric
Module: 5 Secure a Microsoft Fabric data warehouse
- Learn the concepts of securing a data warehouse in Microsoft Fabric
- Learn how to implement dynamic data masking to obscure sensitive information
- Learn how to configure rowlevel security to provide granular control
- Learn how to implement columnlevel security to protect sensitive data
- Learn how to configure granular permissions using TSQL
- Lab Secure a warehouse in Microsoft Fabric
Register for Training
Schedule
| Start Date | End Date | Duration (days) | Price | Register | Course | Code | Product |
|---|
