Why Databases?
Concepts: Data models, DB systems overview
SQL I
Concepts: Schemas, Systems, Select-From-Where See Course Info for general submission information and the regrade policy.
SQL II
Concepts: Joins, Set operators, Subqueries
SQL III
Advanced Concepts: Grouping, Aggregations, Nested queries 9:30 AM — 10:20 AM Remote
Scale: Indexing and IO Model
Sorting, Building Indices Part 1
B+ Trees Query Optimization Part 1
See Course Info for general submission information and the regrade policy.
Query Optimization Part 2
9:30 AM — 10:20 AM Remote Guest Lecture Dr. Girish Baliga – On Presto and Vertica at Uber Dr. Theo Vassilakis (ex-CTO at Grab) – early lead on Dremel/BigQuery, CEO of Metanautix
Systems Design: Putting it all together
Exam Review Check out Piazza for more information! See Course Info for general submission information and the regrade policy.
Transactions
9:30 AM — 10:20 AM Remote Cancelled due to election day. Transactions
E/R Model and Design Theory
TBA
Design Theory Continued
9:30 AM — 10:20 AM Remote Guest Lecture