Skip to Content
View all events

Microsoft Fabric Data Engineer Associate Bootcamp (DP-700)

Published by O'Reilly Media, Inc.

Intermediate content levelIntermediate

Learn in-demand skills and become a certified Fabric data engineer

Course outcomes

  • Understand the role of the data engineer in today’s data realm
  • Examine various components of Microsoft Fabric and their use cases
  • Discover implementation methods of Microsoft Fabric concepts and features from a data engineering perspective
  • Get ready for Exam DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric

Course description

Join expert Nikola Ilic to discover how to develop data engineering solutions using Microsoft Fabric—and get ready to acquire the popular DP-700 certificate. You’ll learn key Fabric components, including OneLake and various Fabric engines, essential skills such as configuring security and governance controls, implementing lifecycle management, orchestrating data workflows, and monitoring performance. You’ll also explore handling batch and streaming data, troubleshooting common errors, and applying best practices for pipeline and query optimization. The course includes many useful tips for passing the DP-700 exam, but even if you’re not contemplating certification, you’ll pick up skills that you can immediately apply in your day-to-day job.

NOTE: With today’s registration, you’ll be signed up for both sessions. Although you can attend either of the sessions individually, we recommend participating in both.

What you’ll learn and how you can apply it

  • Transform raw data into actionable insights by developing robust data engineering solutions in Microsoft Fabric
  • Process and enrich data to enhance the analytical value
  • Configure and secure Fabric assets
  • Improve performance and monitor data engineering solutions

This live event is for you because...

  • You’re a data architect, analytics engineer, or a BI professional who wants to transition into a data engineer role.
  • You work with data using tools or services such as Microsoft Fabric, Azure Synapse Analytics, Azure Data Factory, Azure Data Explorer, or Azure SQL DB.
  • You want to become a certified Microsoft Fabric data engineer.

Prerequisites

  • Experience with any BI tool, preferably Microsoft’s stack
  • Basic understanding of data loading patterns
  • Foundational knowledge of data architectures

Recommended follow-up:

Schedule

The time frames are only estimates and may vary according to how the class is progressing.

Day 1: Implementing and Managing an Analytics Solution/Ingesting and Transforming Data

Introduction (15 minutes)

  • Presentation: Check-in, agenda, and learning outcomes
  • Group discussion: Your experience level with Microsoft Fabric and related tools
  • Q&A

Microsoft Fabric core components (50 minutes)

  • Presentation: Understanding the platform, tools, and people who work with Fabric; OneLake; different Fabric engines; Delta format as a key pillar of Fabric
  • Q&A

Configuring Microsoft Fabric workspace settings (30 minutes)

  • Presentation: Configuring Spark workspace settings
  • Q&A
  • Break

Implementing lifecycle management in Fabric (30 minutes)

  • Presentation: Configuring version control; implementing database projects; creating and configuring deployment pipelines

Configuring security and governance (50 minutes)

  • Presentation: Implementing workspace-level access controls; implementing dynamic data masking; applying sensitivity labels to items; endorsing items
  • Q&A
  • Break

Orchestrating processes (35 minutes)

  • Presentation: Choosing between a pipeline and a notebook; designing and implementing schedules and event-based triggers; implementing orchestration patterns with notebooks and pipelines, including parameters and dynamic expressions

Designing and implementing loading patterns (30 minutes)

  • Presentation: Designing and implementing full and incremental data loads; preparing data for loading into a dimensional model; designing and implementing a loading pattern for streaming data

Day 2: Ingesting and Transforming Data/Monitoring and Optimizing an Analytics Solution

Ingesting and transforming batch data (100 minutes)

  • Presentation: Choosing an appropriate data store; choosing between dataflows, notebooks, and T-SQL for data transformation; creating and managing shortcuts to data implementing mirroring; ingesting data by using pipelines; transforming data by using PySpark, SQL, and KQL; denormalizing data; grouping and aggregating data; handling duplicate, missing, and late-arriving data
  • Q&A
  • Break

Ingesting and transforming streaming data (30 minutes)

  • Presentation: Choosing an appropriate streaming engine; processing data by using eventstreams, Spark structured streaming, and KQL; creating windowing functions

Monitoring Fabric items (20 minutes)

  • Presentation: Monitoring data ingestion, transformation, and semantic model refresh; configuring alerts

Identifying and resolving errors (30 minutes)

  • Presentation: Identifying and resolving pipeline errors
  • Q&A
  • Break

Optimizing performance (30 minutes)

  • Presentation: Optimizing lakehouse tables, pipelines, data warehouses, eventstreams and eventhouses; optimizing Spark performance and query performance

Practical exam tips (30 minutes)

  • Presentation: How to prepare for the exam—practical tips, tricks, and recommendations
  • Group discussion: What do you expect from the certificate?
  • Hands-on exercise: Quiz
  • Q&A

Your Instructor

  • Nikola Ilic

    Nikola Ilic is known as “Data Mozart,” because he’s making music from the data! He works as an independent data platform consultant and trainer focusing on Microsoft technologies. For his exceptional contributions to the tech community, Nikola was awarded a Microsoft Data Platform MVP. He’s also a Microsoft Certified Trainer, blogger, public speaker, mentor, and author of many online courses. He’s interested in everything related to data and is always eager to extract valuable info from raw data most effectively.

Skill covered

Microsoft Fabric