DP-602: Implement a Data Warehouse with Microsoft Fabric

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

This course is designed to explore the data warehouse process and learn how to load, monitor, secure, and query a data warehouse in Microsoft Fabric .

It covers data warehousing concepts, data loading, big data integration, security, administration, and analytics solution development. Attendees learn how to leverage Azure services, optimize and troubleshoot data warehouses, and implement advanced analytics and machine learning.

Beginner - Data Analyst - Data Engineer - Microsoft Fabric

Course aimed at

• IT professionals looking for expertise in Microsoft Fabric for data warehousing
• Database administrators looking to implement a scalable data warehouse
• Business intelligence specialists focused on Microsoft technologies
• Data architects interested in learning how to implement a data warehouse with Microsoft Fabric
• Technical team leaders overseeing data warehouse projects

DP-602 Course Content

Module 1 Introduction to Data Warehouses in Microsoft Fabric

• Description of the basic aspects of data storage
  
• Description of data stores in Fabric
  
• Query and transform data
  
• Preparing data for analysis and reporting
  
• Data storage protection and monitoring
  
• Exercise: Analyzing data in a data warehouse

Module 2 Loading Data into a Microsoft Fabric Data Warehouse

• Exploring data loading strategies
  
• Using data pipelines to load a storage
  
• Loading data using T-SQL
  
• Loading and transforming data with Dataflow Gen2
  
• Exercise: Loading data into a warehouse in Microsoft Fabric

Module 3 Querying a Data Warehouse in Microsoft Fabric

• Using the SQL Query Editor
  
• Exploring the Visual Object Query Editor
  
• Using client tools to query storage
  
• Exercise: Querying a Data Warehouse in Microsoft Fabric

Module 4 Monitoring a Microsoft Fabric Data Warehouse

• Monitoring capacity metrics
  
• Monitoring current activity
  
• Query Monitoring
  
• Exercise: Monitoring a Data Warehouse in Microsoft Fabric

Prerequisites

You should be familiar with basic data terminology and concepts.

Language

• Course: English / Spanish
• Labs: English / Spanish

Microsoft Applied Skills

This course is part of the Microsoft Applied Skills Credentials.

To earn this Microsoft Applied Skills credential, students demonstrate the ability to create computer vision solutions using Azure AI Vision.

Applied Skills: Explore all credentials in one guide