DP-602T00: Implement a Data Warehouse with Microsoft Fabric Training

DP-602 teaches you to build data warehouses in Microsoft Fabric. You'll learn how to design, load, query, and secure your warehouse while optimizing performance for analytics. The course includes hands on labs covering data pipelines, SQL queries, and security configurations.

📘 Fabric 👥 137 Enrolled ⏱️ 1 Day 💼 Foundation Level ⭐ 4.9 | 76 Reviews

Why Microtek Learning?

500+

Courses

10+ Years

Experience

95K+

Global Learners

Virtual Instructor-Led Training

$599

Course Overview

This course covers implementing data warehouses using Microsoft Fabric. You'll work through data storage, ETL processes, and query performance optimization. It's practical and lab driven, so you'll be building and querying a real warehouse rather than just studying the concepts.

Mode of Training

🏫 Classroom 💻 Live Online 🧪 Blended 👨‍👩‍👧‍👦 Private Group

What you will learn

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

Who Should Attend This Course?

Data Analyst
Fabric Analytics Engineer

Prerequisites

You should be familiar with basic data concepts and terminology.

📞 Talk to a Learning Advisor

📘 DP-602T00: Implement a Data Warehouse with Microsoft Fabric Outline

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

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)
Lab: Load data into a 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 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

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 row-level security to provide granular control
Learn how to implement column-level security to protect sensitive data
Learn how to configure granular permissions using T-SQL
Lab: Secure a warehouse in Microsoft Fabric

Still have questions?

Reach out to our learning advisors for personalized guidance on choosing the right course, group training, or enterprise packages.

📞 Talk to an Advisor

What You Get with Microtek Learning

Instructor-Led Excellence

✓ Certified Instructor-led Training
✓ Top Industry Trainers
✓ Official Student Handbooks

Measurable Learning Outcomes

✓ Pre- & Post-Training Assessments
✓ Practice Tests
✓ Exam-Oriented Curriculum

Real-World Skill Building

✓ Hands-on Activities & Scenarios
✓ Interactive Online Courses
✓ Peer Collaboration (Not in self-paced)

Full Support & Perks

✓ Exam Scheduling Support ^*
✓ Learn & Earn Program ^*
✓ Support from Certified Experts
✓ Gov. & Private Pricing ^*

Our Clients

For over 10 years, Microtek Learning has helped organizations, leaders, students and professionals to reach their maximum potential. We have led the path by addressing their challenges and advancing their performances.