Tailored to develop your fundamental skills in data engineering on Microsoft Fabric, with a specific emphasis on the Lakehouse concept, this Microsoft Fabric (DP-601) Training course delves into the robust capabilities of Apache Spark for distributed data processing. It covers essential techniques for efficient data management, versioning, and reliability through the utilization of Delta Lake tables. Additionally, the course explores data ingestion and orchestration using Dataflows Gen2 and Data Factory pipelines.
Comprising a blend of lectures and hands-on exercises, this course equips you to confidently navigate and work with Lakehouses in Microsoft Fabric.
Module 1: Introduction to end-to-end analytics using Microsoft Fabric
In this module, you'll learn how to:
- Describe end-to-end analytics in Microsoft Fabric
Module 2: Get started with lakehouses in Microsoft Fabric
In this module, you'll learn how to:
- 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
In this module, you'll learn how to:
- Configure Spark in a Microsoft Fabric workspace
- Identify suitable scenarios for Spark notebooks and Spark jobs
- Use Spark dataframes to analyse and transform data
- Use Spark SQL to query data in tables and views
- Visualise data in a Spark notebook
Module 4: Work with Delta Lake tables in Microsoft Fabric
In this module, you'll learn how to:
- 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
In this module, you'll learn how to:
- Describe Dataflow (Gen2) capabilities in Microsoft Fabric
- Create Dataflow (Gen2) solutions to ingest and transform data
- Include a Dataflow (Gen2) in a pipeline
Module 6: Use Data Factory pipelines in Microsoft Fabric
In this module, you'll learn how to:
- Describe pipeline capabilities in Microsoft Fabric
- Use the Copy Data activity in a pipeline
- Create pipelines based on predefined templates
- Run and monitor pipelines