DP-700T00: Implement data engineering solutions using Microsoft Fabric
This course covers the methods and practices used to implement data engineering solutions on Microsoft Fabric. It walks through designing and building effective data loading patterns, data architectures, and orchestration processes across the Fabric platform. Along the way, the course addresses ingesting and transforming data from a variety of sources, as well as securing, managing, and monitoring the resulting data engineering solutions so they can be operated reliably at enterprise scale.
This course is intended for data professionals who already have experience with data extraction, transformation, and loading. It is designed for practitioners who need to create and deploy data engineering solutions using Microsoft Fabric for enterprise-scale data analytics, and who have prior experience manipulating and transforming data using SQL, PySpark, or Kusto Query Language (KQL).
By the end of this course, learners will be able to design and implement end-to-end data engineering solutions in Microsoft Fabric. This includes ingesting and orchestrating both batch and real-time data using Dataflows Gen2, pipelines, Apache Spark, and Eventstream; building and organizing lakehouses with Delta Lake tables and medallion architecture; implementing and querying data warehouses with T-SQL and Copilot assistance; and securing, monitoring, and administering Fabric environments through CI/CD practices, access controls, and governance tooling.
Module 01: Ingest Data with Dataflows Gen2 in Microsoft Fabric
Topics:
- Understand Dataflows Gen2 in Microsoft Fabric
- Explore Dataflows Gen2 in Microsoft Fabric
- Integrate Dataflows Gen2 and Pipelines in Microsoft Fabric
Module 02: Orchestrate Processes and Data Movement with Microsoft Fabric
Topics:
- Data Factory pipelines in Microsoft Fabric
- Orchestrating data ingestion
- Orchestrating data transformation tasks
Module 03: Use Apache Spark in Microsoft Fabric
Topics:
- Apache Spark for large-scale data analytics
- Spark clusters in Microsoft Fabric
- Processing data in a Lakehouse at scale
Module 04: Work with Real-Time Data in an Eventhouse in Microsoft Fabric
Topics:
- Get started with an Eventhouse
- Use KQL effectively
- Materialized views and stored functions
Module 05: Introduction to End-to-End Analytics Using Microsoft Fabric
Topics:
- Explore end-to-end analytics with Microsoft Fabric
- Explore data teams and Microsoft Fabric
- Enable and use Microsoft Fabric
Module 06: Get Started with Lakehouses in Microsoft Fabric
Topics:
- Combining data lake and data warehouse capabilities
- Creating a lakehouse
- Ingesting and transforming data
- Querying data with SQL and Spark
Module 07: Use Apache Spark in Microsoft Fabric
Topics:
- Apache Spark for large-scale data analytics
- Spark clusters in Microsoft Fabric
- Processing data in a Lakehouse at scale
Module 08: Work with Delta Lake Tables in Microsoft Fabric
Topics:
- Delta Lake storage format
- Delta tables in Apache Spark
- Building advanced analytics solutions with delta tables
Module 09: Ingest Data with Dataflows Gen2 in Microsoft Fabric
Topics:
- Understand Dataflows Gen2 in Microsoft Fabric
- Explore Dataflows Gen2 in Microsoft Fabric
- Integrate Dataflows Gen2 and Pipelines in Microsoft Fabric
Module 10: Orchestrate Processes and Data Movement with Microsoft Fabric
Topics:
- Data Factory pipelines in Microsoft Fabric
- Orchestrating data ingestion
- Orchestrating data transformation tasks
Module 11: Organize a Fabric Lakehouse Using Medallion Architecture Design
Topics:
- Describe medallion architecture
- Plan a medallion architecture in Fabric
- Query and report on data in your Fabric lakehouse
- Secure and govern your medallion lakehouse
Module 12: Get Started with Real-Time Intelligence in Microsoft Fabric
Topics:
- What is real-time data analytics?
- Real-Time Intelligence in Microsoft Fabric
- Ingest and transform real-time data
- Store and query real-time data
- Visualize real-time data
- Automate actions
Module 13: Use Eventstream in Microsoft Fabric
Topics:
- Ingesting real-time data with Eventstream
- Transforming real-time data
- Routing real-time data
Module 14: Work with Real-Time Data in an Eventhouse in Microsoft Fabric
Topics:
- Get started with an Eventhouse
- Use KQL effectively
- Materialized views and stored functions
Module 15: Create Real-Time Dashboards with Microsoft Fabric
Topics:
- Real-Time Dashboard capability
- Creating interactive data visualizations
Module 16: Use Activator in Microsoft Fabric
Topics:
- Configure Activator for your data
- Create rules in Activator
- Configure actions in Activator
Module 17: Introduction to End-to-End Analytics Using Microsoft Fabric
Topics:
- Explore end-to-end analytics with Microsoft Fabric
- Explore data teams and Microsoft Fabric
- Enable and use Microsoft Fabric
Module 18: Get Started with Data Warehouses in Microsoft Fabric
Topics:
- What a Fabric data warehouse is
- Full T-SQL transactional capabilities
- Creating, querying, and transforming data for analytics
Module 19: Load Data into a Microsoft Fabric Data Warehouse
Topics:
- Loading data using pipelines, T-SQL, and Dataflow Gen2
- Full load strategies
- Incremental load strategies
- Slowly changing dimensions
Module 20: Query a Data Warehouse in Microsoft Fabric
Topics:
- Querying with the built-in SQL editor
- Querying with the visual query editor
- Using external client tools like SQL Server Management Studio
Module 21: Get Started with Copilot in Microsoft Fabric for Data Warehouse
Topics:
- Copilot AI chat for warehouse analytics
- Inline completions and quick actions
- Generating, refining, explaining, and fixing T-SQL
- Best-practice prompting
Module 22: Monitor a Microsoft Fabric Data Warehouse
Topics:
- Importance of data warehouse monitoring
- Understanding warehouse activity
Module 23: Secure a Microsoft Fabric Data Warehouse
Topics:
- Explore dynamic data masking
- Implement row-level security
- Implement column-level security
- Configure SQL granular permissions using T-SQL
Module 24: Implement Continuous Integration and Continuous Delivery (CI/CD) in Microsoft Fabric
Topics:
- Understand Continuous Integration and Continuous Delivery (CI/CD)
- Implement version control and Git integration
- Implement deployment pipelines
- Automate CI/CD using Fabric APIs
Module 25: Monitor Activities in Microsoft Fabric
Topics:
- Monitoring hub in Microsoft Fabric
- Collecting and aggregating activity data
- Automating responses to Fabric job events with Activator
Module 26: Secure Data Access in Microsoft Fabric
Topics:
- Workspace roles
- Item permissions
- OneLake security roles
Module 27: Administer a Microsoft Fabric Environment
Topics:
- Understand the Fabric admin model
- Configure tenant settings and delegate admin rights
- Manage user access and licensing
- Monitor and govern your Fabric environment
