week7.md

Week 7: Object-Oriented Design in Ruby

• Fetch Changes
• Install SQLite
• Peer Pair 1
• Peer Pair 1 Feedback
• Peer Pair 2
• Peer Pair 2 Feedback
• Meta Feedback 7+ Times
• Submit Work

Challenge 1. SQLZoo for SQL Queries

• Release 0: Go to SQLzoo
• Release 1: OPTIONAL: Create an account
• Release 2: Complete the following sections...
• Release 3: Save your Quiz Results
• Release 4: Reflect in the reflection section of your my_quizzes.md file.

Challenge 2. Designing Schemas

• Release 0: Student Roster Schema
• Release 1: One to Many Schema
• Release 2: One to One Schema
• Release 3: Many to Many Schema
• Release 4: Design Your Own Schemas!
• Release 5: Reflect
• Release 6: Review

Challenge 3. Modeling a One to Many Database - SOLO CHALLENGE

• Release 0: User Fields
• Release 1: Tweet Fields
• Release 2: Explain the Relationship
• Release 3: Make the Schema
• Release 4: Create SQL Statements that would access your tables and return:
• Release 5: Reflect

Challenge 4. Intro to SQLite

• Release 0: Create a dummy database
• Release 1: Insert Data
• Release 2: Multi-line commands
• Release 3: Add a column
• Release 4: Change a value
• Release 5: Reflect

Challenge 5. Technical Blog

• Release 0: Copy Your Blog Template
• Release 1: Research
• Release 2: Blog!
• Release 3: Publish

Challenge 6. Cultural Blog

• Release 0: Copy your Blog Template
• Release 1: Exploring your values
• Release 2: Select a value
• Release 3: Values in your Life
• Release 4: Advice
• Release 5: Values and Stereotype threat
• Release 6: Publish
• Release 7: Promote

Challenge 7. GPS 3.1 DO NOT LOOK UNTIL YOUR GUIDED PAIRING SESSION!

• Release 0: User Stories
• Release 1: Pseudocode
• Release 2: Write Driver Code
• Release 3: Initial Solution
• Release 4: Refactor your solution
• Release 5: Reflect
• Release 6: Push your changes to Github!
• Release 6: Submit Feedback.

Challenge 8. BONUS: Using the SQLite Gem

• Release 0: Open the Database
• Release 1: Poke around the Database
• Release 2: Run Existing Code
• Release 3: Try Again
• Release 4: Implement the missing functionality
• Release 5: Done already?
• Release 6: Reflect in the reflection section of your my_solution.md file.