# Advanced SQL Patterns Day 2 Lab

> Master advanced SQL techniques with a focus on grouping sets, window functions, and the qualify keyword in this lab session. Participants will learn how to effectively manage data cardinality, create OLAP cubes, and utilize window functions to analyze user sessions and event timestamps. This lesson…

- Web page: https://www.dataexpert.io/lesson/advanced-sql-patterns-day-2-lab-jan2025
- Program: [2025 New Year  Data Engineering Boot Camp starting January 6th](https://www.dataexpert.io/program/2025-new-year-data-engineering-boot-camp-starting-january-6th)
- Access: Requires enrollment in 2025 New Year  Data Engineering Boot Camp starting January 6th
- Length: 47 min video
- Skills: SQL, Data Modeling, Snowflake
- Academy: DataExpert.io Academy

## About this lesson

Master advanced SQL techniques with a focus on grouping sets, window functions, and the qualify keyword in this lab session. Participants will learn how to effectively manage data cardinality, create OLAP cubes, and utilize window functions to analyze user sessions and event timestamps. This lesson is ideal for data engineers and analysts looking to enhance their SQL skills for real-world applications, particularly in environments like Snowflake and Starburst.

## Navigation

- Previous lesson: [Advanced SQL Patterns Day 2 Lecture](https://www.dataexpert.io/lesson/advanced-sql-patterns-day-2-lecture-jan2025.md)
- Next lesson: [Analytical Patterns Recognizing Business Value Day 3 Lecture](https://www.dataexpert.io/lesson/analytical-patterns-recognizing-business-value-day-3-lecture-jan2025.md)