Take advantage of spring savings with up to 50% off ILT training.

MyGK
Support
Canada Canada - English
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Subtotal

$

Checkout

or Continue Shopping

Contact Sales
Course  
Contact Sales
Support
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Subtotal

$

Checkout

or Continue Shopping

Request Group Training

Implement a Data Warehouse with Microsoft Fabric (DP-602T00)

Implement a data warehouse with Microsoft Fabric

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

GK# 834047 Vendor# DP-602T00
Vendor Credits:
  • Global Knowledge Delivered Course
  • Training Exclusives
No matching courses available.
Start learning as soon as today! Click Add To Cart to continue shopping or Buy Now to check out immediately.
Access Period:
Scheduling a custom training event for your team is fast and easy! Click here to get started.
$
Your Selections:
Location:
Access Period:
No available dates
Add To Cart

BUY NOW

Request a quote

Who Should Attend?

Students wishing to Implement a data warehouse with Microsoft Fabric

What You'll Learn

Students will learn to,

  • Get started with data warehouses in Microsoft Fabric
  • Load data into a Microsoft Fabric data warehouse
  • Query a data warehouse in Microsoft Fabric
  • Monitor a Microsoft Fabric data warehouse
  • Secure a Microsoft Fabric data warehouse

Course Outline

Module 1: Get started with data warehouses in Microsoft Fabric

  • Describe data warehouses in Fabric
  • Understand a data warehouse vs a data Lakehouse
  • Work with data warehouses in Fabric
  • Create and manage fact tables and dimensions within a data warehouse

Module 2: Load data into a Microsoft Fabric data warehouse

  • Learn different strategies to load data into a data warehouse in Microsoft Fabric.
  • Learn how to build a data pipeline to load a warehouse in Microsoft Fabric.
  • Learn how to load data in a warehouse using T-SQL.
  • Learn how to load and transform data with dataflow (Gen 2).

Module 3: Query a data warehouse in Microsoft Fabric

  • Use SQL query editor to query a data warehouse.
  • Explore how visual query editor works.
  • Learn how to connect and query a data warehouse using SQL Server Management Studio.

Module 4: Monitor a Microsoft Fabric data warehouse

  • Monitor capacity unit usage with the Microsoft Fabric Capacity Metrics app.
  • Monitor current activity in the data warehouse with dynamic management views.
  • Monitor querying trends with query insights views.

Module 5: Secure a Microsoft Fabric data warehouse

  • Learn the concepts of securing a data warehouse in Microsoft Fabric.
  • Learn how to implement dynamic data masking to obscure sensitive information.
  • Learn how to configure row-level security to provide granular control.
  • Learn how to implement column-level security to protect sensitive data.
  • Learn how to configure granular permissions using T-SQL.
BUY NOW

Prerequisites

You should be familiar with basic data concepts and terminology.

Related Certifications

Applied Skills