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 storage process and teach you how to load, monitor, secure, and query a data store in Microsoft Fabric .

It covers the concepts of data storage, data loading, big data integration, security, administration, and the development of analytics solutions. 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 seeking Microsoft Fabric experience for data storage
• 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 who oversee data warehouse projects

Course content DP-602

Module 1 Introduction to data storage in Microsoft Fabric

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

Module 2 Loading data into a Microsoft Fabric data store

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

Module 3 Querying a data store in Microsoft Fabric

• Using the SQL query editor
  
• Exploring the visual object query editor
  
• Using client tools to query storage
  
• Exercise: Querying a data store in Microsoft Fabric

Module 4 Monitoring a Microsoft Fabric data warehouse

• Capacity metrics monitoring
  
• Monitoring of current activity
  
• Supervision of consultations
  
• 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