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

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

Leer data te laden, monitoren, beveiligen en bevragen in een Microsoft Fabric Data Warehouse
Studie-investeringsformulier
Terug naar overzicht

Cursusbeschrijving

Verken het proces van data warehousing en leer hoe je een data warehouse kunt laden, monitoren, beveiligen en bevragen in Microsoft Fabric.

Onderwerpen

  • 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.
  • ### 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).
  • ### 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.
  • ### 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.
  • ### 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.

    • Materiaal

    Digitaal Microsoft cursusmateriaal

    Voorkennis

    Bekend met basisconcepten en terminologie van data warehousing