Oct 01: Inner, Outer, Self Joins

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

HW3 [5 min]

• HW3 solution posted in Canvas
• Still being graded; observations

GP2 Peer evaluation [10 min]

• GP2 – see example in profs repo
• One team member should paste the link to your dbdiagram model into the Canvas Survey.
  • Click the Share button and "Copy Link" as shown below:
    
• We will post everyone's link and updated proposal. Your team will be assigned another team to review.
• Complete the GP2 Peer Review Form twice – for the team you are reviewing, and for your own team.

Lecture Slides [30 min]

• SQL Queries: Joins

Group Activity [30 min]

• Queries on the tpch database

Your To-Do List

• Read zyBook sections 5.3 – 5.7 (ideally before Thursday)
• Complete GP2 peer review process – due Thursday in class
• Start working on HW4 (due Monday)