Course Outline
DP-602: Implement a Data Warehouse with Microsoft Fabric
For individuals seeking certification from Microsoft, please use the following link for our user-friendly Microsoft Certification Guide.
This is a 1 day, instructor-led course.
This course is designed to build your foundational skills in data engineering on Microsoft Fabric, focusing on data warehouse concepts. This course explores how to load, monitor and query a data warehouse in Microsoft Fabric using tools, and transactional T-SQL capabilities for easy data management and analysis. This course includes a combination of lectures and hands-on exercises that will prepare you to work with data warehouses in Microsoft Fabric.
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.
Before starting this learning path, familiarity with the Microsoft Fabric interface and core concepts is recommended.
We recommend you attend the following courses to further your expertise in this technology:
DP-600: Microsoft Fabric Analytics EngineerCopilot for Compliance Administrators
DP-700: Implement data engineering solutions using Microsoft Fabric
Course Contents
Introduction to end-to-end analytics using Microsoft Fabric
Explore end-to-end analytics with Microsoft Fabric
Explore data teams and Microsoft Fabric
Enable and use Microsoft Fabric
Module assessment
Get started with data warehouses in Microsoft Fabric
Understand data warehouses
Understand data warehouses in Fabric
Query and transform data
Model data in a warehouse
Secure and monitor a warehouse
Exercise – Create and query a warehouse
Load data into a Microsoft Fabric data warehouse
Explore data load strategies
Use data pipelines to load a warehouse
Load data using T-SQL
Load and transform data with Dataflow Gen2
Exercise: Load data into a warehouse
Query a data warehouse in Microsoft Fabric
Query data
Use the SQL query editor
Explore the visual query editor
Use client tools to query a warehouse
Exercise: Query a data warehouse in Microsoft Fabric
Get started with Copilot in Microsoft Fabric for Data Warehouse
Use Copilot code completion in Microsoft Fabric’s Data Warehouse
Use Copilot chat in Microsoft Fabric’s Data Warehouse
Use Copilot quick actions in Microsoft Fabric’s Data Warehouse
Review best practices using Copilot in Microsoft Fabric’s Data Warehouse
Exercise: Use Copilot in Microsoft Fabric data warehouse
Monitor a Microsoft Fabric data warehouse
Monitor capacity metrics
Monitor current activity
Monitor queries
Exercise: Monitor a data warehouse in Microsoft Fabric
Secure a Microsoft Fabric data warehouse
Explore dynamic data masking
Implement row-level security
Implement column-level security
Configure SQL granular permissions using T-SQL
Exercise: Secure a warehouse in Microsoft Fabric
Price per delegate
£995
Scheduled Classes
Remote Access:
Please complete the contact form below or call 0141 221 5676 for further course information and available dates.
Alternatively you can email us at info@indiciatraining.com
DP602
