DP-602: Implement a Data Warehouse with Microsoft Fabric Course Outline

Special Note to New Hampshire Residents
This course has not yet been approved by the New Hampshire Department of Education. Please contact us for an update on when the class will be available in New Hampshire.

Overview
This class offers a comprehensive understanding of implementing a data warehouse using Microsoft Fabric, a powerful platform for data and analytics. Participants will gain practical knowledge in setting up, managing, and optimizing a data warehouse, ensuring seamless integration with other analytics tools. The curriculum covers essential topics like data loading, querying, monitoring, and securing your data warehouse, providing a well-rounded education in modern data warehousing techniques.

Designed for professionals seeking to enhance their data management skills, this course equips learners with the expertise to handle complex data environments efficiently. By the end of the course, attendees will be proficient in using Microsoft Fabric to support robust data analytics solutions, driving better business insights and decision-making.

Audience Profile
This course is ideal for data professionals, including data engineers, data analysts, and database administrators, who are looking to deepen their understanding of data warehousing and analytics using Microsoft Fabric. It is also suitable for IT professionals responsible for managing data infrastructure and ensuring data security within an organization.

Prerequisites
You should be familiar with basic data concepts and terminology.

COURSE OUTLINE

Module 1: Get started with data warehouses in Microsoft Fabric
Understand data warehouse fundamentals
Understand data warehouses in Fabric
Query and transform data
Prepare data for analysis and reporting
Secure and monitor your data warehouse
Exercise - Analyze data in a data warehouse

Module 2: 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 in Microsoft Fabric

Module 3: Query a data warehouse in Microsoft Fabric
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

Module 4: Monitor a Microsoft Fabric data warehouse
Monitor capacity metrics
Monitor current activity
Monitor queries
Exercise - Monitor a data warehouse in Microsoft Fabric

Module 5: Monitor 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
View outline in Word

ADP602

Attend hands-on, instructor-led DP-602: Implement a Data Warehouse with Microsoft Fabric training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Courses and select the one that's right for you.