Apr 02: Window Functions and Views

Learning Objectives

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

• Use window functions in analytical queries
• Understand the purpose and use of database views

Lesson Outline

• [20 min] Window Functions
• [15 min] Review Queries on the "air" database
• [20 min] Views
• [20 min] Introduce homework 6

Your To-Do List

• Read Section 1.8 in the book
• HW6