DP-602T00: Implement a Data Warehouse with Microsoft Fabric
Get started with professional data warehousing in Microsoft Fabric. Learn to effectively load, query, monitor, and secure your data warehouse using modern methods. This course provides the technical expertise to manage data ingestion via data pipelines and implement granular access controls using advanced SQL security features.
This course is primarily aimed at individuals responsible for designing, implementing, and managing data solutions in a modern analytics environment.
- Data Engineers: Professionals who need to understand how to build and orchestrate data pipelines, load data efficiently, and manage the data warehouse environment within Microsoft Fabric.
- Data Warehouse Developers/Architects: Individuals responsible for setting up the relational structure, writing complex queries (T-SQL), and ensuring the performance and security of the data warehouse.
- BI Developers/Analysts: Those who interact with the data warehouse for reporting and analysis, needing to understand query methods and data preparation.
- Database Administrators (DBAs): Professionals who manage and monitor the performance, activity, and security aspects of the data warehouse.
- Anyone transitioning to Microsoft Fabric: Technical users who need a foundational understanding of using Fabric for end-to-end data warehousing and analytics.
Upon completing the course, participants should be able to:
- Identify how Microsoft Fabric addresses enterprise analytics needs.
- Implement a data warehouse, including setting up the relational structure and understanding fundamental concepts.
- Master various data loading strategies, utilizing T-SQL, data pipelines, and Dataflow Gen2 to ingest data efficiently.
- Query and analyze data effectively using both SQL and visual query editors, as well as external client tools.
- Monitor the data warehouse's performance, current activity, and capacity metrics to ensure operational efficiency.
Module 01: Introduction to end-to-end analytics using Microsoft Fabric
Discover how Microsoft Fabric can meet your enterprise's analytics needs in one platform. Learn about Microsoft Fabric, how it works, and identify how you can use it for your analytics needs.
Topics Covered
- Explore end-to-end analytics with Microsoft Fabric
- Explore data teams and Microsoft Fabric
- Enable and use Microsoft Fabric
- Module assessment
Module 02: 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.
Topics Covered
- 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
- Module assessment
Module 03: 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.
Topics Covered
- Explore data load strategies
- Use data pipelines to load a warehouse
- Load data using T-SQL
- Load and transform data with Dataflow Gen2
- Exercise: Load data into a warehouse in Microsoft Fabric
- Module assessment
Module 04: 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.
Topics Covered
- Query data
- 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
- Module assessment
Module 05: 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.
Topics Covered
- Monitor capacity metrics
- Monitor current activity
- Monitor queries
- Exercise - Monitor a data warehouse in Microsoft Fabric
- Module assessment
Module 06: 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.
Topics Covered
- 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
- Module assessment
