DP-601: Implementing a Lakehouse with Microsoft Fabric
This course introduces the foundational components of implementing a data lakehouse with Microsoft Fabric.
Course content
Introduction to end-to-end analytics using Microsoft Fabric
- Explore end-to-end analytics with Microsoft Fabric
- Data teams and Microsoft Fabric
- Enable and use Microsoft Fabric
Get started with lakehouses in Microsoft Fabric
- Explore the Microsoft Fabric Lakehouse
- Work with Microsoft Fabric Lakehouses
- Explore and transform data in a lakehouse
- Exercise - Create and ingest data with a Microsoft Fabric Lakehouse
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
- Exercise - Analyze data with Apache Spark
Work with Delta Lake tables in Microsoft Fabric
- Understand Delta Lake
- Create delta tables
- Work with delta tables in Spark
- Use delta tables with streaming data
- Exercise - Use delta tables in Apache Spark
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
- Exercise - Create and use a Dataflow Gen2 in Microsoft Fabric
Use Data Factory pipelines in Microsoft Fabric
- Understand pipelines
- Use the Copy Data activity
- Use pipeline templates
- Run and monitor pipelines
- Exercise - Ingest data with a pipeline
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
- Exercise - Organize your Fabric lakehouse using a medallion architecture
Prepare for your Applied Skills credential
This one-day, instructor-led training is recommended as preparation for the assessment Implement a lakehouse in Microsoft Fabric
Microsoft Applied Skills is a new scenario-based credential that proves your proficiency in skill sets specific to critical business problems, so you can make a bigger impact on your projects, your organization, and your career.