DP-601T00: Implementing a Lakehouse with Microsoft Fabric

Course Overview

The DP-601T00: Implementing a Lakehouse with Microsoft Fabric course offered by CounselTrain is designed to teach learners how to create a comprehensive analytics solution using Microsoft Fabric’s integrated analytics platform. The course covers key aspects of working with Microsoft Fabric, including:

Building and managing lakehouses
Leveraging Apache Spark for data processing
Utilizing Delta Lake tables for reliable data storage
Integrating Dataflows Gen2 for data ingestion
Using Data Factory pipelines for orchestrating and automating data workflows

Through detailed modules, participants will gain hands-on experience in implementing lakehouse architectures, from data exploration and transformation to visualization, and learn best practices for effective team collaboration within the Fabric ecosystem. Completing this course will prepare learners for Microsoft Fabric certification and equip them with the skills needed to design and implement robust analytics solutions on the Microsoft Fabric platform, paving the way for future innovation and data-driven decision-making.

Schedule Dates

DP-601T00: Implementing a Lakehouse with Microsoft Fabric

23 September 2024

DP-601T00: Implementing a Lakehouse with Microsoft Fabric

23 December 2024

DP-601T00: Implementing a Lakehouse with Microsoft Fabric

24 March 2025

DP-601T00: Implementing a Lakehouse with Microsoft Fabric

24 June 2025

Course Content

Introduction to Microsoft Fabric
Data teams and Fabric
Enable and use Microsoft Fabric

What is a Lakehouse
Work with a Fabric Lakehouse
Explore, transform and visualize data in the Lakehouse

Prepare to use Apache Spark
Run Spark in Fabric
Load data in a Spark DataFrame
Transform data in a Spark DataFrame
Partition the output file
Work with data using Spark SQL
Query Data using Spark SQL API
Visualize Data

Understand Delta Lake
Create delta tables using code in Spark
Managed vs External Tables
Work with delta tables in Spark
Data versioning and Time Trave
Use delta tables with Streaming data

Understand Dataflows (Gen2)
Dataflow (Gen2) benefits and limitations
Explore Dataflows (Gen2) in Microsoft Fabric
Integrate Dataflows (Gen2) and Pipelines in Microsoft Fabric

Pipelines in Microsoft Fabric
Common Activities – Copy Data
Common Activities – pipeline templates
Run and monitor pipelines

FAQs

Participants should have a basic understanding of data engineering concepts and experience with data platforms. Familiarity with Microsoft Azure and data management will be beneficial.

You will learn to:

Design and implement lakehouse architectures using Microsoft Fabric.
Integrate data lakes and data warehouses for unified data analytics.
Manage and optimize data workflows within the lakehouse environment.
Utilize Microsoft Fabric’s tools and features for effective data management.

Yes, the course includes practical labs where you will apply your knowledge by setting up and managing lakehouse environments using Microsoft Fabric.

To enroll, visit the CounselTrain website and complete the registration process. For additional assistance, reach out to our support team.

Topics include designing lakehouse architectures, integrating data lakes and warehouses, managing data workflows, and using Microsoft Fabric tools for data management.

The course provides essential skills for implementing and managing lakehouse architectures, enhancing your ability to handle complex data environments and advancing your career in data engineering and architecture.