In this one-day course students explore the data warehousing process and learn how to load, monitor, and query a warehouse in Microsoft Fabric.
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
As part of Lumify Group, Lumify Work has skilled more people in Microsoft technologies than any other organisation in Australia and New Zealand. We have a campus in the Philippines, too. We offer the broadest range of instructor-led training courses, from end user to architect level. We are proud to be the winner of the Microsoft MCT Superstars Award for FY24, which formally recognises us as having the highest quality Microsoft Certified Trainers in ANZ.
Data Analysts
Data Engineers
You should be familiar with basic data concepts and terminology.
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.
