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
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.
Who is the course for?
The primary audience for this course is data professionals who are familiar with data modeling, extraction, and analytics. It is designed for professionals who are interested in gaining knowledge about data warehouse in Microsoft Fabric platform, and how to enable integrated analytics using these technologies.
Course subjects
Implement a data warehouse with Microsoft Fabric
Introduction to end-to-end analytics using Microsoft Fabric
Get started with data warehouses in Microsoft Fabric
Load data into a Microsoft Fabric data warehouse
Query a data warehouse in Microsoft Fabric
Get started with Copilot in Microsoft Fabric for Data Warehouse
Monitor a Microsoft Fabric data warehouse
Secure a Microsoft Fabric data warehouse
Prerequisites
FREE E-BOOK: The New Era of Cloud Computing
We've created this e-book to assist you on your cloud journey, from defining the optimal cloud infrastructure and choosing a cloud platform, to security in the cloud and the core challenges in moving to the cloud.
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.
