CS186

CS 186 at UC Berkeley

Introduction to Database Systems

Professor Josh Hug

hug@cs.berkeley.edu

Office Hours: F 2-3, 4-5 Soda 779

Head GSI Lakshya Jain

lakshya.jain@berkeley.edu

Office Hours: W 2-3 Soda 341B, F 1-2 Soda 283H (Admin)

Week 0 Overview

Introductions

Week 1 Overview

SQL

Wednesday, August 28 - Monday, September 2

Week 2 Overview

Disks, Buffers, Files

Tuesday, September 3 - Monday, September 9

Week 3 Overview

B+ Trees & Indices

Tuesday, September 10 - Monday, September 16

Week 4 Overview

Buffer Management & Relational Algebra

Tuesday, September 17 - Monday, September 23

Week 5 Overview

Sorting & Hashing

Tuesday, September 24 - Monday, September 30

Week 6 Overview

Iterators & Joins

Tuesday, October 1 - Monday, October 7

Week 7 Overview

Query Optimization

Tuesday, October 8 - Monday, October 14

Week 8 Overview

Parallel Query Processing

Tuesday, October 15 - Monday, October 21

Week 9 Overview

Transactions & Concurrency

Tuesday, October 22 - Monday, October 28

Week 10 Overview

Database Design

Tuesday, October 29 - Monday, November 4

Week 11 Overview

Unstructured Data: Searching Text

Tuesday, November 5 - Monday, November 11

Week 12 Overview

Recovery & ARIES

Tuesday, November 12 - Monday, November 18

Week 13 Overview

Distributed Transactions

Tuesday, November 19 - Monday, November 25

Week 14 Overview

Conclusion

Tuesday, December 3 - Friday, December 6

Week 15 Overview

RRR Week

Monday, December 9 - Friday, December 13

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

Homeworks

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 (HW1) and Java (HW 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

Guerilla Section

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

Expand