# 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
- Program: [Spring Data Engineering Boot Camp Starting May 26th, 2025](https://www.dataexpert.io/program/spring-data-engineering-boot-camp-starting-march-10th-6262)
- Access: Requires enrollment in Spring Data Engineering Boot Camp Starting May 26th, 2025
- 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.md)
- Next lesson: [Apache Spark Shuffle Joins Day 1 Lecture](https://www.dataexpert.io/lesson/apache-spark-shuffle-joins-day-1-lecture-may2025.md)