6.5830/6.5831: Database Systems
Spring 2026

6.5830/6.5831 lectures are held on Tuesdays and Thursdays.

Monday Tuesday Wednesday Thursday Friday
Feb 2
First Day of Classes
Feb 3
Lec 1: Intro, Relational Model, SQL 1
Assigned: Lab 1, PS 1
Feb 4
Feb 5
Lec 2: SQL 2
Reading Assignment
Feb 6
Feb 9
Feb 10
Lec 3: Schema Design
Reading Assignment
Feb 11
Feb 12
Lec 4: Intro to DB Internals
Reading Assignment
Feb 13
Feb 16
Feb 17
Presidents' Day (Monday Schedule)
Feb 18
Feb 19
Lec 5: DB Operators and Query Processing
Reading Assignment

Assigned: Lab 2, PS 2
Due: PS 1
Feb 20
Feb 23
Feb 24
Lec 6: Indexing and Access Methods
Reading Assignment
Feb 25
Feb 26
Lec 7: Join Algorithms
Reading Assignment

Due: Lab 1, Project teams (if doing final project)
Feb 27
Mar 2
Mar 3
Lec 8: Query Optimization
Reading Assignment
Mar 4
Mar 5
Lec 9: Database Layout for Analytic DBs
Reading Assignment

Lab 1 write-up in-class
Mar 6
Mar 9
Mar 10
Lec 10: Column Stores ctd
Due: PS 2, Project proposals (if doing a final project)
Mar 11
Mar 12
Quiz 1
Mar 13
Mar 16
Mar 17
Lec 11: Transactions and Locking
Reading Assignment

Assigned: Lab 3, Lab 4
Other: Project meetings
Mar 18
Mar 19
Lec 12: Recovery
Reading Assignment

Due: Lab 2
Other: Project meetings
Mar 20
Mar 23
Spring Break
Mar 24
Spring Break
Mar 25
Spring Break
Mar 26
Spring Break
Mar 27
Spring Break
Mar 30
Mar 31
Lec 13: Recovery 2
Reading Assignment

Lab 2 write-up in-class
Apr 1
Apr 2
Lec 14: Optimistic Concurrency Control, Snapshot Isolation
Reading Assignment
Apr 3
Apr 6
Apr 7
Lec 15: Distributed Databases
Reading Assignment

Assigned: PS 3
Apr 8
Apr 9
Lec 16: Distributed Transactions
Reading Assignment
Apr 10
Apr 13
Apr 14
Lec 17: Advanced Cardinality Estimation/Sketches
Other: Project meetings, Midterm reports
Apr 15
Apr 16
Lec 18: Eventual Consistency
Reading Assignment

Due: Lab 3
Apr 17
Apr 20
Apr 21
Lec 19: Cluster Computing (Spark)
Reading Assignment

DROP DATE
Apr 22
Apr 23
Quiz 2
Lab 3 write-up in-class
Apr 24
Apr 27
Apr 28
Lec 20: Cloud DB (Aurora + Snowflake)
Reading Assignment

Due: PS 3
Apr 29
Apr 30
Lec 21: Vector DB
Reading Assignment
May 1
May 4
May 5
Lec 22: Semantic Operators
May 6
May 7
Lec 23: Final Project Presentations
Due: Project Report + Video submission
May 8
May 11
May 12
Lec 24: Final Project Presentations
Last Day of Classes
Due: Lab 4 (6.5831 only)
Lab 4 write-up in-class for 6.5831 students
May 13
May 14
May 15
Last change: January 15 2026.

Questions or comments regarding 6.5830/6.5831? Send e-mail to the 6.5830/6.5831 staff at . Accessibility