Get Started

Get Instructor-Led training in Sydney, or join our Live Online sessions across all major cities (Melbourne, Brisbane, Adelaide, Perth, Darwin & Hobart)

DP-700: Microsoft Fabric Data Engineer Associate


  • Course Description
  • Course Outline
  • Prerequisite
  • Lab Facilities
  • Course Benefits
  • Job Prospectus

The DP-700: Microsoft Fabric Data Engineer Associate course prepares learners to design, build, secure, and optimize end-to-end analytics solutions using Microsoft Fabric. It focuses on real-world data engineering tasks, including data ingestion, transformation, orchestration, storage management, and analytics optimization.
Throughout the course, participants gain hands-on experience with key Fabric components such as Dataflows Gen2, Apache Spark, Delta Lake, lakehouses, data warehouses, pipelines, and real-time intelligence tools. The program also covers governance, monitoring, and security best practices essential for enterprise data solutions.

The following one exam need to complete to achieve Microsoft Fabric Data Engineer Associate certification

Exam DP-700

DP-700: Microsoft Fabric Data Engineer Associate – Course Outline

1. Introduction to Microsoft Fabric

  • Overview of Microsoft Fabric
  • Key components: Data Factory, Synapse, Power BI, Data Activator
  • Understanding the unified data platform
  • Role of a Data Engineer in Microsoft Fabric

2. Ingesting and Transforming Data with Dataflows Gen2

  • Ingesting data using Dataflows Gen2
  • Transforming data using Power Query
  • Data pipeline concepts and activities
  • Managing and monitoring pipelines

3. Managing Data in OneLake and Lakehouses

  • Introduction to OneLake
  • Creating and managing lakehouses
  • Working with files and tables
  • Partitioning, indexing, and optimization

4. Data Engineering with Apache Spark in Fabric

  • Introduction to Spark in Microsoft Fabric
  • Writing PySpark notebooks
  • Data wrangling and processing with Spark
  • Managing compute and performance

5. Building Data Pipelines with Data Factory

  • Create and manage pipelines in Fabric
  • Mapping and wrangling data flows
  • Pipeline triggers and dependencies
  • Monitoring and troubleshooting pipelines

6. Creating and Managing Data Warehouses

  • Data warehouse vs lakehouse concepts
  • Designing a Fabric data warehouse
  • Ingesting data into warehouses
  • Querying with T‑SQL in Fabric

7. Designing End-to-End Data Solutions

  • Integrating lakehouses, data warehouses, and Power BI
  • Orchestrating pipelines and activities
  • Real-time analytics and alerting with Data Activator
  • Best practices for performance and scalability

8. Security, Governance & Monitoring

  • Data access and workspace roles
  • Row-level and column-level security
  • Monitoring Fabric workloads and diagnostics
  • Integration with Microsoft Purview

9. Data Governance & Compliance

  • Implement data classification and labeling
  • Secure sensitive data with RLS & CLS
  • Integrate with Purview for governance
  • Track lineage and auditing within workspaces

10. Automation with Fabric Pipelines

  • Automate end-to-end data workflows
  • Schedule and trigger pipelines
  • Use Fabric API & Logic Apps for integration
  • Error handling and retry strategies

Basic Microsoft Fabric Knowledge is required, Microsoft Azure Knowledge will have advantages

Hands on Lab exercise in the class, Additional practice lab after course completion, Lab & other facilities support provided

Microsoft official course material, Instructor-led onsite or online training, Course Material, Study guide, Practice Questions, Final Exam Fees

DP-700 Job Prospectus

Earning the DP-700: Microsoft Fabric Data Engineer Associate certification opens opportunities in modern data engineering roles. Certified professionals are equipped to work with enterprise-scale data ingestion, transformation, lakehouses, warehouses, Spark processing, and real-time analytics — skills highly valued in cloud data environments.
Roles commonly aligned with this certification include Data Engineer, Analytics Engineer, Data Architect, Administrator, and Business/Data Analyst, especially across organizations adopting Microsoft Fabric. .



How to join this course

You can join Sydney Campus onsite or join live training class from Sydney, Melbourne, Brisbane, Canberra, Adelaide, Perth, Darwin and any location where you have reliable internet connections.

  • Instructor-Led Classroom Based Training
  • Instructor-Led Live Online Training
  • Instructor-Led Self-Paced Training
Onsite Class Schedule: DP-700: Microsoft Fabric Data Engineer Associate
Intake TypeTimeDurationUpcoming CoursePRICE
Full Time Monday - Thursday
10:00am - 4:30pm
4 Days 16 FEB - 19 Feb
11 May - 14 May
22 Jun - 25 Jun
03 Aug - 06 Aug
14 Sep - 17 Sep
26 Oct - 29 Oct
07 Dec - 10 Dec
$1795 +GST Enquire Now
Part Time Monday & Tuesday
6:00pm - 9:00pm
4 Weeks TBA $1795 +GST Enquire Now
Weekend Saturday
9:00am - 2:00pm
5 Weeks TBA $1795 +GST Enquire Now
Online Live Class Schedule: DP-700: Microsoft Fabric Data Engineer Associate
Intake TypeTimeDurationUpcoming CoursePRICE
Full Time Monday - Thursday
10:00am - 4:30pm
4 Days 16 FEB - 19 Feb
11 May - 14 May
22 Jun - 25 Jun
03 Aug - 06 Aug
14 Sep - 17 Sep
26 Oct - 29 Oct
07 Dec - 10 Dec
$1795 +GST Enquire Now
Part Time Monday & Tuesday
6:00pm - 9:00pm
4 Weeks TBA $1795 +GST Enquire Now
Weekend Saturday
2:30pm - 6:30pm
5 Weeks TBA $1795 +GST Enquire Now
Self-Paced Training: DP-700: Microsoft Fabric Data Engineer Associate
Intake TypeTimeDurationUpcoming CoursePRICE
Self-Paced Training Course Anytime Anywhere Enrol Anytime
Training Video
Lab Excercise
Exam Voucher
PDF Course Material
Practice Questions
👉 Enquire Now

Certification Success Story

Recently I have passed my CCNP R & S from ITROUTE training centre. The course was excellent and I have done lot of practical labs. Soon I'm looking forward to do CCIE...

Kyle Hung (CCNP R & S) Sydney West Corp
Network Analyst

I have done my MCSA 2012 R2 from ITRoute Training Centre. Great price! Good lab facilities Good trainer, Good exam preparation resources, mock test helped to pass the final exam...

Tom (MCSA 2012 R2) Tamero Technologies
Sydney

Deb has successfully completed System Admin course recently and she is CCNA Certified and on the way to achieve ITIL & MCSA 2012 R2 exam...

Deborah System Analyst
Westpac Banking Coorporation

© 2023 ITRoute Communications Pty Ltd. All rights reserved.