DP-700: Implement data engineering solutions using Microsoft Fabric

DP-700 Course: Implement data engineering solutions using Microsoft Fabric

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

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

Promotion valid until June 30, 2026. One-attempt exam available only in Virtual - Tele-training modality.

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

Course aimed at

This course is aimed at 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 with 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 in 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.

DP-700 Training Elements

• Ingest data with Microsoft Fabric
• Implement a Lakehouse instance with Microsoft Fabric
• Implement real-time intelligence with Microsoft Fabric
• Implement a data warehouse with Microsoft Fabric
• Manage a Microsoft Fabric environment
• Use Activator in Microsoft Fabric

DP-700 Course Content: Implementing Data Engineering Solutions with Microsoft Fabric

Module 1. Microsoft Fabric and Lakehouse Fundamentals

• Exploring End-to-End Analytics with Microsoft Fabric
  
• Introduction to Data Lakehouses in Microsoft Fabric
  
• Using Apache Spark in Microsoft Fabric
  
• Using Delta Lake Tables in Microsoft Fabric
  
• Ingesting Data with Dataflow Gen2 in Microsoft Fabric

Labs

• Creating and Ingesting Data with a Microsoft Fabric Data Lakehouse
  
• Analyzing Data with Apache Spark
  
• Using Delta Tables in Apache Spark
  
• Creating and Using a Dataflow Gen2 in Microsoft Fabric

Module 2. Data Ingestion, Orchestration, and Architecture in Microsoft Fabric

• Orchestrating Processes and Data Movement with Microsoft Fabric
  
• Organizing a Lakehouse with Medal Architecture
  
• Introduction to Real-time Intelligence in Microsoft Fabric
  
• Using Real-time Eventstreams in Microsoft Fabric
  
• Working with Real-time Data in a Microsoft Fabric Event Hub

Labs

• Ingesting Data with a Pipeline
  
• Organize your Fabric Lakehouse using a Medal Architecture
  
• Exploring Real-time Intelligence in Fabric
  
• Ingesting Real-time Data with Microsoft Fabric Eventstream
  
• Working with Data from a Microsoft Fabric Event Hub

Module 3. Real-time Data and Analytical Storage in Microsoft Fabric

• Introduction to Data Warehouses in Microsoft Fabric
  
• Loading Data into a Microsoft Fabric Data Warehouse
  
• Monitoring a Microsoft Fabric Data Warehouse
  
• Securing a Microsoft Fabric Data Warehouse

Labs

• Analyzing Data in a Data Warehouse
• Loading Data into a Microsoft Fabric Data Warehouse
  
• Monitoring Data Warehouses in Microsoft Fabric
  
• Securing a Storage in Microsoft Fabric

Module 4. Governance, Security, CI/CD, and Administration of Microsoft Fabric

• Implementing Continuous Integration and Continuous Delivery (CI/CD)
  
• Monitoring Activities in Microsoft Fabric
  
• Secure Access to Data in Microsoft Fabric
  
• Administering Microsoft Fabric

Labs

• Implementing Microsoft Fabric Deployment Pipelines
  
• Monitoring Fabric Activity in the Monitoring Center
  
• Secure Access to Data in Microsoft Fabric

Prerequisites

• Familiarity with Microsoft Fabric
• Should be familiar with basic data concepts and terminology.
• The student should be familiar with Microsoft Fabric and SQL.
• Must 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

Associated Microsoft 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