Learning Objectives

  • Compare and contrast the following types of joins:
    • cross
    • inner
    • left / right
    • outer
  • Use SQL’s JOIN clause to perform the aforementioned types of joins

How to Complete this Lesson

Complete the following learning activities: (1.75–2 hours total)

  1. Complete Execution Hiatuses from Select Star SQL (45–60 minutes)
  2. Attend the class meeting (60 minutes)
  3. Complete the practice queries
« SQL Aggregates SQL Subqueries »