DP-700 Microsoft Fabric Data Engineering Course

BECOME A CERTIFIED MICROSOFT FABRIC DATA ENGINEER

Details Audience and Pre-Requisites Course Outline / Curriculum Schedule Dates and Booking Enquiry

Details

Fabric components

Microsoft Fabric the unified data and analytics platform, brings together data engineering, data integration, data warehousing, real-time analytics, and business intelligence into a single environment:

  • Store data centrally in OneLake (a single, unified data lake)
  • Build and manage data pipelines
  • Transform and analyse data using Spark and SQL
  • Create reports and dashboards with Power BI

Fabric is an all-in-one platform for collecting, processing, analysing, and visualising data at scale. Simplify, modern data architecture that reduces complexity and improves inter disciplinary collaboration.

What You Will Learn

Build in-demand data engineering skills with our DP-700 Microsoft Fabric course. This practical, hands-on programme equips you to design, build, and manage modern data solutions using Microsoft Fabric’s unified analytics platform.

By the end of this course, you will be able to:

Design Data Solutions in Microsoft Fabric

  • Understand Fabric architecture and OneLake
  • Design Lakehouse and Data Warehouse solutions
  • Apply medallion architecture (Bronze, Silver, Gold)

Build and Manage Data Pipelines

  • Create and manage data pipelines
  • Implement batch and real-time data ingestion
  • Work with ETL/ELT processes

Transform and Model Data

  • Use PySpark and SQL for data transformation
  • Work with Delta Lake tables
  • Optimise data models for performance

Orchestrate and Automate Workflows

  • Schedule and manage pipelines
  • Implement event-driven processes
  • Manage dependencies and triggers

Secure and Govern Data

  • Apply role-based access control
  • Implement row-level security
  • Manage data governance and compliance

Monitor and Optimise Solutions

  • Monitor pipeline performance
  • Troubleshoot failures
  • Optimise queries and storage

Delivery Methods

Delivery Method Duration
Classroom
Instructor-led classroom-based training. Classes are scheduled at various conference centres in the Sandton area or your premises. Stationary and printed manuals or online resources are included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Training is between 9 am to 4 pm.
Classroom
3 days Get a Quote
Live Virtual Training
This course is delivered live via Microsoft Teams. You will be able to see and hear the instructor, view their whiteboard, and ask questions or communicate in the chat. Attend from the comfort of your own home or private office.
Live Virtual Training
3 days Get a Quote

Discounts Available

Save up to 10% by booking and paying 10 business days before the course.

Brochure:

Download Brochure

Information may change without notice.

Audience

  • Data engineers and data professionals
  • BI developers and analysts transitioning into engineering roles
  • IT professionals working with data platforms
  • Anyone preparing for the DP-700 certification exam

Pre-Requisites

 1. Basic Data Concepts (Essential)

  • What tables, rows, and columns are
  • Structured vs unstructured data
  • Basic idea of databases and data warehouses
  • What ETL / ELT means

This is foundational, without it, Fabric will feel overwhelming.

2. SQL (Strongly Recommended)

You don’t need to be advanced, but you should be comfortable with:

  • SELECT, WHERE, JOIN
  • Aggregations (GROUP BY, COUNT, SUM)
  • Basic data filtering and shaping

Fabric uses SQL heavily either T-SQL or Spark SQL (especially in Lakehouse + Warehouse layers). Our SQL course covers all this and more. see SQL Training Course

 3. Basic Data Analytics / BI Exposure (Helpful)

Familiarity with tools like Power BI or Excel helps you understand:

  • Data models
  • Reports and dashboards
  • How data is consumed by the business

We recommend our Microsoft Power BI PL-300-Aligned Bootcamp Training Course or Analysing Data with Excel Training Course if you prefer using Excel

4. Python (Optional but Useful)

Not mandatory, but helpful for:

  • Working with notebooks (PySpark)
  • More advanced transformations

Even basic Python familiarity gives you a big advantage. Couress that will be helpful include: Introduction to Programming Using Python Course for beginners or Python Programming Course for those who have programming experience already. 

 5. Cloud Basics (Nice to Have)

Basic understanding of:

  • What cloud platforms are (like Microsoft Azure)
  • Concepts like storage, compute, and services

Course Outline / Curriculum

Module 1: Introduction to Microsoft Fabric

  • Overview of Fabric platform
  • Data engineering roles and responsibilities

Module 2: Fabric Architecture & OneLake

  • Lakehouse vs Data Warehouse
  • Storage and compute models

Module 3: Data Ingestion

  • Pipelines and connectors
  • Batch vs streaming ingestion

Module 4: Data Transformation

  • Notebooks and PySpark
  • SQL-based transformations

Module 5: Data Modelling

  • Medallion architecture
  • Partitioning and performance

Module 6: Orchestration

  • Pipelines and scheduling
  • Workflow automation

Module 7: Security & Governance

  • Access control
  • Data protection

Module 8: Monitoring & Optimisation

  • Performance tuning
  • Troubleshooting

Module 9: Capstone Project

  • End-to-end data engineering solution

Schedule Dates and Booking

There are currently no scheduled dates.

Add me to the waiting list

Submit Enquiry

Name
Email
Telephone
Query