Course Overview on DP-700 Microsoft Fabric Data Engineering Course

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:

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
Courses like Azure Fundamentals will be helpful

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