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

  1. Read Fundamentals of Database Management Systems Chapter 4: Relational Data Retrieval: SQL (60 minutes)
  2. Complete Execution Hiatuses from Select Star SQL
  3. Attend the class meeting
  4. Complete the practice queries