Implementing Data Engineering Solutions with Microsoft Fabric (DP-700)
Your analyses depend on available, well-organised data. With Microsoft Fabric, connect collection, transformation and delivery to structure your data flows. Strengthen your ability to design processing aligned with application and business needs.
- Duration
- 4 days 28 hours
- Code
- RSDP-700 Code
- Certification
- Microsoft Certified : Fabric Data Engineer Associate Certification
Accredited training for the Microsoft Certified : Fabric Data Engineer Associate certification.
Presentation
Microsoft Fabric is Microsoft’s unified data analytics platform, bringing ingestion, storage through OneLake, transformation and analysis into a single environment. Organisations therefore need data engineers capable of designing robust, secure, high-performing solutions on this new platform.
This course develops the skills to implement and manage data engineering solutions with Microsoft Fabric. Learn to configure analytical workspaces, ingest and transform batch and streaming data, and monitor and optimise production data solutions.
After the program, you will be ready to take the DP-700 examination, included in our offering. Passing it earns Microsoft Certified: Fabric Data Engineer Associate certification (see the Certification tab for details).
Please note: this course replaces “DP-203: Data Engineering on Microsoft Azure”, retired on 31 December 2025.
Objectives
By the end of this course, you will be able to:
- configure workspaces, items and governance settings in Microsoft Fabric;
- implement and manage a Lakehouse model for data storage and organisation;
- ingest batch and streaming data from multiple sources;
- transform data using notebooks, pipelines and dataflows;
- resolve data ingestion and transformation errors;
- configure security and access to Fabric resources;
- monitor and optimise data engineering solution performance;
- pass DP-700 and earn Microsoft Certified: Fabric Data Engineer Associate certification.
Program
Module 1: implementing and managing an analytics solution with Microsoft Fabric
- Creating and configuring Fabric workspaces.
- Configuring governance and compliance settings.
- Creating and managing a Lakehouse for data storage.
- Implementing a data warehouse in Fabric.
Lab
- Configure a Fabric workspace and create a Lakehouse.
Module 2: ingesting batch and streaming data
- Batch ingestion using pipelines and dataflows.
- Connecting to internal and external data sources.
- Streaming data ingestion with Eventstream and Real-Time Intelligence.
- Selecting an ingestion method suited to the scenario.
Lab
- Ingest batch and streaming data into a Fabric Lakehouse.
Module 3: transforming data
- Transforming data with PySpark and SQL notebooks.
- Designing transformation flows with dataflows.
- Orchestrating transformations with Fabric pipelines.
- Resolving common ingestion and transformation errors.
Lab
- Transform data using a notebook and orchestrate processing with a pipeline.
Module 4: securing an analytics solution
- Securing Fabric data and resources through roles, permissions, row-level and object-level security.
- Managing access to workspaces and items.
- Implementing data governance best practices.
Lab
- Configure security and access for a Lakehouse and Fabric workspace.
Module 5: monitoring and optimising an analytics solution
- Monitoring pipelines, notebooks and dataflows.
- Identifying and resolving execution errors.
- Optimising query and processing performance.
- Planning and managing Fabric capacity costs.
Lab
- Monitor pipeline execution and optimise Fabric solution performance.
Audience
This course is intended for IT professionals involved in data engineering, including:
- data engineers designing, implementing and managing Microsoft Fabric data engineering solutions;
- IT professionals working on data projects within the Azure ecosystem;
- anyone seeking DP-700 certification to demonstrate Microsoft Fabric data engineering expertise.
Prerequisites
The following background is recommended:
- Data engineering knowledge: an understanding of data loading patterns, data architectures and orchestration processes.
- Azure service experience: familiarity with Azure, particularly data services, is an advantage.
- Programming fundamentals: basic SQL and ideally PySpark knowledge for practical Fabric notebook work.
- English: course materials and the examination are in English only, so strong reading comprehension is highly recommended.
Teaching and assessment methods
- Initial skills assessment
- Training materials provided to participants
- Continuous assessment throughout the course
- End-of-course feedback questionnaire
- Combination of theory and practical application
- Attendance records
- Post-course follow-up evaluation
- Quiz / multiple-choice questions
- Practical exercises
Course highlights
- Expert instructor: lessons delivered in French by an expert Microsoft-certified instructor.
- Practical approach: an official program built around extensive Microsoft Fabric hands-on work.
- DP-700 certification included: examination fees are included, with no additional charge. Microsoft Exam Replay provides a free retake if you do not pass on your first attempt.
- A forward-looking platform: Microsoft Fabric is Microsoft’s leading unified data analytics platform and a sought-after employment market skill.
Dates and sessions
Choose the date and delivery format that suit you.
No upcoming sessions are currently available.
Session alerts
Microsoft®, Microsoft Fabric®, Microsoft Azure Active Directory®, Microsoft 365®, Microsoft Entra® and Power Platform® are registered trademarks or trademarks of Microsoft Corporation in the United States and other countries.
fr
en