Resources
Exam Resources
| Semester | Midterm 1 | Midterm 2 | Final |
|---|---|---|---|
| Fall 2022 | Exam (Solutions) | Exam (Solutions) | Exam (Solutions) |
| Spring 2022 | Quiz (Solutions) | Exam (Solutions) | Exam (Solutions) |
| Fall 2021 | Exam (Solutions) | Exam (Solutions) (Video) | Exam (Solutions) |
| Spring 2021 | Exam (Solutions) | Exam (Solutions) (Video) | Exam (Solutions) (Video) |
| Fall 2020 | Exam (Solutions) (Video) | Exam (Solutions) (Video) | Exam (Solutions) (Video) |
| Spring 2020 | Exam (Solutions) (Video) | Exam (Solutions) (Video) | Exam (Solutions) (Video) |
| Fall 2019 | Exam (Solutions) | Exam (Solutions) | Exam (Solutions) |
| Spring 2019 | Exam (Solutions) | Exam (Solutions) | Exam (Solutions) |
| Fall 2018 | Exam (Solutions) | Exam (Solutions) | Exam (Solutions) |
| Spring 2018 | Exam (Solutions) | Exam (Solutions) | Exam (Solutions) |
| Fall 2017 | Exam (Solutions) | Exam (Solutions) | Exam (Solutions) |
For older exams, check out the HKN and TBP past exam archives.
Public Drive
We will be posting all lecture materials and notes on the course syllabus. You can also find many of these resources, along with other resources not found on the syllabus, in the following publicly visible Google Drive. Here, you can find guerrilla section materials, TA-specific discussion slides, review section materials, past exam materials, and more.
Textbook
There is no required textbook for this class, and we will not be assigning required readings. However, if you would like to use a textbook while in this class, we recommend the following:
-
Database Management Systems, 3rd Edition, by Ramakrishnan and Gehrke (Former official textbook of this class)
-
Database Systems Concepts, 6th Edition, by Silberschatz, Korth and Sudarshan
-
Database Systems: The Complete Book, 2nd Edition, by Garcia-Molina, Ullman, and Widom (Previously used by Prof. Cheung)
Note that exams and all other aspects of the course will center on material as covered in the lectures, so defer to course material if there are any discrepancies with the textbook(s) you are using.
If you want to try to target your reading to the topics of this class, reading assignments from previous offerings of CS 186 for the Database Management Systems textbook can be found here. Reading assignments from a database class taught at a different university by Prof. Cheung for Database Systems: The Complete Book can be found here, although the topics taught in that class differ from those taught in this class.
Old Lecture Videos
In Fall 2018, this course was changed to have online, pre-recorded lectures, with everything else in-person. Most of these videos are also being used this semester. You can find the videos used for these web-based semesters on this channel, and the videos are organized into playlists based on their topic. However, we will be generating our own playlists of lecture videos, which will replace some of the original videos from this channel with newly recorded ones, so use the playlists we provide this semester whenever possible. If you find any discrepancies between the material in this semester’s videos and the material in the old videos, defer to this semester’s version.
Past Websites
- Spring 2022
- Fall 2021
- Spring 2021
- Fall 2020
- Spring 2020
- Fall 2019
- Spring 2019
- Fall 2018
- Spring 2018
- Fall 2017
For older websites, check out the semester archives.