2. SQL the Sequel

1. 2.1. Table Relationships
   1. 2.1.1. Relating Data
   2. 2.1.2. One-To-Many Relationships
   3. 2.1.3. Table Keys
      1. 2.1.3.1. Adding a Primary Key
      2. 2.1.3.2. Adding a Foreign Key
      3. 2.1.3.3. Keys Wrap-Up
   4. 2.1.4. Other Relationships
   5. 2.1.5. Check Your Understanding
2. 2.2. Database Management
   1. 2.2.1. Setup
      1. 2.2.1.1. writing_supply
      2. 2.2.1.2. pencil_drawer
      3. 2.2.1.3. pen_drawer
   2. 2.2.2. Import Data
   3. 2.2.3. Import Troubleshooting
   4. 2.2.4. Check Your Understanding
3. 2.3. Complex Queries
   1. 2.3.1. Review Joins
      1. 2.3.1.1. Inner Join
      2. 2.3.1.2. Left/Right Join
      3. 2.3.1.3. Multiple Joins
   2. 2.3.2. Subqueries
      1. 2.3.2.1. Where Else Can We Add Subqueries?
      2. 2.3.2.2. Last Reminders
   3. 2.3.3. Check Your Understanding
4. 2.4. Exercises: The SQL Sequel
   1. 2.4.1. Create a New Schema
   2. 2.4.2. Import New Tables
      1. 2.4.2.1. The plant Table
      2. 2.4.2.2. The seeds Table
      3. 2.4.2.3. The garden_bed Table
   3. 2.4.3. Try Out Some Joins!
      1. 2.4.3.1. Inner Join
      2. 2.4.3.2. Left Join
      3. 2.4.3.3. Right Join
      4. 2.4.3.4. Full Join
   4. 2.4.4. Sub-Queries and Complex Queries
   5. 2.4.5. Bonus Missions
5. 2.5. Studio: A Library
   1. 2.5.1. Database Setup
      1. 2.5.1.1. The book table
      2. 2.5.1.2. The author table
      3. 2.5.1.3. The patron table
      4. 2.5.1.4. The reference_books table
      5. 2.5.1.5. The genre table
      6. 2.5.1.6. The loan table
   2. 2.5.2. Warm-up Queries
   3. 2.5.3. Loan Out a Book
   4. 2.5.4. Check a Book Back In
   5. 2.5.5. Wrap-up Query
   6. 2.5.6. Bonus Mission