# Office Hour 2

> Office Hour 2 provides an interactive session focused on addressing homework-related queries and clarifying concepts in data engineering. Participants discuss SQL techniques, including handling duplicates, using window functions, and constructing slowly changing dimensions (SCD) for actor data. The…

- Web page: https://www.dataexpert.io/lesson/office-hour-2
- Program: [Analytics Engineering Boot Camp starting October 2024](https://www.dataexpert.io/program/analytics-engineering-boot-camp)
- Module: TA Office Hours
- Access: Requires enrollment in Analytics Engineering Boot Camp starting October 2024
- Length: 1 h 55 min video
- Skills: SQL, LLMs
- Academy: DataExpert.io Academy

## About this lesson

Office Hour 2 provides an interactive session focused on addressing homework-related queries and clarifying concepts in data engineering. Participants discuss SQL techniques, including handling duplicates, using window functions, and constructing slowly changing dimensions (SCD) for actor data. The session also covers practical insights on using Airflow for data pipelines, including task dependencies and partitioning strategies. This is beneficial for learners seeking to enhance their understanding of SQL and data engineering workflows.

## Navigation

- Previous lesson: [Office Hour 1](https://www.dataexpert.io/lesson/office-hour-1.md)
- Next lesson: [Office Hour 3](https://www.dataexpert.io/lesson/office-hour-3.md)