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 to design and develop effective data loading patterns, data architectures, and orchestration processes. The objectives of this course include data ingestion and transformation, as well as 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 certification exam included free of charge. Don't miss this opportunity! The exam is valued at €126 + VAT and is included at no additional cost.

Promotion valid until December 31, 2026. One-time exam available only in Virtual - Distance Learning format.

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 create and implement data engineering solutions using Microsoft Fabric for enterprise-scale data analytics. Students must 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 data storage 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
  
• Data analysis 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 moving data with Microsoft Fabric
  
• Organizing a lakehouse with a medallion 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 medallion 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 storage in Microsoft Fabric
  
• Loading data into Microsoft Fabric data storage
  
• Monitoring Microsoft Fabric data storage
  
• Protecting Microsoft Fabric data storage

Labs

• Analyzing data in data storage
• Loading data into Microsoft Fabric data storage
  
• Monitoring data storage in Microsoft Fabric
  
• Securing storage in Microsoft Fabric

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

• Implementing continuous integration and continuous delivery (CI/CD)
  
• Monitoring activities in Microsoft Fabric
  
• Secure access to data in Microsoft Fabric
  
• Microsoft Fabric administration

Labs

• Implementing Microsoft Fabric deployment pipelines
  
• Monitoring Fabric activity in the Monitoring Hub
  
• Secure access to data in Microsoft Fabric

Prerequisites

• Familiarity with Microsoft Fabric
• You must be familiar with basic data concepts and terminology.
• The student must be familiar with Microsoft Fabric and SQL.
• You must have experience with Microsoft Fabric or Power BI, and 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 must have experience with data loading patterns, data architectures, and orchestration processes.

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