# Applying Advanced SQL for Analytical Insights - Aggregations and Cardinality Reduction in Bootcamp Web Events (Day 2 Lab)

> In this lab session, Zach demonstrates various queries and aggregations that can be applied to the bootcamp web events table. The talk emphasizes the significance of reducing cardinality and showcases the use of functions like coalesce and rollup. Zach also touches on the concept of self-joins and…

- Web page: https://www.dataexpert.io/lesson/analytical-patterns-day-2-lab-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: 1 h video
- Skills: SQL
- Academy: DataExpert.io Academy

## About this lesson

In this lab session, Zach demonstrates various queries and aggregations that can be applied to the bootcamp web events table. The talk emphasizes the significance of reducing cardinality and showcases the use of functions like coalesce and rollup. Zach also touches on the concept of self-joins and how they can aid in analyzing a users journey on the website. [Recorded on Nov 29, 2023]

## Navigation

- Previous lesson: [Applying Advanced SQL for Analytical Insights - Exploring SQL, Scaling Projects, and Aggregation Analysis (Day 1 Lecture)](https://www.dataexpert.io/lesson/analytical-patterns-day-1-lecture-v3.md)
- Next lesson: [Applying Advanced SQL for Analytical Insights - Recursive CTEs, Window Functions, and Practical Insights (Day 2 Lecture)](https://www.dataexpert.io/lesson/analytical-patterns-day-2-lecture-v3.md)