/CS186

Learning materials for UCB CS186: Introduction to Database System

Primary LanguagePython

CS186 : Introduction to Database Systems

This repo contains all the learning materials for Berkeley's Database course CS186.

Course Resources

General

Course website: I used the 2021 spring version.

Recorded videos: I watched the recorded videos on Youtube, you can also find the same videos on bilibili.

Vitamin: Vitamins are short, weekly assignments to keep you on schedule and check your understanding of the basics from lecture. However these assignments are not open to the public, you can find them on the Edx's archived CS186W. You can also download the ppt and watch course videos on Edx.

PPT: I downloaded them from Edx.

Notes: These notes serve as a great explanation and conclusion of the course contents. I read the 2021 spring version.

Discussion: Enhance your understanding of the course contents.

Exam-preparation: Review the course contents and practice on some exam-like problems.

Projects

There are six projects in total. There is a gitbook for CS186 projects, but it may be updated each semester. I cloned the 2021 spring version, you can find the projects handout that I used here.

  • Project 1: SQL
    • You will learn to write SQL queries in this project.
    • My implementation is in this repo.
  • Project 2 - 4 : Implement a simple relational database —— rookiedb
    • My implementation is in this repo.
    • project 2: B+ tree
    • project 3: joins and query optimization
    • project 4: concurrency
    • project 5: recovery
  • Project 6: NoSQL
    • You will learn to write mongodb queries in this project.
    • My implementation is in this repo.

Want to learn more ?

Check out this repository which contains all my self-learning materials : )