Overview
Explore the data warehousing process and learn how to load, monitor, secure, and query a warehouse in Microsoft Fabric.
Why Choose KORNERSTONE
- Accredited, practitioner-led, expert certificate trainers to provide high quality training
- Official training material included
- Practical, scenario-based learning – focus on application, not just theory
- Excellent Passing Rate
Skills Covered
- 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 Microsoft Fabric interface, basic data concepts and terminology.
Target Audience
- Data Analyst
- Data Engineer
Course Curriculum
Module 1: Get started with data warehouses in Microsoft Fabric
Data warehouses are analytical stores built on a relational schema to support SQL queries. Microsoft Fabric enables you to create a relational data warehouse in your workspace and integrate it easily with other elements of your end-to-end analytics solution.
Learning objectives
In this module, you learn how to:
- Describe data warehouses in Fabric.
- 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.
Module 2: Load data into a Microsoft Fabric data warehouse
Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transactional T-SQL capabilities for easy data management and analysis.
Learning objectives
In this module, you’ll:
- 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).
Module 3: Query a data warehouse in Microsoft Fabric
Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transactional T-SQL capabilities for easy data management and analysis.
Learning objectives
In this module, you’ll:
- 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.
Module 4: Monitor a Microsoft Fabric data warehouse
A data warehouse is a vital component of an enterprise analytics solution. It’s important to learn how to monitor a data warehouse so you can better understand the activity that occurs in it.
Learning objectives
After completing this module, you’ll be able to:
- 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.
Module 5: Secure a Microsoft Fabric data warehouse
Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transactional T-SQL capabilities for easy data management and analysis.
Learning objectives
In this module, you’ll:
- Learn the concepts of securing a data warehouse in Microsoft Fabric.
- Learn how to implement dynamic data masking to obscure sensitive information.
- Learn how to configure row-level security to provide granular control.
- Learn how to implement column-level security to protect sensitive data.
- Learn how to configure granular permissions using T-SQL.
Dates & Locations
October 19, 2026
Exam & Certification
To earn this Microsoft Applied Skills credential, learners demonstrate the ability to implement a data warehouse in Microsoft Fabric, including:
- Creating a data warehouse
- Loading, transforming, and querying data
- Modeling a star schema
- Managing security
Candidates for this credential should be familiar with data modeling, data transformation, and exploratory data analytics. They should also be able to query and change data by using T-SQL.
