// the find
PKUFlyingPig/CS186
Learning materials for UCB CS186: Introduction to Database System
A personal archive of offline materials for Berkeley's CS186 database course — lecture slides, notes, discussion sections, exam prep PDFs, and project handouts from the Spring 2021 run. It's a study companion for someone following along with the public course videos, not a standalone tutorial. No code, no interactivity.
The note PDFs cover the full database internals curriculum in one place: B+ trees, buffer management, join algorithms, query optimization, concurrency control, and recovery — topics where quality explanations are genuinely hard to find outside a university. The exam-prep worksheets with solutions are useful for anyone who learns by working problems, not just reading. Project handouts for RookieDB (implementing a real database from scratch in Java) are included and the projects themselves cover B+ trees, joins, query optimization, concurrency, and recovery — a rare chance to implement the full storage layer.
This is a static PDF dump last touched in late 2021 — the Berkeley course has run several more semesters since and the materials have been updated, so you're getting a snapshot that may lag the current curriculum. The actual project starter code lives in separate repos linked externally, so this archive isn't self-contained. Vitamins (weekly quizzes) aren't included because they're behind an EdX login wall, which leaves a gap in the practice material. With 396 stars and no activity in four years, there's no community around it — if you hit a confusing point in a PDF, you're on your own.