This is an example of a simple banner

Training: Implement a Lakehouse with Microsoft Fabric (DP-601)

Ref. DP-601
Duration:
1
 jour
Exam:
Optionnel
Level:
Intermédiaire

Implement a Lakehouse with Microsoft Fabric Training (DP-601)

You need to implement a lakehouse architecture but are unsure how to leverage Microsoft Fabric’s unified platform? The lakehouse paradigm combines the flexibility of data lakes with the structure of data warehouses, but requires specific implementation skills. Without hands-on experience, setting up an efficient lakehouse with proper data organization remains challenging.

This official Microsoft DP-601 Applied Skills training enables you in 1 day to implement a lakehouse using Microsoft Fabric. Guided by MCT-certified trainers, you learn to create and configure lakehouses, ingest data using pipelines and Dataflows Gen2, transform data with Apache Spark notebooks and SQL, and build a medallion architecture. You practice creating delta tables, optimizing storage and querying data through the SQL analytics endpoint. This hands-on credential validates your practical lakehouse implementation skills. Sessions are available in person in Geneva and Lausanne or via virtual classroom.

Participant Profiles

  • Data Analyst
  • Data Engineer
  • Data Scientist

Objectives

  • Create and configure a lakehouse in Microsoft Fabric
  • Ingest data using pipelines and Dataflows Gen2
  • Transform data with Apache Spark notebooks
  • Build and manage delta tables for structured storage
  • Implement a medallion architecture (bronze, silver, gold)
  • Query lakehouse data through the SQL analytics endpoint

Prerequisites

  • Understand data terminology
  • Know the basics of data storage
  • Have basic data analytics knowledge

Course Content

Module 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

Module 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

Module 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

Module 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

Module 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

Module 6: Orchestrate processes and data movement with Microsoft Fabric

  • Understand pipelines
  • Use the Copy Data activity
  • Use pipeline templates
  • Run and monitor pipelines

Module 7: 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

Documentation

  • Access to Microsoft Learn, Microsoft’s online learning platform, offering interactive resources and educational content to deepen your knowledge and develop your technical skills.

Lab / Exercises

  • This course provides you with exclusive access to the official Microsoft lab, enabling you to practice your skills in a professional environment.

Complementary Courses

Eligible Funding

ITTA is a partner of a continuing education fund dedicated to temporary workers. This fund can subsidize your training, provided that you are subject to the “Service Provision” collective labor agreement (CCT) and meet certain conditions, including having worked at least 88 hours in the past 12 months.

Additional Information

Microsoft Fabric lakehouse: unifying data lake and warehouse capabilities

The lakehouse paradigm in Microsoft Fabric combines the flexibility of data lakes with the structure and performance of data warehouses. Built on delta tables and Apache Spark, a Fabric lakehouse provides schema-on-read flexibility, ACID transactions and SQL analytics capabilities in a single architecture. This DP-601 Applied Skills credential validates your practical ability to implement lakehouses, making it valuable for data professionals transitioning to Fabric in Switzerland.

What you practice during this 1-day training

This hands-on training focuses entirely on practical lakehouse implementation. You create and configure lakehouses, ingest data using pipelines and Dataflows Gen2, transform data with Spark notebooks, build delta tables with proper partitioning, implement a medallion architecture (bronze, silver, gold layers) and query data through the SQL analytics endpoint. All exercises are performed on real Fabric environments with MCT-certified trainer guidance.

Frequently Asked Questions

What are the prerequisites for this DP-601 training?

You should have basic knowledge of data analytics concepts, familiarity with SQL and an understanding of data lake principles. No prior Fabric experience is required.

Is this an Applied Skills credential or a certification?

DP-601 is a Microsoft Applied Skills credential, which validates specific hands-on skills through a scenario-based assessment rather than a traditional multiple-choice exam.

How does this relate to DP-600?

DP-601 focuses specifically on lakehouse implementation, while DP-600 covers the broader analytics engineer role including warehouses, semantic models and Power BI. DP-601 is a good starting point before pursuing the full DP-600 certification.

Prix de l'inscription
CHF 850.-
Inclus dans ce cours
  • Training provided by a certified trainer
  • 180 days of access to Official Microsoft Labs
  • Official documentation in digital format
  • Official Microsoft achievement badge
Mois actuel

mer01juil09:00mer17:00VirtuelVirtual Etiquettes de sessionDP-601

mer01juil09:00mer17:00Genève, Route des Jeunes 35, 1227 Genève Etiquettes de sessionDP-601

mer05Aoû09:00mer17:00VirtuelVirtual Etiquettes de sessionDP-601

mer05Aoû09:00mer17:00Lausanne, Av. Mon-Repos 24, 1005 Lausanne Etiquettes de sessionDP-601

mer09Sep09:00mer17:00VirtuelVirtual Etiquettes de sessionDP-601

mer09Sep09:00mer17:00Genève, Route des Jeunes 35, 1227 Genève Etiquettes de sessionDP-601

mer14Oct09:00mer17:00VirtuelVirtual Etiquettes de sessionDP-601

mer14Oct09:00mer17:00Lausanne, Av. Mon-Repos 24, 1005 Lausanne Etiquettes de sessionDP-601

mer18Nov09:00mer17:00VirtuelVirtual Etiquettes de sessionDP-601

mer18Nov09:00mer17:00Genève, Route des Jeunes 35, 1227 Genève Etiquettes de sessionDP-601

Contact

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Opening hours

Monday to Friday
8:30 AM to 6:00 PM
Tel. 058 307 73 00

Contact-us

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Make a request

Contact

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request