Skip to content

Feb 20: GROUP BY, Aggregation

Learning Objectives

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

  • Explain GROUP BY and aggregation functions.
  • Use pgAdmin to query a relational database.

Lesson Outline

PostgreSQL [5 min]

Lecture Slides [25 min]

Lab Activity [35 min]

pgAdmin Tour [10 min]

  • Exploring what's in the menus
  • Clicking the tabs for an object
  • Demo of how to work on HW4

Your To-Do List

  • Start reading zyBook sections 3.13.4
  • Start working on Homework 5 (due Monday)
    • To be completed individually this time