# Live SQL Training January 25th, Window Functions and Common Table Expressions

> In this video we cover window functions LAG and LEAD. We also cover common table expressions in depth comparing them to temp tables and subqueries!

- Web page: https://www.dataexpert.io/lesson/live-sql-training-jan-25-window-functions-common-table-expressions
- Program: [Data Engineer Interview Skills](https://www.dataexpert.io/program/data-engineering-boot-camp-v1)
- Module: Interview Skills
- Access: Requires enrollment in Data Engineer Interview Skills
- Academy: DataExpert.io Academy

## About this lesson

In this video we cover window functions LAG and LEAD. We also cover common table expressions in depth comparing them to temp tables and subqueries!

## Navigation

- Previous lesson: [The Behavioral Interview](https://www.dataexpert.io/lesson/the-behavioral-interview.md)
- Next lesson: [Live SQL Training January 15th](https://www.dataexpert.io/lesson/live-sql-training-jan-15.md)