# Delta Table Day 2 Lab

> In this video, Yared walks viewers through various data transformation techniques using SQL, focusing on data profiling, cleaning, and complex transformations. He highlights the importance of understanding data distribution and how to handle JSON data effectively. He also discusses the creation of…

- Web page: https://www.dataexpert.io/lesson/delta-table-day-2-lab-may2025-p736-l1131
- Program: [DataExpert](https://www.dataexpert.io/program/data-expert)
- Module: Week 3: Data Lakes with Delta Table
- Access: Requires enrollment in DataExpert
- Skills: SQL, Python, Data Modeling, ETL/ELT, Apache Spark, Delta Lake
- Academy: DataExpert.io Academy

## About this lesson

In this video, Yared walks viewers through various data transformation techniques using SQL, focusing on data profiling, cleaning, and complex transformations. He highlights the importance of understanding data distribution and how to handle JSON data effectively. He also discusses the creation of silver tables and the significance of defining schemas for efficient data processing.

## Navigation

- Previous lesson: [Delta Table Day 2 Lecture](https://www.dataexpert.io/lesson/delta-table-day-2-lecture-may2025-p736-l1130.md)
- Next lesson: [Data Lakes with Delta Table Day1 Lecture](https://www.dataexpert.io/lesson/datalakeswithdeltatableday1lecture-feb26-p736-l2021.md)