DP-602T00 Implement a Data Warehouse with Microsoft Fabric

1 – Introduction to end-to-end analytics using Microsoft Fabric

• Explore end-to-end analytics with Microsoft Fabric
• Explore data teams and Microsoft Fabric
• Enable and use Microsoft Fabric
• Module assessment

2 – Get started with data warehouses in Microsoft Fabric

• Understand data warehouses
• Understand data warehouses in Fabric
• Query and transform data
• Model data in a warehouse
• Secure and monitor a warehouse
• Module assessment

3 – Load data into a Microsoft Fabric data warehouse

• Explore data load strategies
• Use data pipelines to load a warehouse
• Load data using T-SQL
• Load and transform data with Dataflow Gen2
• Module assessment

4 – Query a data warehouse in Microsoft Fabric

• Query data
• Use the SQL query editor
• Explore the visual query editor
• Use client tools to query a warehouse
• Module assessment

5 – Get started with Copilot in Microsoft Fabric for Data Warehouse

• Use Copilot code completion in Microsoft Fabric’s Data Warehouse
• Use Copilot chat in Microsoft Fabric’s Data Warehouse
• Use Copilot quick actions in Microsoft Fabric’s Data Warehouse
• Review best practices using Copilot in Microsoft Fabric’s Data Warehouse
• Module assessment

6 – Monitor a Microsoft Fabric data warehouse

• Monitor capacity metrics
• Monitor current activity
• Monitor queries
• Module assessment

7 – Secure a Microsoft Fabric data warehouse

• Explore dynamic data masking
• Implement row-level security
• Implement column-level security
• Configure SQL granular permissions using T-SQL
• Module assessment