24. Databases

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