Microsoft Fabric Data Engineer (DP-700)
Level: Intermediate
Build Advanced Microsoft Fabric Data Engineering Skills
Design Data Pipelines, Lakehouses & Warehouses
Gain an Industry-Recognised Microsoft Certification
Official Microsoft Course Materials & Exam Included
Welsh Government Funding Accepted
Get this course for FREE with PLA Digital Funding!
Course Overview
Duration:
4 Days (9am-5pm)
Accredited:
Yes
Exams:
Included
Funding:
PLA, PLA Digital, ReAct
Type:
Classroom, Onsite, Virtual
Company group booking discount available
Course Overview
Duration:
4 Days (9am-5pm)
Accredited:
Yes
Exams:
Included
Funding:
PLA, PLA Digital, ReAct
Type:
Classroom, Onsite, Virtual
Company group booking discount available
This course provides the knowledge and skills required to design, build and manage data engineering solutions using Microsoft Fabric. It is designed for experienced data professionals who want to learn how to implement modern data architectures, orchestrate data workflows and deliver scalable analytics solutions within Microsoft's unified data platform. Throughout the course, learners will explore how to ingest, transform, store, secure and manage data using Microsoft Fabric. Topics include data integration, orchestration, monitoring, governance and performance optimisation, helping delegates develop the expertise needed to support enterprise-scale data engineering projects. The course focuses on practical implementation techniques and best practices, enabling learners to design effective data loading strategies, build robust data architectures and manage end-to-end data engineering solutions. By the end of the course, delegates will have the skills required to work confidently with Microsoft Fabric and apply their knowledge to real-world business scenarios.
Target Audience
- Data engineers responsible for designing, building and maintaining modern data platforms
- Data professionals working with data integration, transformation and orchestration solutions
- Azure Data Engineers looking to expand their skills into Microsoft Fabric
- Database professionals seeking to modernise data architectures using cloud-based technologies
- Business intelligence and analytics professionals involved in preparing and managing data for reporting and analytics
- Technical professionals responsible for data governance, security and monitoring within enterprise environments
- Individuals preparing for Microsoft Fabric Data Engineer certification
By the End of This Course, You Will Be Able To:
- Design and implement data engineering solutions using Microsoft Fabric
- Ingest, transform and load data from a variety of sources using Microsoft Fabric services
- Build scalable data architectures to support analytics and business intelligence workloads
- Create and manage data pipelines and orchestration processes
- Implement effective data storage strategies using Microsoft Fabric
- Secure and govern data assets using Microsoft Fabric security and compliance features
- Monitor, troubleshoot and optimise data engineering solutions
- Work with lakehouses, warehouses and other Microsoft Fabric data services
- Apply best practices for data integration, transformation and performance optimisation
- Support end-to-end data lifecycle management from ingestion through to analytics and reporting
- Prepare for the Microsoft Fabric Data Engineer certification examination
This course provides the knowledge and skills required to design, build and manage data engineering solutions using Microsoft Fabric. It is designed for experienced data professionals who want to learn how to implement modern data architectures, orchestrate data workflows and deliver scalable analytics solutions within Microsoft's unified data platform. Throughout the course, learners will explore how to ingest, transform, store, secure and manage data using Microsoft Fabric. Topics include data integration, orchestration, monitoring, governance and performance optimisation, helping delegates develop the expertise needed to support enterprise-scale data engineering projects. The course focuses on practical implementation techniques and best practices, enabling learners to design effective data loading strategies, build robust data architectures and manage end-to-end data engineering solutions. By the end of the course, delegates will have the skills required to work confidently with Microsoft Fabric and apply their knowledge to real-world business scenarios.
Target Audience
- Data engineers responsible for designing, building and maintaining modern data platforms
- Data professionals working with data integration, transformation and orchestration solutions
- Azure Data Engineers looking to expand their skills into Microsoft Fabric
- Database professionals seeking to modernise data architectures using cloud-based technologies
- Business intelligence and analytics professionals involved in preparing and managing data for reporting and analytics
- Technical professionals responsible for data governance, security and monitoring within enterprise environments
- Individuals preparing for Microsoft Fabric Data Engineer certification
By the End of This Course, You Will Be Able To:
- Design and implement data engineering solutions using Microsoft Fabric
- Ingest, transform and load data from a variety of sources using Microsoft Fabric services
- Build scalable data architectures to support analytics and business intelligence workloads
- Create and manage data pipelines and orchestration processes
- Implement effective data storage strategies using Microsoft Fabric
- Secure and govern data assets using Microsoft Fabric security and compliance features
- Monitor, troubleshoot and optimise data engineering solutions
- Work with lakehouses, warehouses and other Microsoft Fabric data services
- Apply best practices for data integration, transformation and performance optimisation
- Support end-to-end data lifecycle management from ingestion through to analytics and reporting
- Prepare for the Microsoft Fabric Data Engineer certification examination
Microsoft Fabric Data Engineer (DP-700)
Introduction to end-to-end analytics using Microsoft Fabric
- Explore end-to-end analytics with Microsoft Fabric
- Data teams and Microsoft Fabric
- Enable and use Microsoft Fabric
Get started with lakehouses in Microsoft Fabric
- Explore the Microsoft Fabric lakehouse
- Work with Microsoft Fabric lakehouses
- Explore and transform data in a lakehouse
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
- Visualise data in a Spark notebook
Work with Delta Lake tables in Microsoft Fabric
- Understand Delta Lake
- Create delta tables
- Optimise delta tables
- Work with delta tables in Spark
- Use delta tables with streaming data
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
Orchestrate processes and data movement with Microsoft Fabric
- Understand pipelines
- Use the Copy Data activity
- Use pipeline templates
- Run and monitor pipelines
Organise 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
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
- Visualise real-time data
- Automate actions
Use real-time eventstreams in Microsoft Fabric
- Components of eventstreams
- Eventstream sources and destinations
- Eventstream transformations
Work with real-time data in a Microsoft Fabric eventhouse
- Get started with an eventhouse
- Use KQL effectively
- Materialised views and stored functions
Get started with data warehouses in Microsoft Fabric
- Understand data warehouse fundamentals
- Understand data warehouses in Fabric
- Query and transform data
- Prepare data for analysis and reporting
- Secure and monitor your data warehouse
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
Monitor a Microsoft Fabric data warehouse
- Monitor capacity metrics
- Monitor current activity
- Monitor queries
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
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
Monitor activities in Microsoft Fabric
- Understand monitoring
- Use Microsoft Fabric Monitor Hub
- Take action with Microsoft Fabric Activator
Secure data access in Microsoft Fabric
- Understand the Fabric security model
- Configure workspace and item permissions
- Apply granular permissions
Administer a Microsoft Fabric environment
- Understand the Fabric Architecture
- Understand the Fabric administrator role
- Manage Fabric security
- Govern data in Fabric
Microsoft Fabric Data Engineer (DP-700)
Introduction to end-to-end analytics using Microsoft Fabric
- Explore end-to-end analytics with Microsoft Fabric
- Data teams and Microsoft Fabric
- Enable and use Microsoft Fabric
Get started with lakehouses in Microsoft Fabric
- Explore the Microsoft Fabric lakehouse
- Work with Microsoft Fabric lakehouses
- Explore and transform data in a lakehouse
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
- Visualise data in a Spark notebook
Work with Delta Lake tables in Microsoft Fabric
- Understand Delta Lake
- Create delta tables
- Optimise delta tables
- Work with delta tables in Spark
- Use delta tables with streaming data
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
Orchestrate processes and data movement with Microsoft Fabric
- Understand pipelines
- Use the Copy Data activity
- Use pipeline templates
- Run and monitor pipelines
Organise 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
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
- Visualise real-time data
- Automate actions
Use real-time eventstreams in Microsoft Fabric
- Components of eventstreams
- Eventstream sources and destinations
- Eventstream transformations
Work with real-time data in a Microsoft Fabric eventhouse
- Get started with an eventhouse
- Use KQL effectively
- Materialised views and stored functions
Get started with data warehouses in Microsoft Fabric
- Understand data warehouse fundamentals
- Understand data warehouses in Fabric
- Query and transform data
- Prepare data for analysis and reporting
- Secure and monitor your data warehouse
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
Monitor a Microsoft Fabric data warehouse
- Monitor capacity metrics
- Monitor current activity
- Monitor queries
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
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
Monitor activities in Microsoft Fabric
- Understand monitoring
- Use Microsoft Fabric Monitor Hub
- Take action with Microsoft Fabric Activator
Secure data access in Microsoft Fabric
- Understand the Fabric security model
- Configure workspace and item permissions
- Apply granular permissions
Administer a Microsoft Fabric environment
- Understand the Fabric Architecture
- Understand the Fabric administrator role
- Manage Fabric security
- Govern data in Fabric
- Exam duration: 100 minutes
- 50–60 multiple-choice, case study and scenario-based questions
- Passing score: 700 out of 1,000
- Closed-book examination – no reference materials are permitted during the exam
- Exam duration: 100 minutes
- 50–60 multiple-choice, case study and scenario-based questions
- Passing score: 700 out of 1,000
- Closed-book examination – no reference materials are permitted during the exam
- Four days of instructor-led training and exam preparation delivered by an accredited Microsoft trainer
- Official Microsoft course materials, labs and supporting learning resources
- Microsoft certification examination voucher included. Examination vouchers are usually valid for up to 12 months from the date of issue; however, funding rules may require learners funded through schemes such as PLA, ReAct or other government-funded programmes to sit their examination within a shorter timeframe.
- Exam Pass Guarantee – if you do not pass the exam after attending the course, you can retake the same training with NILC at no additional cost. You will only need to pay the examination fee charged by the exam provider. Applies to instructor-led courses only.
- Four days of instructor-led training and exam preparation delivered by an accredited Microsoft trainer
- Official Microsoft course materials, labs and supporting learning resources
- Microsoft certification examination voucher included. Examination vouchers are usually valid for up to 12 months from the date of issue; however, funding rules may require learners funded through schemes such as PLA, ReAct or other government-funded programmes to sit their examination within a shorter timeframe.
- Exam Pass Guarantee – if you do not pass the exam after attending the course, you can retake the same training with NILC at no additional cost. You will only need to pay the examination fee charged by the exam provider. Applies to instructor-led courses only.
There are no formal prerequisites for this course; however, it is recommended that learners have a solid understanding of core data concepts and experience working with data platforms and services. This course is intended for experienced data professionals, particularly those with knowledge of data integration, orchestration and analytics solutions. Previous experience with Microsoft data technologies, such as Azure Data Services or the skills covered in DP-203: Azure Data Engineer, would be beneficial. The following knowledge and experience will help learners get the most from the course:
- Familiarity with data lifecycle processes, including data ingestion, transformation, storage and reporting
- Experience working with relational databases and writing SQL queries
- Understanding of database design concepts, including tables, relationships and joins
- Knowledge of modern data platforms and data engineering principles
- Experience working with cloud-based data solutions is beneficial but not essential
There are no formal prerequisites for this course; however, it is recommended that learners have a solid understanding of core data concepts and experience working with data platforms and services. This course is intended for experienced data professionals, particularly those with knowledge of data integration, orchestration and analytics solutions. Previous experience with Microsoft data technologies, such as Azure Data Services or the skills covered in DP-203: Azure Data Engineer, would be beneficial. The following knowledge and experience will help learners get the most from the course:
- Familiarity with data lifecycle processes, including data ingestion, transformation, storage and reporting
- Experience working with relational databases and writing SQL queries
- Understanding of database design concepts, including tables, relationships and joins
- Knowledge of modern data platforms and data engineering principles
- Experience working with cloud-based data solutions is beneficial but not essential
Who is the Microsoft Fabric Data Engineer (DP-700) course suitable for?
The DP-700 course is designed for data professionals who want to develop data engineering solutions using Microsoft Fabric. It is particularly suitable for data engineers and professionals with experience in data integration, transformation and orchestration who want to develop their Microsoft Fabric skills.
Do I need previous data engineering experience?
There are no mandatory prerequisites, although this is an Intermediate-level course and previous data experience is strongly recommended. Familiarity with data ingestion, transformation, storage and visualisation will help you get the most from the training.
Do I need SQL experience for DP-700?
SQL experience is recommended. The course includes working with relational data, Spark SQL and T-SQL, so being comfortable with databases, tables, joins and querying data will make it easier to engage with the course material.
Who is the Microsoft Fabric Data Engineer (DP-700) course suitable for?
The DP-700 course is designed for data professionals who want to develop data engineering solutions using Microsoft Fabric. It is particularly suitable for data engineers and professionals with experience in data integration, transformation and orchestration who want to develop their Microsoft Fabric skills.
Do I need previous data engineering experience?
There are no mandatory prerequisites, although this is an Intermediate-level course and previous data experience is strongly recommended. Familiarity with data ingestion, transformation, storage and visualisation will help you get the most from the training.
Do I need SQL experience for DP-700?
SQL experience is recommended. The course includes working with relational data, Spark SQL and T-SQL, so being comfortable with databases, tables, joins and querying data will make it easier to engage with the course material.
Dates & Prices
Upcoming Courses
Live Instructor-Led Virtual
Spaces: Available
Start Date: Mon 14 December 2026
Can't find the course dates, location or delivery type you are looking for?
Fill out the request dates form above and we'll try our best to accommodate or contact us directly.
"*" indicates required fields
How we deliver our courses
Virtual
Our virtual courses allow you to access live instructor-led training from the same expert instructors that deliver our classroom courses, without leaving the comfort of your home or office. All virtual courses are fully interactive, and learners can communicate with their trainer and peers at any time.
Many of our virtual courses are also recorded, so you can recap over the content you learnt as many time as you wish.
Classroom
Our classroom courses allow you to learn and interact face-to-face with our expert instructors in a comfortable and modern training environment. All of our classroom based courses take place at NILC centers, or high quality training facilities, and include all required IT and physical equipment.
We also limit our class sizes to help promote better discussions and to ensure your learning experience is comfortable as possible.
Onsite
Save time and hassle by arranging for one of our expert instructors to come to you. Our onsite courses allow you to learn in a location of your choosing, and you can train as many or as few people as you want – from a single person or team to whole departments. We can also fully customize the course content to the specific requirements of your business or project.
We offer onsite courses throughout the UK and it can be a great team building opportunity for colleagues to come together, bond and discuss.
Online
Our Online Self Paced courses allow you to learn new skills from our expert instructors, in your own time and at your own pace. Our flexible online learning platform allows you to access content on your computer, tablet or mobile device, whether you’re on the move or at home. All our online courses come with immediate access and you can start learning straight away, from any internet enabled compatible device.
We also offer online email support from our expert instructors, so they’re always on hand and happy to help you with any questions which may arise.
Why choose NILC for your training?
Award-Winning Training with Industry-Leading Customer Satisfaction
Trusted Training Partner by Colleges, Government Organisations and Businesses
UK-Based Trainers with Real-World Industry Experience
Family-Run Business with Customer Service at Its Core
Rated Excellent on Trustpilot with 950+ Customer Reviews
Our learners rate us 'Excellent' on Trustpilot
Frequently Asked Questions
The DP-700 course is designed for data professionals who want to develop data engineering solutions using Microsoft Fabric. It is particularly suitable for data engineers and professionals with experience in data integration, transformation and orchestration who want to develop their Microsoft Fabric skills.
There are no mandatory prerequisites, although this is an Intermediate-level course and previous data experience is strongly recommended. Familiarity with data ingestion, transformation, storage and visualisation will help you get the most from the training.
SQL experience is recommended. The course includes working with relational data, Spark SQL and T-SQL, so being comfortable with databases, tables, joins and querying data will make it easier to engage with the course material.
You will learn how to implement data engineering solutions using Microsoft Fabric, including ingesting and transforming data, designing data architectures, orchestrating data processes and securing, managing and monitoring data solutions.
Yes. You will learn how to work with Fabric lakehouses and data warehouses, including loading, transforming, querying, securing and monitoring data. The course also explores medallion architecture and Delta Lake tables.
Yes. The course introduces Apache Spark within Microsoft Fabric. You will learn how to run Spark code, work with DataFrames, use Spark SQL and transform and analyse data using Fabric notebooks.
Yes. You will learn how to ingest and move data using Dataflows Gen2 and Microsoft Fabric pipelines. This includes using Copy Data activities, pipeline templates and monitoring data orchestration processes.
Yes. The course introduces Microsoft Fabric Real-Time Intelligence, including eventstreams, eventhouses and KQL. You will explore how real-time data can be ingested, transformed, stored, queried and visualised.
Yes. Eligible learners may be able to access funding through schemes including Personal Learning Accounts (PLA), PLA Digital, ReAct+ and Skills for the Workplace. Please contact NILC to discuss your eligibility
Frequently Asked Questions
The DP-700 course is designed for data professionals who want to develop data engineering solutions using Microsoft Fabric. It is particularly suitable for data engineers and professionals with experience in data integration, transformation and orchestration who want to develop their Microsoft Fabric skills.
There are no mandatory prerequisites, although this is an Intermediate-level course and previous data experience is strongly recommended. Familiarity with data ingestion, transformation, storage and visualisation will help you get the most from the training.
SQL experience is recommended. The course includes working with relational data, Spark SQL and T-SQL, so being comfortable with databases, tables, joins and querying data will make it easier to engage with the course material.
You will learn how to implement data engineering solutions using Microsoft Fabric, including ingesting and transforming data, designing data architectures, orchestrating data processes and securing, managing and monitoring data solutions.
Yes. You will learn how to work with Fabric lakehouses and data warehouses, including loading, transforming, querying, securing and monitoring data. The course also explores medallion architecture and Delta Lake tables.
Yes. The course introduces Apache Spark within Microsoft Fabric. You will learn how to run Spark code, work with DataFrames, use Spark SQL and transform and analyse data using Fabric notebooks.
Yes. You will learn how to ingest and move data using Dataflows Gen2 and Microsoft Fabric pipelines. This includes using Copy Data activities, pipeline templates and monitoring data orchestration processes.
Yes. The course introduces Microsoft Fabric Real-Time Intelligence, including eventstreams, eventhouses and KQL. You will explore how real-time data can be ingested, transformed, stored, queried and visualised.
Yes. Eligible learners may be able to access funding through schemes including Personal Learning Accounts (PLA), PLA Digital, ReAct+ and Skills for the Workplace. Please contact NILC to discuss your eligibility
Trusted By
Related Courses
Microsoft Azure Data Fundamentals (DP-900)
Level: Foundation
1 Day (9am-5pm)
Accredited: Yes
Funding: PLA, PLA Digital, ReAct
Get this course for FREE with PLA Digital Funding!
Power BI Data Analyst (PL-300)
Level: Intermediate
3 Days (9:30am-5:00pm)
Accredited: Yes
Funding: PLA, PLA Digital, ReAct
Get this course for FREE with PLA Digital Funding!
Microsoft Azure Database Administrator Associate (DP-300)
Level: Intermediate
4 Days (9am-5pm)
Accredited: Yes
Funding: PLA, PLA Digital, ReAct
Get this course for FREE with PLA Digital Funding!