← Back to Courses

Implement a Data Warehouse with Microsoft Fabric ( DP-602)

Applied Skills · 1-Day

Build, load, query, and secure a production data warehouse on Microsoft Fabric in one hands-on day.

1 Day / 7 HoursMicrosoft Fabric & Power BILive online with recordings; on-site on request

HRD Corp Claimable

TP No · 10001708993

Program Fee

$499

1-on-1 doubt clearing, WhatsApp support group, lab environment access

Request Syllabus / Call Back

Program Overview

A hands-on, one-day programme that equips data professionals to build and run a production data warehouse on Microsoft Fabric. Participants create a warehouse, load and transform data with T-SQL, pipelines and Dataflow Gen2, query and model data for analytics, accelerate their work with Copilot, and monitor and secure the warehouse for day-to-day operations. Delivered by a Microsoft Certified Trainer with guided labs throughout.

What You'll Learn

Create and configure a data warehouse in Microsoft Fabric
Load and transform data using T-SQL, data pipelines, and Dataflow Gen2
Query and model data for analytics and reporting
Use Copilot to accelerate query authoring and troubleshooting
Monitor warehouse activity and manage cost and performance
Secure data with masking, row- and column-level security, and permissions

Who Can Join

•Data Analysts
•Data Engineers
•BI Developers
•Data Warehouse Developers
•Database Administrators

PREREQUISITES

• Basic familiarity with SQL / T-SQL

• Understanding of relational data concepts

• No prior Microsoft Fabric experience required

Curriculum

→ Microsoft Fabric overview

→ Data teams and Fabric

→ Enabling and using Fabric

→ AI capabilities in Fabric

Total: 7h across 7 modules

Tools & Technologies

Microsoft FabricOneLakeT-SQLData PipelinesDataflow Gen2CopilotSSMS

Projects Included

▹ Lab: Analyze data in a data warehouse
▹ Lab: Load data into a warehouse using T-SQL
▹ Lab: Query a data warehouse in Microsoft Fabric
▹ Lab: Monitor a data warehouse in Microsoft Fabric
▹ Lab: Secure data in a data warehouse

Official Certifications

CertTulen Academy Certificate of Completion

Optional: Microsoft Applied Skills — Implement a Data Warehouse in Microsoft Fabric (free, via Microsoft Learn)

No Microsoft certification exam. A CertTulen Academy Certificate of Completion is awarded on completion. The programme also prepares participants for the optional, free Microsoft Applied Skills assessment “Implement a Data Warehouse in Microsoft Fabric”, taken on demand through Microsoft Learn.

Questions? Contact us for a free counseling session.

Have questions about this course?

Send us your details — we'll respond within 24 hours.

Chat with us