Data
How databases work
Storage, indexes, query plans, transactions and recovery.
About 40 hours of study.
Where to learn it
Read
Architecture of a Database System
Hellerstein, Stonebraker, Hamilton
The whole paper
How a real database is put together, by people who built them.
Section not checked yet
Watch
Database Systems (CMU 15-445/645)
Andy Pavlo
The full lecture series
Lecture videos are on the CMU Database Group YouTube channel.
Section not checked yet
Practise
BusTub
CMU Database Group
The course projects: buffer pool, B+ tree index, query execution
The teaching database behind CMU 15-445’s projects.
Section not checked yet
Other options
- Data Base Management System (NPTEL) (watch)
The full course
Wrong chapter, dead link, or know something better? Tell us on GitHub.
Which roles ask for it
- Software engineer (SDE) good to have
- Backend engineer in the first year
- Data engineer in the first year
- Database administrator to get hired
- GATE computer science to get hired
- GATE data science and AI to get hired
- UGC NET computer science to get hired
Before and after
How databases work
Opens up
Nothing else on the map yet.