Data, Analytics & AI Category Banner Image

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

Length 1 day

Course overview

View dates &
book now

Course locations >>

Why study this course

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.

Request Course Information

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
Learn the concepts of securing a data warehouse in Microsoft Fabric

Microsoft Azure at Lumify Work

Lumify Work has been delivering effective training across all Microsoft products for over 30 years. We are proud to be both Australia's and New Zealand’s first Microsoft Gold Learning Solutions Partner and the winner of the Microsoft MCT Superstars Award for FY24, which formally recognises us as having the highest quality Microsoft Certified Trainers (MCTs) in ANZ. All Lumify Work Microsoft Azure courses follow Microsoft Official Curriculum (MOC) and are led by MCTs.

View all Microsoft Azure courses

Who is the course for?

Data Analysts
Data Engineers

Course subjects

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
Secure a Microsoft Fabric data warehouse

Prerequisites

You should be familiar with basic data concepts and terminology.

Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.