# Grouping sets and Window functions Lecture

> In this presentation, Zach explores a range of topics related to Advanced SQL Analytical Patterns. The discussion covers the application of recursive CTEs, count case when, grouping sets, cross join unnest, cube, rollup, and window functions. Drawing from Zachs experience in conducting interviews a…

- Web page: https://www.dataexpert.io/lesson/grouping-sets-and-window-functions-lecture
- Program: [Analytics Engineering Boot Camp starting October 2024](https://www.dataexpert.io/program/analytics-engineering-boot-camp)
- Module: Applying Analytical Patterns
- Access: Requires enrollment in Analytics Engineering Boot Camp starting October 2024
- Length: 30 min video
- Skills: SQL
- Academy: DataExpert.io Academy

## About this lesson

In this presentation, Zach explores a range of topics related to Advanced SQL Analytical Patterns. The discussion covers the application of recursive CTEs, count case when, grouping sets, cross join unnest, cube, rollup, and window functions. Drawing from Zachs experience in conducting interviews and working with these concepts, the presentation offers insights and practical advice.

## Navigation

- Previous lesson: [Growth Accounting Models Lab](https://www.dataexpert.io/lesson/growth-accounting-models-lab.md)
- Next lesson: [Grouping sets and Window functions Lab](https://www.dataexpert.io/lesson/grouping-sets-and-window-functions-lab.md)