DP-700: Microsoft Fabric Data Engineer

NEW COURSE: DP-700: Microsoft Fabric Data Engineer is replacing DP-203: Data Engineering on Microsoft Azure, which will be available starting March 31, 2025.

Course: DP-700 Microsoft Fabric Data Engineer

This course covers methods and practices for implementing data engineering solutions using Microsoft Fabric . Students will learn to design and develop effective data loading patterns, data architectures, and orchestration processes. The objectives of this course include data ingestion and transformation, and the protection, management, and monitoring of data engineering solutions. This course is designed for data professionals with experience in data integration and orchestration.

Virtual course with a free certification exam. Don't miss this opportunity! The exam is valued at €165 + VAT and is included at no additional cost.

Promotion valid until December 31, 2025. This exam is only available in the Virtual - Online learning mode. Not applicable to the Self-Learning mode.

Level: Intermediate - Role: Data Engineer - Subject: Data Engineering, Data Integration - Product: Microsoft Fabric

Course aimed at

This course is intended for data professionals with experience in data extraction, transformation, and loading. DP-700 is designed for professionals who need to build and implement data engineering solutions using Microsoft Fabric for enterprise-scale data analytics. Students should also have experience manipulating and transforming data using one of the following programming languages: Structured Query Language (SQL), PySpark, or Kusto Query Language (KQL).

DP-700 Course Objectives

• Understand the fundamental concepts of Microsoft Fabric, including its architecture and key components.
  
• Design and implement data engineering solutions using tools such as Data Factory, Lakehouse, Notebooks, and Pipelines.
  
• Integrate and transform data from multiple sources in enterprise environments.
  
• Apply data modeling practices for analysis and visualization with Power BI.
  
• Optimize the performance and security of data solutions on Microsoft Fabric.
  
• Use Copilot and other AI capabilities to accelerate data engineering tasks.
  
• Prepare for the DP-700 certification exam, validating practical skills in the Microsoft Fabric ecosystem.

Elements of the DP-700 formation

• Ingesting data with Microsoft Fabric

• Deploy a Lakehouse with Microsoft Fabric

• Implement real-time intelligence with Microsoft Fabric

• Implement a data warehouse with Microsoft Fabric

• Managing a Microsoft Fabric Environment

DP-700 Microsoft Fabric Data Engineer Course Content

Module 1: Data Ingestion with Gen2 Dataflows in Microsoft Fabric

• Introduction
• Understanding Gen2 Dataflows in Microsoft Fabric
  
• Exploring Gen2 Dataflows in Microsoft Fabric
  
• Integrating Gen2 data flows and pipelines in Microsoft Fabric
  
• Exercise: Creating and Using a Gen2 Dataflow in Microsoft Fabric

Module 2: Introduction to Real-Time Intelligence in Microsoft Fabric

• Introduction
  
• What is real-time data analytics?
  
• Real-time intelligence in Microsoft Fabric
  
• Real-time data ingestion and transformation
  
• Store and query data in real time
  
• Real-time data visualization
  
• Automate actions
  
• Exercise: Exploring Real-Time Intelligence in Fabric

Module 3: Using Real-Time Event Streams in Microsoft Fabric

• Introduction
  
• Components of event sequences
  
• Eventstream Origins and Destinations
• Eventstream Transformations

• Exercise: Ingesting Real-Time Data with Eventstream in Microsoft Fabric

Module 4: Working with Real-Time Data in a Microsoft Fabric Event Hub

• Introduction
  
• Introduction to an event house
  
• Effective use of KQL
  
• Materialized views and stored functions
  
• Exercise: Working with data from a Microsoft Fabric eventhouse

Module 5: Introduction to End-to-End Analytics with Microsoft Fabric

• Introduction
  
• Exploring End-to-End Analytics with Microsoft Fabric
  
• Exploring data teams and Microsoft Fabric
  
• Enabling and Using Microsoft Fabric

Module 6: Getting started with lakehouses in Microsoft Fabric

• Introduction
  
• Exploring the Microsoft Fabric Lake Warehouse
  
• Working with Microsoft Fabric Lake Stores
  
• Data Exploration and Transformation in a Data Lake Warehouse
  
• Exercise: Creating a Microsoft Fabric Lakehouse Instance

Module 7: Using Apache Spark in Microsoft Fabric

• Introduction
  
• Preparing to use Apache Spark
  
• Executing Spark Code
  
• Working with data in a Spark DataFrame
  
• Working with data with Spark SQL
  
• Visualizing data in a Spark notebook
  
• Exercise: Data Analysis with Apache Spark

Module 8: Using Delta Lake Tables in Microsoft Fabric

• Introduction
  
• Description of Delta Lake
  
• Creating delta tables
  
• Optimize delta tables
  
• Using Delta Tables in Spark
  
• Using Delta Tables with Streaming Data
  
• Exercise: Using Delta Tables in Apache Spark
  

Module 9: Data Ingestion with Gen2 Dataflows in Microsoft Fabric

• Introduction
  
• Understanding Gen2 Dataflows in Microsoft Fabric
  
• Exploring Gen2 Dataflows in Microsoft Fabric
  
• Integrating Gen2 data flows and pipelines in Microsoft Fabric
  
• Exercise: Creating and Using a Gen2 Dataflow in Microsoft Fabric

Module 10: Process Orchestration and Data Movement with Microsoft Fabric

• Introduction
  
• Description of the pipelines
  
• Using the Copy Data Activity
  
• Using pipeline templates
  
• Execution and supervision of pipelines
  
• Exercise: Ingesting data with a pipeline

Module 11: Organizing a Fabric Data Warehouse by Designing the Medal Architecture

• Introduction
  
• Description of medal architecture
  
• Implementing a medallion architecture in Fabric
  
• Query and report on data in your Fabric Lake warehouse
  
• Considerations for managing the lake warehouse
  
• Exercise: Organize your Fabric Lake warehouse using a medal architecture

Module 12: Introduction to Real-Time Intelligence in Microsoft Fabric

• Introduction
  
• What is real-time data analytics?
  
• Real-time intelligence in Microsoft Fabric
  
• Real-time data ingestion and transformation
  
• Store and query data in real time
  
• Real-time data visualization
  
• Automate actions
  
• Exercise: Exploring Real-Time Intelligence in Fabric

Module 13: Using Real-Time Event Streams in Microsoft Fabric

• Introduction
• Components of event sequences
• Eventstream Origins and Destinations
• Eventstream Transformations
• Exercise: Ingesting Real-Time Data with Eventstream in Microsoft Fabric

Module 14: Working with Real-Time Data in a Microsoft Fabric Event Hub

• Introduction
  
• Introduction to an event house
  
• Effective use of KQL
  
• Materialized views and stored functions
  
• Exercise: Working with data from a Microsoft Fabric eventhouse

Module 15: Creating Real-Time Dashboards with Microsoft Fabric

• Introduction
  
• Introduction to real-time dashboards
  
• Advanced Features
  
• Real-Time Dashboard Best Practices
  
• Exercise: Introduction to Real-Time Dashboards

Module 16: Introduction to Data Warehouses in Microsoft Fabric

• Introduction
  
• Description of the basic aspects of data storage
  
• Description of data stores in Fabric
  
• Data query and transformation
  
• Preparing data for analysis and reporting
  
• Data storage protection and monitoring
  
• Exercise: Analyzing data in a data warehouse

Module 17: Loading Data into a Microsoft Fabric Data Warehouse

• Introduction
  
• Exploring data loading strategies
  
• Using data pipelines to load a storage
  
• Loading data using T-SQL
  
• Loading and transforming data with Dataflow Gen2
  
• Exercise: Loading data into a warehouse in Microsoft Fabric

Module 18: Querying a Data Warehouse in Microsoft Fabric

• Introduction
  
• Consult data
  
• Using the SQL Query Editor
  
• Exploring the Visual Query Editor
  
• Using client tools to query storage
  
• Exercise: Querying a Data Warehouse in Microsoft Fabric

Module 19: Monitoring a Microsoft Fabric Data Warehouse

• Introduction
• Monitoring capacity metrics
  
• Monitoring current activity
  
• Query Monitoring
  
• Exercise: Monitoring a Data Warehouse in Microsoft Fabric

Module 20: Securing a Microsoft Fabric Data Warehouse

• Introduction
  
• Exploring Dynamic Data Masking
  
• Implementing row-level security
  
• Implementing column-level security
  
• Configuring granular SQL permissions using T-SQL
  
• Exercise: Securing a Vault in Microsoft Fabric

Module 21: Implementing Continuous Integration and Continuous Delivery (CI/CD) in Microsoft Fabric

• Introduction
  
• Continuous Integration and Continuous Delivery (CI/CD) Overview
  
• Implementing version control and Git integration
  
• Implementing deployment pipelines
  
• CI/CD Automation Using Fabric APIs
  
• Exercise: Implementing deployment pipelines in Microsoft Fabric

Module 22: Monitoring Activities in Microsoft Fabric

• Introduction
  
• Description of supervision
  
• Using the Microsoft Fabric Monitoring Center
  
• Perform actions with the Microsoft Fabric Trigger
  
• Exercise: Monitoring tissue activity in the monitoring center

Module 23: Secure Data Access in Microsoft Fabric

• Introduction
• Fabric Security Model Description
  
• Setting workspace and item permissions
  
• Application of detailed permissions
  
• Exercise: Securing Data Access in Microsoft Fabric

Module 24: Managing a Microsoft Fabric Environment

• Introduction
  
• Fabric Architecture Description
  
• Fabric Administrator Role Description
  
• Fabric Security Management
  
• Data Governance in Fabric

Prerequisites

• Familiarity with Microsoft Fabric
• You should be familiar with basic data concepts and terminology.
• The student should be familiar with Microsoft Fabric and SQL.
• You should have experience with Microsoft Fabric or Power BI, and have basic knowledge of data engineering and management concepts.

Language

• Course: English / Spanish

• Labs: English / Spanish

Microsoft Associate Certification: Fabric Data Engineer Associate

Microsoft Certified: Fabric Data Engineer Associate

As a Fabric Data Engineer, you should have experience with data loading patterns, data architectures, and orchestration processes.

Level: Intermediate
Role: Data Engineer
Product: Microsoft Fabric
Subject: Data and AI