Mar 03: SQL Joins and the TPCH database

Learning Objectives

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

• Read and write queries that include inner, outer, and self joins.
• Summarize tables and relationships in the tpch database.

Lesson Outline

• Lecture Slides [20 min]

  • SQL Joins and HAVING

• Group Activities

• [30 min] Queries on the TPC-H Database

• [25 min] HW4 Work with your group

Your To-Do List

• HW4 due Thursday