Week 2 Data at Scale

To open shows.db (or movies.db) in DB Browser for SQLite after unzipping it, select via File > Open Database…. Do not try to double-click the file itself.

  1. Introduction
  2. Database
  3. Raw Data
  4. Flat-File Database
  5. Introduction to DB Browser for SQLite
  6. CRUD
  7. SELECT
  8. INSERT
  9. UPDATE
  10. DELETE
  11. CREATE
  12. IMDb
  13. IMDb, continued
  14. JOIN
  15. Index
  16. View
  17. SQL Injection Attacks
  18. Race Conditions
  19. Helpful Resources
  20. Assignment 2
  21. Survey