Bootcamp
Search…
Bootcamp
Welcome to Bootcamp!
🛠
Logistics
📚
General Reference
🏞
Projects
0: Language and Tooling
1: Frontend Basics
🌈
CSS
2: Backend Basics
3: Backend Applications
3.0: Module 3 Overview
3.1: Express.js
3.2: EJS
3.3: SQL Language
3.4: SQL Applications
3.5: Authentication
3.6: Heroku
3.ICE: In-Class Exercises
3.ICE.1: Bigfoot
3.ICE.2: Bigfoot EJS
3.ICE.3: Bigfoot POST
3.ICE.4: Cookies
3.ICE.5: One to Many
3.ICE.6: Inner Join
3.ICE.7: Many to Many
3.ICE.8: Multiple Foreign Keys
3.ICE.9: DB Schema Design - Carousell
3.ICE.10: Bird Watching Redux
3.ICE.11: DB Schema Design - Uber
3.ICE.12: DB Schema Design - Instagram
3.ICE.13: DB Schema Design - Airbnb
3.POCE: Post-Class Exercises
4: Backend Structure
5: Full-Stack Applications
6: Frontend Infrastructure
7: React
8: Advanced React
9: Advanced Topics
🧮
Algorithms
💼
Interview Prep
☺
User Experience
Powered By GitBook
3.ICE.6: Inner Join

Instructions

  1. 1.
    Create a new branch inner-join in the 3.ICE.5: One to Many repo for today's exercise, and work in the inner-join branch.
  2. 2.
    Refactor the Cat Owners command line app from 3.ICE.5: One to Many to use INNER JOIN instead of nested SQL queries.
  3. 3.
    Complete Comfortable and More Comfortable sections in 3.ICE.5: One to Many if you have not already.
Previous
3.ICE.5: One to Many
Next
3.ICE.7: Many to Many
Last modified 2mo ago
Copy link