# Applying Advanced SQL for Analytical Insights - Window Functions, GROUPING SETS, CUBE, ROLLUP, and Funnel Analytics (Day 2 Lab) 

> In this lab, we covered window functions, compared GROUPING SETS vs. CUBE vs. ROLLUP, and explored Funnel Analytics queries, gaining hands-on experience in applying advanced SQL techniques for data analysis.

- Web page: https://julie.techexpert.io/lesson/analytical-patterns-day-2-lab-v2
- Program: [Data Engineering Boot Camp V2 Combined Track](https://julie.techexpert.io/program/data-engineering-boot-camp-v2-combined-track)
- Module: Week 3: Analytical Patterns & Analysis in Postgres (v2)
- Access: Requires enrollment in Data Engineering Boot Camp V2 Combined Track
- Length: 53 min video
- Skills: SQL
- Academy: Julies academy to catch all other programs

## About this lesson

In this lab, we covered window functions, compared GROUPING SETS vs. CUBE vs. ROLLUP, and explored Funnel Analytics queries, gaining hands-on experience in applying advanced SQL techniques for data analysis.

## Navigation

- Previous lesson: [Data Impact Communication & Visualization - Exploring Data Aggregation and Visualization Techniques (Day 2 Lab)](https://julie.techexpert.io/lesson/visual-impact-day-2-lab-v3.md)
- Next lesson: [Data Pipeline Maintenance - Simulated Scenarios and Runbook Creation for Effective On-Call Procedures (Day 1 Lab) ](https://julie.techexpert.io/lesson/pipeline-maintenance-day-1-lab-v2.md)