course
Implement a Data Warehouse with Microsoft Fabric
Load, Query, Monitor and Secure a Data Warehouse in Microsoft Fabric
Not yet scheduled
- No location
-
Keep me posted
Description
Explore the data warehousing process and learn how to load, monitor, secure, and query a warehouse in Microsoft Fabric.
Prior Knowledge
Familiar with basic data concepts and terminology
Subjects
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.
Read more
Schedule
All courses can also be conducted within your organization as customized or incompany training.
Our training advisors are happy to help you provide personal advice or find Incompany training within your organization.
"Very pleasant teacher, gave a very good interpretation of the course in their own way. It was nice to follow the course like that."Marieke
-
Hoge waardering
-
Praktijkgerichte trainingen
-
Gecertificeerde trainers
-
Eigen docenten