# Databricks and Advanced Spark Day1 Lab

> In this lab, Zach walks you through how to work with the Massive API, to extract stock prices for various companies like Apple, Netflix, and MSFT. Zach also highlights the importance of understanding Spark's explain plans to optimize their queries and avoid performance issues, particularly regardin…

- Web page: https://www.dataexpert.io/lesson/databricksandadvancedsparkday1lab-feb26-p736-l2026
- Program: [DataExpert](https://www.dataexpert.io/program/data-expert)
- Module: Week 2: Databricks & Advanced Spark
- Access: Requires enrollment in DataExpert
- Length: 47 min video
- Skills: Python, ETL/ELT, Apache Spark, Git, Databricks
- Academy: DataExpert.io Academy

## About this lesson

In this lab, Zach walks you through how to work with the Massive API, to extract stock prices for various companies like Apple, Netflix, and MSFT. Zach also highlights the importance of understanding Spark's explain plans to optimize their queries and avoid performance issues, particularly regarding shuffle operations.

## Navigation

- Previous lesson: [Databricks and Advanced Spark Day1 Lecture](https://www.dataexpert.io/lesson/databricksandadvancedsparkday1lecture-feb26-p736-l2025.md)
- Next lesson: [Databricks and Advanced Spark Day2 Lecture](https://www.dataexpert.io/lesson/databricksandadvancedsparkday2lecture-feb26-p736-l2027.md)