Skip to main Content

Implementing a Lakehouse with Microsoft Fabric (DP-601)

  • Course Code M-DP601
  • Duration 1 day

Course Delivery

Virtual Learning Price

$450.00

excl. VAT

Request Group Training Add to Cart

Jump to:

Course Delivery

This course is available in the following formats:

  • Company Event

    Event at company

  • Public Classroom

    Traditional Classroom Learning

  • Virtual Learning

    Learning that is virtual

Request this course in a different delivery format.

Download Course Details

Course Overview

Top
This learning path introduces the foundational components of implementing a data lakehouse with Microsoft Fabric.

Virtual Learning

This interactive training can be taken from any location, your office or home and is delivered by a trainer. This training does not have any delegates in the class with the instructor, since all delegates are virtually connected. Virtual delegates do not travel to this course, Global Knowledge will send you all the information needed before the start of the course and you can test the logins.

Course Schedule

Top

Contact us for dates

Request Group Training Dates in Other Countries

Course Objectives

Top
  • Introduction to end-to-end analytics using Microsoft Fabric
  • Get started with lakehouses in Microsoft Fabric
  • Use Apache Spark in Microsoft Fabric
  • Work with Delta Lake tables in Microsoft Fabric
  • Ingest Data with Dataflows Gen2 in Microsoft Fabric
  • Use Data Factory pipelines in Microsoft Fabric
  • Organize a Fabric lakehouse using medallion architecture design
Show me more

Course Content

Top

Module 1: Introduction to end-to-end analytics using Microsoft Fabric

  • Describe end-to-end analytics in Microsoft Fabric

Module 2: Get started with lakehouses in Microsoft Fabric

  • Describe core features and capabilities of lakehouses in Microsoft Fabric
  • Create a lakehouse
  • Ingest data into files and tables in a lakehouse
  • Query lakehouse tables with SQL

Module 3: Use Apache Spark in Microsoft Fabric

  • Configure Spark in a Microsoft Fabric workspace
  • Identify suitable scenarios for Spark notebooks and Spark jobs
  • Use Spark dataframes to analyze and transform data
  • Use Spark SQL to query data in tables and views
  • Visualize data in a Spark notebook

Module 4: Work with Delta Lake tables in Microsoft Fabric

  • Understand Delta Lake and delta tables in Microsoft Fabric
  • Create and manage delta tables using Spark
  • Use Spark to query and transform data in delta tables
  • Use delta tables with Spark structured streaming

Module 5: Ingest Data with Dataflows Gen2 in Microsoft Fabric

  • Describe Dataflow capabilities in Microsoft Fabric
  • Create Dataflow solutions to ingest and transform data
  • Include a Dataflow in a pipeline

Module 6: Use Data Factory pipelines in Microsoft Fabric

  • Describe pipeline capabilities in Microsoft Fabric
  • Use the Copy Data activity in a pipeline
  • Create pipelines based on predefined templates
  • Run and monitor pipelines

Module 7: Organize a Fabric lakehouse using medallion architecture design

  • Describe the principles of using the medallion architecture in data management.
  • Apply the medallion architecture framework within the Microsoft Fabric environment.
  • Analyze data stored in the lakehouse using DirectLake in Power BI.
  • Describe best practices for ensuring the security and governance of data stored in the medallion architecture.
Show me more

Course Prerequisites

Top
  • You should be familiar with basic data concepts and terminology.
Show me more