DP-602T00 Implement a Data Warehouse with Microsoft Fabric

Introduction:

Explore the data warehousing process and learn how to load, monitor, and query a warehouse in Microsoft Fabric.

Objectives:

Course Outline:

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

2 – Load data into a Microsoft Fabric data warehouse

  • Explore data load strategies
  • Use data pipelines to load a warehousev
  • Load data using T-SQL
  • Load and transform data with Dataflow Gen2

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

4 – Monitor a Microsoft Fabric data warehouse

  • Monitor capacity metrics
  • Monitor current activity
  • Monitor queries

Enroll in this course

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

CAD Canadian dollar