Capability Development / Data Engineering
Implement Data Engineering Solutions Using Microsoft Fabric (DP-700)
This course covers methods and practices for implementing and managing data engineering operations using Microsoft Fabric. Students build on existing data engineering experience and learn to use Microsoft Fabric components in depth, including workspace settings, lakehouses, data warehouses, Spark notebooks, dataflows, data pipelines, eventstreams and semantic models to create and deploy data engineering assets. They also learn to implement analytics best practices in Fabric, including identifying and resolving errors, optimization, data security and governance, and version control and deployment, aligned to the DP-700 certification.
Program Overview
This course covers methods and practices for implementing and managing data engineering operations using Microsoft Fabric. Students build on existing data engineering experience and learn to use Microsoft Fabric components in depth, including workspace settings, lakehouses, data warehouses, Spark notebooks, dataflows, data pipelines, eventstreams and semantic models to create and deploy data engineering assets. They also learn to implement analytics best practices in Fabric, including identifying and resolving errors, optimization, data security and governance, and version control and deployment, aligned to the DP-700 certification.
Audience Profile
Business Analysts working with Fabric-based analytics; Data Analysts and Data Scientists; Data Engineers building on existing data engineering experience; and Professionals preparing for the DP-700 certification exam.
Course Syllabus
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
Labs / Practice
- Create and Use a Dataflow Gen2 in Microsoft Fabric
Orchestrate Processes and Data Movement with Microsoft Fabric
Topics
- Understand Pipelines
- Use the Copy Data Activity
- Use Pipeline Templates
- Run and Monitor Pipelines
Labs / Practice
- Ingest Data with a Pipeline
Use Apache Spark in Microsoft Fabric
Topics
- Prepare to Use Apache Spark
- Run Spark Code
- Work with Data in a Spark Dataframe
- Work with Data Using Spark SQL
- Visualise Data in a Spark Notebook
Labs / Practice
- Analyze Data with Apache Spark
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
Labs / Practice
- Explore Real-Time Intelligence in Fabric
Use Real-Time Eventstreams in Microsoft Fabric
Topics
- Components of Eventstreams
- Eventstream Sources and Destinations
- Eventstream Transformations
Labs / Practice
- Ingest Real-Time Data with Eventstream in Microsoft Fabric
Work with Real-Time Data in a Microsoft Fabric Eventhouse
Topics
- Get Started with an Eventhouse
- Use KQL Effectively
- Materialized Views and Stored Functions
Labs / Practice
- Work with Data in a Microsoft Fabric Eventhouse
Introduction to End-To-End Analytics Using Microsoft Fabric
Topics
- Explore End-To-End Analytics with Microsoft Fabric
- Data Teams and Microsoft Fabric
- Enable and Use Microsoft Fabric
Get Started with Lakehouses in Microsoft Fabric
Topics
- Explore the Microsoft Fabric Lakehouse
- Work with Microsoft Fabric Lakehouses
- Explore and Transform Data in a Lakehouse
Labs / Practice
- Create a Microsoft Fabric Lakehouse
Work with Delta Lake Tables in Microsoft Fabric
Topics
- Understand Delta Lake
- Create Delta Tables
- Optimize Delta Tables
- Work with Delta Tables in Spark
- Use Delta Tables with Streaming Data
Labs / Practice
- Use Delta Tables in Apache Spark
Organise a Fabric Lakehouse Using Medallion Architecture Design
Topics
- Describe Medallion Architecture
- Implement a Medallion Architecture in Fabric
- Query and Report on Data in Your Fabric Lakehouse
- Considerations for Managing Your Lakehouse
Labs / Practice
- Organise Your Fabric Lakehouse Using a Medallion Architecture
Create Real-Time Dashboards with Microsoft Fabric
Topics
- Get Started with Real-Time Dashboards
- Advanced Features
- Real-Time Dashboard Best Practices
Labs / Practice
- Get Started with Real-Time Dashboards
Get Started with Data Warehouses in Microsoft Fabric
Topics
- 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
Labs / Practice
- Analyse Data in a Data Warehouse
Load Data into a Microsoft Fabric Data Warehouse
Topics
- Explore Data Load Strategies
- Use Data Pipelines to Load a Warehouse
- Load Data Using T-SQL
- Load and Transform Data with Dataflow Gen2
Labs / Practice
- Load Data into a Warehouse in Microsoft Fabric
Query a Data Warehouse in Microsoft Fabric
Topics
- Query Data
- Use the SQL Query Editor
- Explore the Visual Query Editor
- Use Client Tools to Query a Warehouse
Labs / Practice
- Query a Data Warehouse in Microsoft Fabric
Monitor a Microsoft Fabric Data Warehouse
Topics
- Monitor Capacity Metrics
- Monitor Current Activity
- Monitor Queries
Labs / Practice
- Monitor a Data Warehouse in Microsoft Fabric
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
Labs / Practice
- Secure a Warehouse in Microsoft Fabric
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
Labs / Practice
- Implement Deployment Pipelines in Microsoft Fabric
Monitor Activities in Microsoft Fabric
Topics
- Understand Monitoring
- Use Microsoft Fabric Monitor Hub
- Take Action with Microsoft Fabric Activator
Labs / Practice
- Monitor Fabric Activity in the Monitor Hub
Secure Data Access in Microsoft Fabric
Topics
- Understand the Fabric Security Model
- Configure Workspace and Item Permissions
- Apply Granular Permissions
Labs / Practice
- Secure Data Access in Microsoft Fabric
Administer a Microsoft Fabric Environment
Topics
- Understand the Fabric Architecture
- Understand the Fabric Administrator Role
- Manage Fabric Security
- Govern Data in Fabric