DP-601: Implementing a Lakehouse with Microsoft Fabric

This course introduces the foundational components of implementing a data lakehouse with Microsoft Fabric.

At a glance

Level: Intermediate
Product: Microsoft Fabric
Audience/Role: Data Engineer, Data Analyst
Subject: Data management, Data analytics, Data engineering

Prerequisites

You should be familiar with basic data concepts and terminology.

Course content


Introduction to end-to-end analytics using Microsoft Fabric

  • Explore end-to-end analytics with Microsoft Fabric
  • Data teams and Microsoft Fabric
  • Enable and use Microsoft Fabric

Get started with lakehouses in Microsoft Fabric

  • Explore the Microsoft Fabric Lakehouse
  • Work with Microsoft Fabric Lakehouses
  • Explore and transform data in a lakehouse
  • Exercise - Create and ingest data with a Microsoft Fabric Lakehouse

Use Apache Spark in Microsoft Fabric

  • Prepare to use Apache Spark
  • Run Spark code
  • Work with data in a Spark dataframe
  • Work with data using Spark SQL
  • Visualize data in a Spark notebook
  • Exercise - Analyze data with Apache Spark

Work with Delta Lake tables in Microsoft Fabric

  • Understand Delta Lake
  • Create delta tables
  • Work with delta tables in Spark
  • Use delta tables with streaming data
  • Exercise - Use delta tables in Apache Spark

Ingest Data with Dataflows Gen2 in Microsoft Fabric

  • Understand Dataflows Gen2 in Microsoft Fabric
  • Explore Dataflows Gen2 in Microsoft Fabric
  • Integrate Dataflows Gen2 and Pipelines in Microsoft Fabric
  • Exercise - Create and use a Dataflow Gen2 in Microsoft Fabric

Use Data Factory pipelines in Microsoft Fabric

  • Understand pipelines
  • Use the Copy Data activity
  • Use pipeline templates
  • Run and monitor pipelines
  • Exercise - Ingest data with a pipeline

Organize a Fabric lakehouse using medallion architecture design

  • Describe medallion architecture
  • Implement a medallion architecture in Fabric
  • Query and report on data in your Fabric lakehouse
  • Considerations for managing your lakehouse
  • Exercise - Organize your Fabric lakehouse using a medallion architecture

Prepare for your Applied Skills credential 

This one-day, instructor-led training is recommended as preparation for the assessment Implement a lakehouse in Microsoft Fabric

Microsoft Applied Skills is a new scenario-based credential that proves your proficiency in skill sets specific to critical business problems, so you can make a bigger impact on your projects, your organization, and your career.