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

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.

Microsoft Applied Skills
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 center stage, empowering you to showcase what you can do and what you can bring to key projects in your organisation. Prepare for your Applied Skills credential with this one-day, instructor-led training course.

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


Microsoft Partner Cloud Logo

Microsoft Azure at Lumify Work

Lumify Work is your best choice for training and certification in any of Microsoft’s leading technologies and services. We’ve been delivering effective training across all Microsoft products for over 30 years, and are proud to be Australia's and New Zealand’s first and largest Microsoft Gold Learning Solutions Partner. All Lumify Work Microsoft Azure courses follow Microsoft Official Curriculum (MOC) and are led by Microsoft Certified Trainers. Join more than 5,000 students who attend our quality Microsoft courses every year.


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


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.


Request Course Information

Personalise your schedule with Lumify USchedule

Interested in a course that we have not yet scheduled? Get in touch, and ask for your preferred date and time. We can work together to make it happen.



Offers

Continue your learning experience online with Lumify Plus
Lumify Plus (formerly DDLS Plus) is your online learning pathway to extend knowledge beyond courses. Get resources to help you practice what you learned and prepare for future courses, exams and certifications.
Microsoft Azure Developer & DOI DevOps Foundation Bundle
This bundle brings together two globally recognised and sought after courses to set you apart from the rest and give you the edge you need to advance your career.