Introduction to Database Systems

UC Berkeley, Fall 2020

Alvin Cheung

Alvin Cheung

akcheung@cs.berkeley.edu

Pronouns: he/him/his

OH: Tuesday 11AM-12PM

Aditya Parameswaran

Aditya Parameswaran

adityagp@eecs.berkeley.edu

Pronouns: he/him/his

OH: Thursday 11AM-12PM

  • All announcements are on Piazza. Make sure you are enrolled and active there.
  • The Syllabus contains a detailed explanation of how each course component will work this fall, given that the course is being taught entirely online.
  • The scheduling of all weekly events is in the Calendar.
  • YouTube playlists for all class content can be found at the following:


Week Date Lecture Discussion Vitamin Project Resources
1 Th 8/27 1. Introduction + SQL I
Audio
Video
No Section Pre-Semester
Quiz
(due 9/4)
Vitamin 1 (due 9/6)
Project 0 (due 9/3)
Project 1 (due 9/10)
Note 0
2 Tu 9/1 2. SQL I (cont) + SQL II
Video
      Note 1
  Th 9/3 3. SQL II (cont) + Disks, Buffers, Files I
Video
Discussion 1
Worksheet
Solutions
Recording
    Note 2
3 Tu 9/8 4. Disks, Buffers, Files I (cont) + Disks, Buffers, Files II
Video
  Vitamin 2 (due 9/16)    
  Th 9/10 5. Cost Models and Index + B+ Trees
Video
Discussion 2
Worksheet
Solutions
Recording
  Project 2 (due 9/24) Note 3
Exam Prep 1
4 Tu 9/15 6. Indices & B+ Tree Refinements (Part 1)(Part 2)
Video
  Vitamin 3 (due 9/23)    
  Th 9/17 7. Buffer Management
Video
Discussion 3
Worksheet
Solutions
Recording
Vitamin 4 (due 9/27)   Note 4
5 Tu 9/22 8. Relational Algebra
Video
      Note 5
  Th 9/24 9. Sorting & Hashing
Video
Discussion 4
Worksheet
Solutions
Recording
Vitamin 5 (due 10/2)   Note 6
Note 7
Exam Prep 2
6 Tu 9/29 10. Iterators & Joins I
Video
    Project 3
(Part 1 due 10/10, Part 2 due 10/18)
Note 8
  Th 10/1 11. Iterators & Joins II
Video
Discussion 5
Worksheet
Solutions
Recording
Vitamin 6 (due 10/12)    
7 Mo 10/5 Midterm 1        
  Tu 10/6 12. Query Opt: Plan Space
Video
      Note 9
Postgres Query
Optimization
  Th 10/8 13. Query Opt: Costs & Search
Video
Discussion 6
Worksheet
Solutions
Recording
Vitamin 7 (due 10/19)    
8 Tu 10/13 14. Transactions & Concurrency I
Video
      Note 10
  Th 10/15 15. Transactions & Concurrency II
Video
Discussion 7
Worksheet
Solutions
Recording
Vitamin 8 (due 10/26) Project 4
(Part 1 due 10/30, Part 2 due 11/5)
Note 11
9 Tu 10/20 16. Recovery I
Video
       
  Th 10/22 17. Recovery II
Video
Discussion 8
Worksheet
Solutions
Vitamin 9   Note 12
10 Tu 10/27 18. DB Design: Entity-Relationship Models       Note 13
  Th 10/29 19. DB Design: FDs and Normalization Discussion 9 Vitamin 10    
11 Mo 11/2 Midterm 2        
  Tu 11/3 20. Parallel Query Processing       Note 14
  Th 11/5 21. Data Replication and Distributed Transactions I Discussion 10 Vitamin 11 Project 5  
12 Tu 11/10 22. Data Replication and Distributed Transactions I       Note 15
  Th 11/12 23. NoSQL I Discussion 11 Vitamin 12    
13 Tu 11/17 24. NoSQL II        
  Th 11/19 TBD Discussion 12 TBD    
14 Tu 11/24 TBD     Project 6 (due 12/6)  
  Th 11/26 Thanksgiving No Section      
15 Tu 12/1 TBD        
  Th 12/3 TBD TBD      
16 Tu 12/8 RRR Week        
  Th 12/10 RRR Week        
17 M 12/14 Final Exam (3PM-6PM)