# Applying Advanced SQL for Analytical Insights - Recursive CTEs, Window Functions, and Practical Insights (Day 2 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/analytical-patterns-day-2-lecture-v3
- Program: [Data Engineering Boot Camp V2 Combined Track](https://www.dataexpert.io/program/data-engineering-boot-camp-v2-combined-track)
- Module: Week 3: Analytical Patterns & Analysis in Iceberg
- Access: Requires enrollment in Data Engineering Boot Camp V2 Combined Track
- Length: 46 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. [Recorded on Nov 29, 2023]

## Navigation

- Previous lesson: [Applying Advanced SQL for Analytical Insights - Aggregations and Cardinality Reduction in Bootcamp Web Events (Day 2 Lab)](https://www.dataexpert.io/lesson/analytical-patterns-day-2-lab-v3.md)
- Next lesson: [Apache Flink Streaming - Setting Up Streaming Pipelines with Kafka Integration (Day 1 Lab) ](https://www.dataexpert.io/lesson/infra-flink-streaming-day-1-lab-v3.md)