2

This course relies on primary readings from the database community to introduce graduate students to the foundations of database systems, focusing on basics such as the relational algebra and data model, schema normalization, query optimization, and transactions

FREE
This course includes
Hours of videos

555 years, 6 months

Units & Quizzes

20

Unlimited Lifetime access
Access on mobile app
Certificate of Completion

It is designed for students who have taken 6.033 (or equivalent); no prior database experience is assumed, though students who have taken an undergraduate course in databases are encouraged to attend.

Course Currilcum

  • Introduction (CC) Unlimited
  • The relational model (MS) Unlimited
  • Schema design (MS) Unlimited
  • Introduction to database internals (CC) Unlimited
  • Database operators and query processing (CC) Unlimited
  • Indexing and access methods (CC) Unlimited
  • Buffer pool design and memory management (CC) Unlimited
  • Join algorithms (CC) Unlimited
  • Query optimization (CC) Unlimited
  • Transactions and locking (MS) Unlimited
  • Optimistic concurrency control (MS) Unlimited
  • Recovery (MS) Unlimited
  • Recovery (MS) Unlimited
  • Degrees of consistency (MS) Unlimited
  • C-store Unlimited
  • Distributed transactions (CC) Unlimited
  • Parallel databases (CC) Unlimited
  • Scientific databases (MS) Unlimited
  • NOSQL (CC) Unlimited
  • ORM, DryadLINQ (CC) Unlimited