Training: Implement data engineering solutions using Microsoft Fabric (DP-700)

Ref. DP-700

Download PDF

Duration:

jours

Exam:

Optionnel

Level:

Intermédiaire

Funding:

Eligible

Home > Trainings > IT Pro > Analytics and Data Management > Implement data engineering solutions using Microsoft Fabric (DP-700)

Implement data engineering solutions using Microsoft Fabric Training (DP-700)

You need to build scalable data engineering pipelines but find managing multiple Azure data services complex and time-consuming? Microsoft Fabric simplifies data engineering by providing a unified lakehouse architecture with integrated Spark, pipelines and real-time capabilities. Without specialized data engineering skills on Fabric, organizations cannot efficiently process and prepare data at scale.

This official Microsoft DP-700 training gives you in 4 days the expertise to implement data engineering solutions using Microsoft Fabric. Guided by MCT-certified trainers, you master data ingestion patterns, Spark notebooks for data transformation, lakehouse and data warehouse architecture, real-time analytics and data orchestration with pipelines. You learn to optimize storage, implement medallion architecture and monitor data workflows. This training prepares you for the Fabric Data Engineer Associate certification. Sessions are available in person in Geneva and Lausanne or via virtual classroom.

Participant Profiles

Data engineers
Data solution architects
Data analysts
Developers specializing in data processing

Objectives

Design and implement data ingestion patterns in Microsoft Fabric
Transform data using Apache Spark notebooks and SQL
Implement lakehouse and data warehouse architectures
Build and orchestrate data pipelines for ETL/ELT workflows
Implement medallion architecture for data quality layers
Configure real-time analytics with Eventhouse
Monitor and optimize data engineering workloads

Prerequisites

Proficiency in SQL, PySpark, or KQL
Experience in data extraction and transformation
Understanding of data storage and orchestration concepts

Course Content

Module 1: Ingest Data with Dataflows Gen2 in Microsoft Fabric

Understand Dataflows Gen2 in Microsoft Fabric
Explore Dataflows Gen2 in Microsoft Fabric
Integrate Dataflows Gen2 and Pipelines in Microsoft Fabric

Module 2: Orchestrate processes and data movement with Microsoft Fabric

Understand pipelines
Use the Copy Data activity
Use pipeline templates
Run and monitor pipelines

Module 3: Use Apache Spark in Microsoft Fabric

Prepare to use Apache Spark
Run Spark code
Work with data in a Spark dataframe
Work with data using Spark SQL
Visualize data in a Spark notebook

Module 4: Work with real-time data in an Eventhouse in Microsoft Fabric

Get started with an Eventhouse
Use KQL effectively
Materialized views and stored functions

Module 5: Introduction to end-to-end analytics using Microsoft Fabric

Explore end-to-end analytics with Microsoft Fabric
Explore data teams and Microsoft Fabric
Enable and use Microsoft Fabric

Module 6: Get started with lakehouses in Microsoft Fabric

Describe lakehouse features and capabilities
Ingest and transform data in a lakehouse
Query and analyze lakehouse data

Module 7: Use Apache Spark in Microsoft Fabric

Prepare to use Apache Spark
Run Spark code
Work with data in a Spark dataframe
Work with data using Spark SQL
Visualize data in a Spark notebook

Module 8: Work with Delta Lake tables in Microsoft Fabric

Understand Delta Lake
Create delta tables
Optimize delta tables
Work with delta tables in Spark
Use delta tables with streaming data

Module 9: Ingest Data with Dataflows Gen2 in Microsoft Fabric

Understand Dataflows Gen2 in Microsoft Fabric
Explore Dataflows Gen2 in Microsoft Fabric
Integrate Dataflows Gen2 and Pipelines in Microsoft Fabric

Module 10: Orchestrate processes and data movement with Microsoft Fabric

Understand pipelines
Use the Copy Data activity
Use pipeline templates
Run and monitor pipelines

Module 11: Organize a Fabric lakehouse using medallion architecture design

Describe medallion architecture
Implement a medallion architecture in Fabric
Query and report on data in your Fabric lakehouse
Considerations for managing your lakehouse

Module 12: Get started with Real-Time Intelligence in Microsoft Fabric

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

Module 13: Use Eventstream in Microsoft Fabric

Components of Eventstream
Eventstream sources and destinations
Eventstream transformations

Module 14: Work with real-time data in an Eventhouse in Microsoft Fabric

Get started with an Eventhouse
Use KQL effectively
Materialized views and stored functions

Module 15: Create Real-Time Dashboards with Microsoft Fabric

Get started with real-time dashboards
Organize and filter dashboard data
Dashboard management and optimization

Module 16: Use Activator in Microsoft Fabric

Configure Activator for your data
Create rules in Activator
Configure actions in Activator

Module 17: Introduction to end-to-end analytics using Microsoft Fabric

Explore end-to-end analytics with Microsoft Fabric
Explore data teams and Microsoft Fabric
Enable and use Microsoft Fabric

Module 18: Get started with data warehouses in Microsoft Fabric

Understand data warehouses
Understand data warehouses in Fabric
Query and transform data
Model data in a warehouse
Secure and monitor a warehouse

Module 19: Load data into a Microsoft Fabric data warehouse

Explore data load strategies
Use data pipelines to load a warehouse
Load data using T-SQL
Load and transform data with Dataflow Gen2

Module 20: Query a data warehouse in Microsoft Fabric

Query data
Use the SQL query editor
Explore the visual query editor
Use client tools to query a warehouse

Module 21: Monitor a Microsoft Fabric data warehouse

Monitor capacity metrics
Monitor current activity
Monitor queries

Module 22: Secure a Microsoft Fabric data warehouse

Explore dynamic data masking
Implement row-level security
Implement column-level security
Configure SQL granular permissions using T-SQL

Module 23: Implement continuous integration and continuous delivery (CI/CD) in Microsoft Fabric

Understand Continuous Integration and Continuous Delivery (CI/CD)
Implement version control and Git integration
Implement deployment pipelines
Automate CI/CD using Fabric APIs

Module 24: Monitor activities in Microsoft Fabric

Understand monitoring
Use Microsoft Fabric Monitor Hub
Take action with Microsoft Fabric Activator

Module 25: Secure data access in Microsoft Fabric

Understand the Fabric security model
Configure workspace and item permissions
Apply granular permissions

Module 26: Administer a Microsoft Fabric environment

Understand the Fabric Architecture
Understand the Fabric administrator role
Manage Fabric security
Govern data in Fabric

Documentation

Access to Microsoft Learn, Microsoft’s online learning platform, offering interactive resources and educational content to deepen your knowledge and develop your technical skills.

Lab / Exercises

This course provides you with exclusive access to the official Microsoft lab, enabling you to practice your skills in a professional environment.

Exam

This course prepares you to the DP-700: Fabric Data Engineer Associate exam.

Complementary Courses

Eligible Funding

ITTA is a partner of a continuing education fund dedicated to temporary workers. This fund can subsidize your training, provided that you are subject to the “Service Provision” collective labor agreement (CCT) and meet certain conditions, including having worked at least 88 hours in the past 12 months.

Additional Information

Microsoft Fabric data engineering: building scalable data pipelines

Data engineering in Microsoft Fabric combines the power of Apache Spark with a unified lakehouse architecture, eliminating the need to manage separate services for ingestion, transformation and storage. For data engineers in Switzerland, Fabric represents the next evolution of the Azure data stack, simplifying infrastructure management while providing enterprise-grade capabilities. The DP-700 training focuses on the data engineering workload, covering everything from ingestion patterns to real-time processing.

What you learn during this 4-day training

The program follows the official Microsoft curriculum for the Fabric Data Engineer role. You learn to design and implement data ingestion using pipelines, Dataflows Gen2 and Spark notebooks. You build lakehouse and warehouse architectures implementing medallion patterns for data quality. Advanced topics include real-time analytics with Eventhouse, data orchestration, performance optimization and monitoring. You also learn to implement data governance and security best practices. Each module includes hands-on labs on production-grade Fabric environments.

Frequently Asked Questions

What are the prerequisites for this DP-700 training?

You should have experience with data engineering concepts, familiarity with SQL and basic knowledge of Apache Spark or Python. Experience with Azure data services and ETL processes is recommended.

Which certification does this training prepare for?

This training prepares you for the DP-700 exam leading to the Fabric Data Engineer Associate certification, validating your ability to implement data engineering solutions using Microsoft Fabric.

What is the difference between DP-600 and DP-700?

DP-600 focuses on analytics engineering (lakehouses, warehouses, semantic models, Power BI), while DP-700 focuses on data engineering (ingestion pipelines, Spark transformations, real-time processing, data orchestration). Both roles work within Microsoft Fabric but with different focus areas.