DP-602: Implement a Data Warehouse with Microsoft Fabric
Overview
In this one-day course students explore the data warehousing process and learn how to load, monitor, and query a warehouse in Microsoft Fabric.
This one-day course prepares you for an Applied Skills credential.
For more than 30 years, Microsoft's industry-recognised certifications have provided proof of world-class technical proficiency for in-demand job roles. In today’s ever-changing business environment, there are also times when you need verified project-specific skills. Microsoft Applied Skills is a new verifiable credential that validates that you have the targeted skills needed to implement critical projects aligned to business goals and objectives. Applied Skills gives you a new opportunity to put your skills centre-stage, empowering you to showcase what you can do and what you can bring to key projects in your organisation.
Who should attend
- Data Analysts
- Data Engineers
Prerequisites
- You should be familiar with basic data concepts and terminology.
What you'll learn
After completing this course, students will be able to:
- 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
- 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 T-SQL
- Learn how to load and transform data with dataflow (Gen 2)
- 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
- 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
Course content
- 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
Common questions
When does DP-602: Implement a Data Warehouse with Microsoft Fabric next run?
The next date is Mon, 7 Sept 2026, and there are 4 further dates scheduled. Delivered ACE Training Wellington, live online, ACE Training Auckland. Every date and its format is listed on this page.
How much does DP-602: Implement a Data Warehouse with Microsoft Fabric cost?
From $950 + GST per person. Pricing can differ by date and location, so check the option you want before booking.
Do I need any prior experience?
You should be familiar with basic data concepts and terminology.
Can I attend online, or does it have to be in a classroom?
Both. Some dates run live online and others in-class — each date on this page shows its format, so pick whichever suits.
Can you run this course for my team?
Yes. Any ACE course can be delivered in-house at your workplace and tailored to your team's tools and goals — quote course code DP602 when you enquire.