SQL Joins
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
- Read Fundamentals of Database Management Systems Chapter 4: Relational Data Retrieval: SQL (60 minutes)
- Complete Execution Hiatuses from Select Star SQL
- Attend the class meeting
- Complete the practice queries