Instructor-led IT training in Sydney + live online across Australia1300 014 325 · info@itroute.com.au
Microsoft Training · DP-700

Microsoft Fabric Data Engineer Associate Training (DP-700)

Build job-relevant Microsoft Fabric data engineering skills for ingesting, transforming, orchestrating, securing and monitoring data solutions.

Course description

Build job-relevant Microsoft Fabric data engineering skills for ingesting, transforming, orchestrating, securing and monitoring data solutions. ITRoute delivers instructor-led training from Sydney and live online for learners across Australia. The course combines trainer explanation, demonstrations, guided exercises and exam-focused revision so you can connect certification objectives with practical workplace skills.

This course is suitable for IT professionals, job seekers and career changers who want a structured learning pathway. Training options may include classroom, live online and supported self-paced study, depending on the intake.

Microsoft Fabric Data Engineer DP-700 Course Outline

Learn to build, manage and optimise data engineering solutions using Microsoft Fabric. Develop practical skills in data ingestion, transformation, orchestration, security and analytics performance.

Implement & Manage Analytics: 30–35% Ingest & Transform Data: 30–35% Monitor & Optimise: 30–35%

1. Microsoft Fabric & OneLake

  • Fabric workspaces, capacities and settings
  • Lakehouse, warehouse and OneLake architecture
  • Workspace configuration and data organisation

2. Security & Solution Management

  • Workspace and item access controls
  • OneLake security, sensitivity labels and governance
  • Version control and deployment pipelines

3. Data Ingestion & Pipelines

  • Full and incremental data loading
  • Data Factory pipelines and Dataflows Gen2
  • OneLake shortcuts, mirroring and orchestration

4. Data Transformation & Engineering

  • Transform data using SQL, PySpark and KQL
  • Clean, aggregate and prepare analytical data
  • Work with notebooks and dimensional models

5. Real-Time Data Processing

  • Eventstreams and Real-Time Intelligence
  • Spark structured streaming and KQL processing
  • Streaming patterns and windowing functions

6. Monitoring & Performance Optimisation

  • Monitor pipelines, notebooks and data refreshes
  • Troubleshoot ingestion and transformation errors
  • Optimise Lakehouse, warehouse and Spark performance

Hands-on Practical Training

Practise creating Microsoft Fabric workspaces, building Lakehouse and warehouse solutions, ingesting and transforming data, designing pipelines, applying security controls and monitoring data engineering workloads through guided exercises and real-world scenarios.

Course timetable, study options & price

Choose the study format that fits your work and personal commitments. ITRoute advertises regular full-time, part-time and weekend training, with live online access available for many courses.

IntakeTimetableCourse Price
Full Time26 Oct - 29 Oct
07 Dec - 10 Dec
18 Jan - 21 Jan
01 Mar - 04 Mar
12 Apr - 15 Apr
24 May - 27 May
05 Jul - 08 Jul
16 Aug - 19 Aug
$1,795 + GST
Part TimeMon & Tue, 6:00pm–9:00pm · 4 weeks$1,795 + GST
WeekendSaturday · 4–5 weeks$1,795 + GST
Live Online / FlexibleJoin remotely from across Australia; self-paced options may also be available.Ask for current online price

Schedule note: Dates, times, pricing and exam inclusions can change between intakes. Enquire for the next confirmed start date and written quotation before booking.

Job prospects after DP-700

Microsoft Fabric Data Engineer Associate can support skills development for roles such as the following. Certification can strengthen a CV, but employment outcomes also depend on experience, practical ability, communication skills and the requirements of individual employers.

Fabric Data EngineerData EngineerAnalytics EngineerCloud Data Engineer

How this course supports your career

Use the course to build practical vocabulary, demonstrate structured learning and prepare for certification. For learners targeting a new role, ITRoute career-focused packages can combine complementary certifications and hands-on skills into a broader job-ready pathway.

Who should attend?

Suitable for learners building skills in Microsoft, professionals updating their knowledge, and candidates preparing for DP-700. Basic computer and IT knowledge is helpful. Advanced courses may benefit from prior administration, networking, cloud, security or scripting experience.

Training delivery

Sydney classroom

Face-to-face instructor-led training with direct trainer interaction and practical exercises.

Live online

Real-time instructor-led training for learners in Melbourne, Brisbane, Adelaide, Perth, Canberra, Darwin, Hobart and other locations.

Flexible learning

Ask about supported self-paced resources, practice questions and trainer assistance where available.

Frequently asked questions

How much does the Microsoft Fabric Data Engineer Associate course cost?

The advertised classroom price shown on this redesigned page is $1,795 + GST. Confirm the current price, GST, exam voucher and promotional inclusions with ITRoute before enrolment.

Can I study part-time or on weekends?

Yes. ITRoute offers full-time, part-time and weekend formats across its certification portfolio. Availability depends on the intake, so request the next confirmed timetable.

Can I attend online?

Yes. Live instructor-led online training is available for many courses, allowing learners across Australia to attend in real time.

Does certification guarantee a job?

No. Certification demonstrates knowledge and can support job applications, but hiring depends on the employer, role requirements, practical experience and interview performance.