DP-700: Microsoft Certified Fabric Data Engineer Associate

Name: DP-700: Microsoft Certified Fabric Data Engineer Associate
Rating: 4.5 (70 reviews)

Prepare for the DP-700 Exam with Instructor led Hands-On Labs and Videos

Created byKuljot Singh Bakshi

Last updated 5/2026

English

What you'll learn

DP-700 Certification
Fabric Data Engineering
Microsoft Fabric Fundamentals
Data Engineering with Microsoft Fabric

Course content

6 sections • 31 lectures • 7h 13m total length

Course Introduction3:25
Explore how to design, create, and deploy data engineering solutions with Microsoft Fabric through hands-on labs covering lakehouse, warehouse, ingestion, and real-time intelligence, and prepare for the DP-700 certification.

What is Microsoft Fabric?23:44
Discover how Microsoft Fabric unifies data engineering, data lakes, data science, and AI workloads in a single SaaS platform built on one lake for a shared source of truth.
Fabric Licensing Guide16:39
Lab: Getting Started with Fabric Portal (Hands-On Lab)7:59
Explore the Microsoft Fabric portal by creating a workspace and a lakehouse. Query data via SQL analytics endpoint, work with delta lake and parquet storage, and leverage Power BI integration.
Data Analytical Engines in Fabric20:49
Explore data analytical engines in Microsoft Fabric, focusing on Apache Spark and the SQL analytics endpoint in the lakehouse, with startup and custom pools and capacity SKUs.
Lab: Data Transformation with Apache Spark, SQL and T-SQL (Hands-On Lab)31:32
Lab: Default Semantic Model in Lakehouse (Hands-On Lab)5:52
What is Data Lakehouse and OneLake?25:03
Explore data lakehouse and one lake in Microsoft Fabric, merging data lake and data warehouse concepts, with delta lake and ACID ensuring reliable, scalable BI and AI workloads.
OneLake Explorer2:17
Discover how OneLake Explorer embeds into your file explorer to reveal Microsoft Fabric workspaces, lake houses, and parquet or delta format tables for quick data viewing.
Working With Delta Tables: Creating Managed and External Tables and Optimization17:02
Lab: Working With Delta Tables (Hands-On Lab)28:49
Engage in a hands-on lab to work with delta tables and optimize writes. Create managed and external tables, partition data, and stream IoT data in a lake house with Spark.
Why Data Warehouse Matters4:33
Data warehouses deliver high performance for structured queries and bi reporting. They use simple dimensional models and provide workload isolation when moving the gold layer analytics from the lake house.
Lab: Loading Data from a Lakehouse from a Warehouse (Hands-On Lab)12:50
Understanding Semantic Models6:33
Explore semantic models in Microsoft Fabric and Power BI, linking data lakehouse and data warehouse tables to build facts and dimensions for insightful dashboards and BI reports.
Lab: Creating a Facts and Dimensions Semantic Model (Hands-On Lab)17:16
Create and connect a semantic model in a data warehouse, linking the trip fact to date, geography, time, and Hackney license dimensions to drive Power BI reports and dashboards.
Understanding Data Warehouse Security9:04
Lab: Secure a Microsoft Fabric Warehouse (Hands-On Lab)18:05
Lab: Monitoring a Data Warehouse (Hands-On Lab)9:41

Understanding the Medallion Architecture6:39
Understand the medallion architecture in Microsoft Fabric, building bronze, silver, and gold delta tables in a data lakehouse to power BI dashboards and AI and ML workloads.
Lab: Implementing Medallion Architecture (Hands-On Lab)23:46
Implement a medallion architecture in a fabric data lake house, moving a Covid-19 dataset from bronze to silver to gold and building a Power BI dashboard for 2021 aggregates.
Introduction to Dataflows and Fabric Pipelines7:36
Explore data flows and fabric pipelines that transform data in a no-code to low-code ETL, moving from data lake house to data warehouse for analysis and reporting.
Lab: Building Dataflow and Pipeline (Hands-On Lab)17:41

Intro to Real-Time Intelligence with Fabric13:27
Explore real-time intelligence in fabric by ingesting live data from sources such as azure cosmos db into event stream and event house, then build dashboards with kql and activator alerts.
Lab: Working with EventStream and EventHouse (Hands-On Lab)22:37
Learn to set up an event stream and event house in Microsoft Fabric, ingest stock data, run KQL queries, build a real-time stock dashboard, and configure an alert activator.
Introduction to Data Transformations in Evenstream10:50
Lab: Applying Data Transformations in EventStream (Hands-On Lab)12:58
Lab: Building Real-Time Dashboards (Hands-On Lab)20:49
Build real-time dashboards in Microsoft Fabric using event streams and event houses, ingesting bicycle data to create interactive maps and bar charts with base queries and parameter-driven filtering.

Introduction to Fabric Administrator Role10:22
Lab: Secure Data Access in Fabric (Hands-On Lab)8:20
Explore secure data access in fabric by applying guardrails at three levels: workspace, individual fabric items, and lakehouse data, with role-based permissions and read/write controls.
Introduction to CI/CD in Fabric9:58
Lab: Deployment Pipelines in Fabric (Hands-On Lab)7:26
Connect a git repository to a fabric workspace and deploy notebooks and data flow items through development, testing, and production environments in a no-code ci cd pipeline.

Requirements

No prior experience required. You will learn everything you need to know!

Description

DP-700: Fabric Data Engineer Associate

Master Microsoft Fabric & Ace the DP-700 Certification with Hands-On Labs

Are you ready to become a certified Microsoft Fabric Data Analyst? The DP-700 certification is your gateway to mastering data analysis, visualization, and business intelligence using Microsoft Fabric—a revolutionary platform that unifies data engineering, analytics, and AI in one ecosystem.

This course is designed to provide you with in-depth knowledge and practical skills to confidently analyze and visualize data while preparing you to pass the DP-700 certification exam.

Why Take This Course?

Comprehensive Coverage: Learn everything from data ingestion and transformation to visualization and governance in Fabric.
Hands-On Labs: Get real-world experience with practical labs that simulate industry scenarios.
Structured Learning Path: A step-by-step approach to understanding Microsoft Fabric and Data Engineering.
Certification Preparation: Covers all DP-700 exam objectives, ensuring you're fully prepared.
Learn from an Expert: Taught by Kuljot Singh Bakshi, a Microsoft Certified Trainer (MCT)

What You Will Learn

Understand Microsoft Fabric architecture and its role in modern data analytics
Ingest, clean, and transform data using Fabric Dataflows and Pipelines
Visualize data effectively with Power BI and build interactive reports
Work with Data Lakehouse and Warehouse
Work with real-time data using Eventhouse and Eventstream
Optimize data models and improve performance for real-time insights
Master governance, security, and compliance best practices

Who Should Enroll?

Aspiring Data Analysts & Engineers looking to gain Fabric expertise
IT Professionals & Cloud Enthusiasts transitioning into data analytics
Business Intelligence Professionals aiming to enhance reporting & visualization skills
Anyone preparing for the DP-700 exam and seeking a structured, hands-on learning experience

Get Certified & Advance Your Career

By the end of this course, you will have the confidence and skills to pass the DP-700 exam and apply your knowledge to real-world data engineering and analytics projects.

Enroll now and take the first step toward becoming a Microsoft-certified Data Engineer with Fabric.

Who this course is for:

DP-700 Certification Aspirants
Fabric Data Engineer Aspirants
AI Enthusiasts
Data Analysts
Data Engineers
Data Scientists

DP-700: Microsoft Certified Fabric Data Engineer Associate

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 3min

Implement a Lakehouse and Data Warehouse with Microsoft Fabric17 lectures • 4hr 18min

Ingest Data With Microsoft Fabric4 lectures • 56min

Implement Real Time Intelligence With Fabric5 lectures • 1hr 21min

Manage a Microsoft Fabric Environment4 lectures • 36min

Practise Tests0

Requirements

Description

Who this course is for: