SQL Subqueries
Learning Objectives
- Use subqueries as an alternative to joins
How to Complete this Lesson
Complete the following learning activities: (3–3.75 hours total)
- Complete Closing Remarks and Challenge Questions from Select Star SQL (15–30 minutes)
- Attend the class meeting (60 minutes)
- Complete the practice queries
- Take the quiz (10 minutes)
- Work on the SQL programming exercise (PEX)
(90–120 minutes)
- Work on queries 21–25 (LargeCo database)
Due
As a reminder, the following is due this lesson:
Resources
- Questions for the Structured Query Language (SQL) (45–90 minutes)