logo


your one source for IT & AV

Training Presentation Systems Services & Consulting Cloud Services Purchase Client Center Computer Museum
Arrow Course Schedule | Classroom Rentals | Student Information | Free Seminars | Client Feedback | Partners | Survey | Standby Discounts

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

SS Course: GK834047

Course Overview

TOP
                                                                  

Scheduled Classes

TOP
07/22/24 - GVT - Virtual Classroom - Virtual Instructor-Led
08/19/24 - GVT - Virtual Classroom - Virtual Instructor-Led
09/16/24 - GVT - Virtual Classroom - Virtual Instructor-Led
10/14/24 - GVT - Virtual Classroom - Virtual Instructor-Led
11/25/24 - GVT - Virtual Classroom - Virtual Instructor-Led
12/02/24 - GVT - Virtual Classroom - Virtual Instructor-Led
01/22/25 - GVT - Virtual Classroom - Virtual Instructor-Led
02/17/25 - GVT - Virtual Classroom - Virtual Instructor-Led
03/03/25 - GVT - Virtual Classroom - Virtual Instructor-Led

Outline

TOP

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.

    Prerequisites

    TOP

    You should be familiar with basic data concepts and terminology.

      Who Should Attend

      TOP

      Students wishing to Implement a data warehouse with Microsoft Fabric