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]

• Pronounced "post-gres-Q-L"
  • See https://www.postgresql.org/about/
• PostgreSQL vs MySQL (Integrate.io blog)
  • For Example: Data Types
  • However: DB-Engines Ranking

Lecture Slides [25 min]

• SQL Queries: Aggregation

Lab Activity [35 min]

• pgAdmin – PostgreSQL Tools
• Discuss solutions as a class

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.1 – 3.4
• Start working on Homework 5 (due Monday)
  • To be completed individually this time