Week 8 - Advanced SQL 2

Learning Objectives

After today's class, you should be able to:

Understand how to identify and apply window functions to perform calculations across related rows, and how to adjust the window frame parameters to control which rows are included in each calculation.
Understand the architecture and performance of database systems, including core components (query processor, storage and transaction managers, logs) and how execution plans are used to analyze and optimize query performance.
Gain hands-on experience with subqueries, CTEs, and window functions with a real database.