CS186

CS 186 at UC Berkeley | Spring 2020

Introduction to Database Systems

Professor Josh Hug

hug@cs.berkeley.edu

Office Hours: TBD

Professor Michael Ball

ball@berkeley.edu

Office Hours: M 5-6, W 3-4 625 Soda

Week 0 Overview

Introductions

Tuesday, January 21 - Monday, January 27

Week 1 Overview

SQL

Tuesday, January 21 - Monday, January 27

Week 2 Overview

Disks, Buffers, Files

Tuesday, January 28 - Monday, February 3

Week 3 Overview

B+ Trees & Indices

Tuesday, February 4 - Monday, February 10

Week 4 Overview

Buffer Management & Relational Algebra

Tuesday, February 11 - Monday, February 17

Week 5 Overview

Sorting & Hashing

Tuesday, February 18 - Monday, February 24

Week 6 Overview

Iterators & Joins

Tuesday, February 25 - Friday, February 28

Week 7 Overview

Query Optimization

Tuesday, March 3 - Monday, March 9

Week 8 Overview

Parallel Query Processing

Tuesday, March 10 - Monday, March 16

Week 9 Overview

Transactions & Concurrency

Tuesday, March 17 - Friday, March 20

Week 10 Overview

Database Design

Tuesday, March 31 - Monday, April 6

Notes

In addition to the textbook, the staff will publish a set of lecture notes that serve as supplements to the edX lectures. Make sure you revisit the notes after lecture. Each note may be covered in one or more lectures. See Syllabus for more information.

Expand

Discussions

In-person discussion sections are an optional and highly recommended component of this course, and you may attend whichever section(s) you like. In discussion, you'll learn more in depth about the previous week's content and you'll have the opportunity to ask your TA relevant conceptual questions. Here is a list of all the discussion sections for the course.

Expand

Projects

Throughout the semester, we will release 5 programming assignments via Piazza, each worth 7% of your grade. They are designed to cover distinct parts of the course and are done in SQL (Project 1) and Java (Project 2 - 5). See Syllabus for more information.

Expand

Lecture Slides

Slides generally follow the notes. Lecture videos are provided via edX. See Syllabus for more information.

Expand

Guerrilla Section

Worksheets and their corresponding solutions from guerrilla sections are posted here. Guerrilla sections are optional and are encouraged as a way to ensure you're keeping up with the material.

Expand