SQL Set Operators

Learning Objectives

Describe SQL’s relational operators: UNION, INTERSECT, and EXCEPT

How to Complete this Lesson

Complete the following learning activities: (3.25–4 hours total)

Attend the class meeting (60 minutes)
Complete the SQL Murder Mystery (45–60 minutes)
- Note: Using the schema diagram makes writing the queries much easier
Complete the SQL programming exercise (PEX) (90–120 minutes)
- Complete queries 21–25 (LargeCo database)

Resources

Questions for the Structured Query Language (SQL) (45–90 minutes)