Skip to content

Feb 22: JOINS, DISTINCT, psql

Learning Objectives

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

  • Summarize the difference between inner and outer joins.
  • Explain how NULL values work in joins and aggregations.
  • Use psql to run interactive commands and SQL scripts.

Lesson Outline

HW4 Debrief [5 min]

Lecture Slides [30 min]

Lab Activity [20 min]

HW5 Hints [20 min]

Before leaving today, make sure you can:

  • Write SQL for the first two queries on the homework
  • Run the script and compare the output using meld

Your To-Do List

  • Finish reading zyBook sections 3.13.4
  • Finish working on Homework 5 (due Monday)