DP-700: Implement data engineering solutions using Microsoft Fabric

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

This course covers methods and best 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.

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

Promotion valid until June 30, 2026. One-opportunity exam available only in Virtual - E-learning format. Not applicable to Self-Learning format.

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

Course aimed at

This course is designed for data professionals with experience in data extraction, transformation, and loading. DP-700 is intended for professionals who need to create 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).

Objectives of the DP-700 course

• 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 business 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.

Elements of the DP-700 formation

• Ingest data with Microsoft Fabric
• Implementing a Lakehouse instance with Microsoft Fabric
• Implementing real-time intelligence with Microsoft Fabric
• Implementing a data storage system with Microsoft Fabric
• Managing a Microsoft Fabric environment
• Using Activator in Microsoft Fabric

Course content DP-700 Implementation of data engineering solutions with Microsoft Fabric

Module 1. Fundamentals of Microsoft Fabric and Lakehouse

• Exploring end-to-end analytics with Microsoft Fabric
  
• Introduction to data lake warehouses in Microsoft Fabric
  
• Using Apache Spark in Microsoft Fabric
  
• Using Delta Lake tables in Microsoft Fabric
  
• Data ingestion with the Gen2 data flow in Microsoft Fabric

Laboratories

• Creating and ingesting data with a Microsoft Fabric data lake warehouse
  
• Data analysis with Apache Spark
  
• Using Delta tables in Apache Spark
  
• Creating and using a Gen2 data flow in Microsoft Fabric

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

• Process orchestration and data movement with Microsoft Fabric
  
• Organize a lake warehouse with medal architecture
  
• Introduction to real-time intelligence in Microsoft Fabric
  
• Using real-time Eventstreams in Microsoft Fabric
  
• Working with real-time data at a Microsoft Fabric event center

Laboratories

• Data ingestion with a pipeline
  
• Organize your Fabric lake warehouse using a medal architecture
  
• Exploring real-time intelligence in Fabric
  
• Real-time data ingestion with Microsoft Fabric Eventstream
  
• I work with data from a Microsoft Fabric event center

Module 3. Real-time data and analytical storage in Microsoft Fabric

• Introduction to data storage in Microsoft Fabric
  
• Load data into a Microsoft Fabric data store
  
• Monitoring a Microsoft Fabric data warehouse
  
• Protecting a Microsoft Fabric data store

Laboratories

• Data analysis in a data warehouse
• Load data into a Microsoft Fabric data warehouse
  
• Monitoring data storage in Microsoft Fabric
  
• Secure storage on Microsoft Fabric

Module 4. Governance, security, CI/CD and administration of Microsoft Fabric

• Implementation of continuous integration and continuous delivery (CI/CD)
  
• Monitoring activities in Microsoft Fabric
  
• Secure access to data in Microsoft Fabric
  
• Microsoft Fabric Administration

Laboratories

• Implementation of Microsoft Fabric deployment pipelines
  
• Monitoring Fabric's activity at the Monitoring Center
  
• Secure access to data in Microsoft 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 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

Microsoft Associate Certification: Fabric Data Engineer Associate

Microsoft Certified: Fabric Data Engineer Associate

As a Fabric data engineer, you must have experience in data loading patterns, data architectures, and orchestration processes.

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