24. Databases

• 24.1. What are Databases?
  • 24.1.1. Adding a Database
  • 24.1.2. Communicating With a Database
  • 24.1.3. Check Your Understanding
• 24.2. Database Structure
  • 24.2.1. Relationships Between Tables
• 24.3. Database Operations
  • 24.3.1. CRUD
  • 24.3.2. Create
    • 24.3.2.1. Adding a Table
    • 24.3.2.2. Adding a Row
    • 24.3.2.3. Adding a Column
  • 24.3.3. Read
  • 24.3.4. Update
  • 24.3.5. Delete
  • 24.3.6. Check Your Understanding
• 24.4. SQLite
  • 24.4.1. Setup
  • 24.4.2. Create a Database
  • 24.4.3. Add a New Table
  • 24.4.4. Table Creation Error
• 24.5. Database Practice
  • 24.5.1. Add New Entries
    • 24.5.1.1. Viewing a Table in VS Code
  • 24.5.2. Retrieve Data From Table
  • 24.5.3. Check Your Understanding
• 24.6. More Database Practice
  • 24.6.1. Update Table Data
  • 24.6.2. Delete Data
  • 24.6.3. Check Your Understanding
• 24.7. Database Tips
  • 24.7.1. Close the Connection
  • 24.7.2. Don’t Track the Database with Version Control
  • 24.7.3. Add a Primary Key
    • 24.7.3.1. Try It! (Primary Keys)
    • 24.7.3.2. Try More!
  • 24.7.4. Check Your Understanding
• 24.8. Linking Database Tables
• 24.9. Exercises: Databases
  • 24.9.1. Part A: Set Up a New Database
  • 24.9.2. Part B: Add a Table
  • 24.9.3. Part C: Add Rows
  • 24.9.4. Part R: Access Game Data
  • 24.9.5. Part U: Modify Game Data
  • 24.9.6. Part D: Remove Games
  • 24.9.7. Bonus Exercises
• 24.10. Project: Movie SQLs
  • 24.10.1. Project Setup
    • 24.10.1.1. Create the Database
  • 24.10.2. The Home Page (index.html)
  • 24.10.3. The DELETE Form
  • 24.10.4. The UPDATE Form
  • 24.10.5. The INSERT and SELECT Forms
  • 24.10.6. Next Steps
• 24.11. Project: Movie SQLs (Part 2)
  • 24.11.1. Define the execute_query Function
    • 24.11.1.1. Don’t Expect Perfect Syntax
  • 24.11.2. Catch SQL Syntax Errors
    • 24.11.2.1. Run Test Cases
  • 24.11.3. Display Column Names
  • 24.11.4. Gloat
  • 24.11.5. Bonus