Implement a Data Warehouse with Microsoft Fabric (DP-602T00)
You'll learn the basics of what data warehouses and Lakehouses 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.
Check out our full list of training locations and learning formats. Please note that the location you choose may be an Established HD-ILT location with a virtual live instructor.
Train face-to-face with the live instructor.
Access to on-demand training content anytime, anywhere.
Attend the live class from the comfort of your home or office.
Interact with a live, remote instructor from a specialized, HD-equipped classroom near you. An SLI sales rep will confirm location availability prior to registration confirmation.
All Sunset Learning dates are guaranteed to run!
Register
Prerequisites:
Target Audience:
- Data Analyst
- Data Engineer
Course 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
Course Outline:
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
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
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
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