DP-602 | 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.
 
Prerequisites
You should be familiar with basic data concepts and terminology.
 
Course Outline
Module 1: Get started with data warehouses in Microsoft Fabric
Data warehouses are analytical stores built on a relational schema to support SQL queries. Microsoft Fabric enables you to create a relational data warehouse in your workspace and integrate it easily with other elements of your end-to-end analytics solution.
Introduction
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
Exercise - Analyze data in a data warehouse
Knowledge check
Summary
Module 2: Load data into a Microsoft Fabric data warehouse
Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transactional T-SQL capabilities for easy data management and analysis.
Introduction
Explore data load strategies
Use data pipelines to load a warehouse
Load data using T-SQL
Load and transform data with Dataflow Gen
Exercise: Load data into a warehouse in Microsoft Fabric
Knowledge check
Summary
Module 3: Query a data warehouse in Microsoft Fabric
Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transactional T-SQL capabilities for easy data management and analysis.
Introduction
Use the SQL query editor
Explore the visual query editor
Use client tools to query a warehouse
Exercise: Query a data warehouse in Microsoft Fabric
Knowledge check
Summary
Module 4: Monitor a Microsoft Fabric data warehouse
A data warehouse is a vital component of an enterprise analytics solution. It's important to learn how to monitor a data warehouse so you can better understand the activity that occurs in it.
Introduction
Monitor capacity metrics
Monitor current activity
Monitor queries
Exercise - Monitor a data warehouse in Microsoft Fabric
Knowledge check
Summary
Module 5: Secure a Microsoft Fabric data warehouse
Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transactional T-SQL capabilities for easy data management and analysis.
Introduction
Explore dynamic data masking
Implement row-level security
Implement column-level security
Configure SQL granular permissions using T-SQL
Exercise: Secure a warehouse in Microsoft Fabric
Knowledge check
Summary
 
Descargue el temario para conocer el detalle completo de los contenidos.
 
Debido a las constantes actualizaciones de los contenidos de los cursos por parte del fabricante, el contenido de este temario puede variar con respecto al publicado en el sitio oficial, sin embargo, Netec siempre entregará la versión actualizada de éste.