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 – 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

2 – 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
  • Module assessment

3 – 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
  • Module assessment

4 – 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
  • Module assessment

5 – Monitor a Microsoft Fabric data warehouse

  • Monitor capacity metrics
  • Monitor current activity
  • Monitor queries
  • Module assessment

6 – 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
  • Module assessment

Enroll in this course

$695.00

Need Help Finding The Right Training Solution?

Our training advisors are here for you.