27 Jul - 3 Sep
5:00pm-6:30pm PT Mon/Thu
$1800Apply for this course
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.
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.
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.
This course will next be taught by
Elliott is an instructor and course developer at Bradfield. Previously he was a tech lead at Triplebyte, where he designed assessments for hiring software engineers, and a senior engineer at Dropbox, where he built a distributed search engine. In addition, he has experience as a mentor for the Google Summer of Code and a tutor at Stanford's Center for Teaching and Learning.