Databases

Next running

Not currently scheduled for a next session. Please email us to express your interest.

Most software engineers use database systems, but few understand them. It is not surprising, then, that database related issues are a common cause of application failure, and that misuse of databases frequently impedes engineering team productivity.

Our course aims to provide practicing software engineers with a firm understanding of the architectures of database systems and the trade-offs that they make. We hope this will help our students make better choices when deciding between database systems and their features, to better utilize their chosen technologies and to more effectively debug any issues.

Projects and exercises

This course involves a significant practical component: implementing a simplified relational database management system from scratch. Most classes will cover some amount of theory, which you will then directly apply to your own DBMS implementation. In addition, the optimization portion of the curriculum involves anticipating, reasoning about and optimizing query plans for a handful of given queries, in what is one of our most popular and illuminating exercise.

Assumed knowledge

This course assumes confident programming abilities, and some familiarity with computer architecture. Working familiarity with at least one relational database management system is also highly advised.