UC Berkeley · CS 186

Introduction to Database Systems

数据库系统导论

Relational databases, SQL, storage, indexing, query processing, transactions, recovery, parallelism, and distributed data systems.

Subject：Databases

Level：Advanced Undergraduate

Suggested stage：Years 3–4 (inferred)

Public-material edition：2026

Language：English

Videos：Not verified

Assignments / solutions：Available / Available

Prerequisites

Not explicitly listed by the official source; no assumption made.

Start here

All official course content

Lectures, video, assignments and exams are separated so you do not have to hunt through the course homepage.

35 direct tasks

▶Lectures, video & readingCourse content in the official sequence15

Topic 1: SQL Topic 2: Disks and Files Topic 3: Buffer Management Topic 4: B+ Trees Topic 5: Hashing Topic 6: External Sorting Topic 7: Join Algorithms Topic 8: Query Optimization Topic 9: Transactions Topic 10: Concurrency Control Topic 11: Recovery Topic 12: Distributed Databases Topic 13: Parallel Query Processing Topic 14: Database Design Topic 15: NoSQL Systems

✓Assignments & practiceOpen the matching problem or assignment page15

◆Labs & projectsCourse projects, labs and milestones5

Project 0: SQL Project 1: B+ Tree Project 2: Joins Project 3: Concurrency Project 4: Recovery

Official resource hubs

Use these to browse a complete resource collection; the section above links directly to individual study items.

Course resources and past examsUC Berkeley EECS ↗

Open database systems notesUC Berkeley EECS ↗

Source and verification

Every link points to an official university or course-team page. The year identifies the linked public-material edition, not necessarily the latest on-campus offering; a school may have newer materials that are not public. Unknown facts remain unverified rather than guessed.

UC Berkeley EECS · verified 2026-07-31

Open official course ↗Report a resource issue