Skip to content

Latest commit

 

History

History
22 lines (15 loc) · 1 KB

SQL-Part-4.md

File metadata and controls

22 lines (15 loc) · 1 KB
Raw

SQL Part 4

In the prep work for this class, the students learned:

  1. What subqueries are and how they are structured.
  2. Differences between correlated and non-correlated subqueries.
  3. Differences between subqueries and nested-subqueries.
  4. Differences between UNION, INTERSECT, and EXCEPT.

Announcements

  1. Always check with your program manager to see if there are any upcoming deadlines you should highlight!

Large Group Time (Instructor)

Topics That Require Careful Attention

  1. Q & A from the prep work and/or exercises.
  2. Learners may struggle to understand the differences between correlated and non-correlated or self-contained subqueries. This may require additional attention during lecture!
  • It may be useful to include more examples or use cases for both

Studio (IA Notes)

  1. Students will be working with the BooksDB dataset from previous lessons. They should already have access to this but ensure they have the necessary permissions to perform queries against the database!