DP-601 – Implement a Lakehouse with Microsoft Fabric

About the Course

This course is designed to build your foundational skills in data engineering on Microsoft Fabric, focusing on the Lakehouse concept. This course will explore the powerful capabilities of Apache Spark for distributed data processing and the essential techniques for efficient data management, versioning, and reliability by working with Delta Lake tables. This course will also explore data ingestion and orchestration using Dataflows Gen2 and Data Factory pipelines. This course includes a combination of lectures and hands-on exercises that will prepare you to work with Lakehouses in Microsoft Fabric.

There are currently no scheduled sessions available for this course. However, feel free to contact us for more information or to inquire about upcoming sessions.

Questions about this? let our team answer them!

Course Outline

1. Introduction to end-to-end analytics using Microsoft Fabric
• Explore end-to-end analytics with Microsoft Fabric
• Explore data teams and Microsoft Fabric
• Enable and use Microsoft Fabric

2. Get started with lakehouses in Microsoft Fabric
• Describe lakehouse features and capabilities
• Ingest and transform data in a lakehouse
• Query and analyze lakehouse data

3. 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

4. Work with Delta Lake tables in Microsoft Fabric
• Understand Delta Lake
• Create delta tables
• Optimize delta tables
• Work with delta tables in Spark
• Use delta tables with streaming data

5. 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

6. Orchestrate processes and data movement with Microsoft Fabric
• Understand pipelines
• Use the Copy Data activity
• Use pipeline templates
• Run and monitor pipelines

7. Organize a Fabric lakehouse using medallion architecture design
• Describe medallion architecture
• Plan a medallion architecture in Fabric
• Query and report on data in your Fabric lakehouse
• Secure and govern your medallion lakehouse

Course Details

Pre-requisites

• Familiarity with the Microsoft Fabric interface and core concepts is recommended.

Target Audience

The primary audience for this course is data professionals who are familiar with data modeling, extraction, and analytics. It is designed for professionals who are interested in gaining knowledge about Lakehouse architecture, the Microsoft Fabric platform, and how to enable end-to-end analytics using these technologies.

Class Format

For online (live) format

There are currently no scheduled sessions available for this course. However, feel free to contact us for more information or to inquire about upcoming sessions.