Week 5 Optimizing

Indexes. CREATE INDEX. EXPLAIN QUERY PLAN. Covering Indexes. B-Trees. Partial Indexes. VACUUM. Concurrency. Transactions. ACID: Atomicity, Consistency, Isolation, Durability. BEGIN TRANSACTION. COMMIT. ROLLBACK. Race Conditions. Locks.

• Lecture
  • Notes
  • Slides
    • Keynote
    • PDF
  • Source Code
    • Index
    • PDF
    • Zip
  • Video
    • CS50 Video Player
    • YouTube
• Check for Understanding 5
• Problem Set 5
• Final Project