The following schedule is subject to change at the instructor's discretion.
Slides will be linked here. I will try to post them before class but always get a version of the slides after class, as they may be updated. The slides that are linked here are a modified version of the authors slides that accompany the book.
You may also wish to view the slides that accompany the textbook. These slides are made available by the authors of the textbook.
Lecture Date | Topic | Readings (Be prepared for class discussion) | Assignments | Additional Resources |
Mon 1/29/2018 | Logistics for the semester, Introduction, Definitions, Purpose, Overview of the book | Chapter 1 | Greenspun's SQL for Web Nerds Intro | |
Wed 1/31/2018 | Intro to Relational Model | Chapter 2 all/Chapter 6 sections (6.1) | A Relational Model of Data for Large Shared Data Banks | |
Mon 2/5/2018 | Introl to Relational Model & Relational Algebra | Chapter 2 all/Chapter 6 sections (6.1) | Relational - a tool for experimenting with relational algebra | SQL and Relational Theory | |
Wed 2/7/2018 | Guest Lecturer Clare Grasso - ElasticSearch | Read this in preparation and think about the project | Homework #1 due | Tutorial | Documentation |
Mon 2/12/2018 | SQL | Chapter 3 all/Chapter 4 | Create, Drop, and Insertion scripts for university schema | |
Wed 2/14/2018 | Continuation of SQL | Chapter 3/Chapter 4 | Phase 1 of project due Thur 2/15/2018 | |
Mon 2/19/2018 | Non-Relational Query Languages and Database Programming | Just show up | ||
Wed 2/21/2018 | E-R Model | Chapter 7 all | Lucidchart | SmartDraw | |
Mon 2/26/2018 | E-R Model | Chapter 7 all | Homework #2 due | |
Wed 2/28/2018 | E-R Model | Chapter 7 all | ||
Mon 3/5/2018 | Relational Database Design/Normalization | Chapter 8 all | Guide to Five Normal Forms | |
Wed 3/7/2018 | Relational Database Design/Normalization | Chapter 8 all | Phase 2 of project due | |
Mon 3/12/2018 | Relational Database Design/Normalization | Chapter 8 all | ||
Wed 3/14/2018 | MIDTERM | |||
Mon 3/19/2018 and Wed 3/21/2018 | SPRING BREAK | N/A | ||
Mon 3/26/2018 | Wrap up Normalization/Data Storage and File Structure | Chapter 8 all/Chapter 10 all | ||
Wed 3/28/2018 | Data Storage and File Structure | Chapter 10 all | Homework #3 due | |
Mon 4/2/2018 | Indexing and Hashing | Chapter 11 all | Phase 3 of project due | |
Wed 4/4/2018 | Indexing and Hashing | Chapter 11 all | Visualize B+ Tree | Bitmap Index vs. B-tree Index | |
Mon 4/9/2018 | Indexing and Hashing | Chapter 11 all | Homework #4 due | MySQL Indexing Reference |
Wed 4/11/2018 | Query Processing | Chapter 12 all | ||
Mon 4/16/2018 | Transactions | Chapter 14 all | MySQL Transaction Isolation Levels | |
Wed 4/18/2018 | Concurrency Control | Chapter 15 all | Homework #5 due 4/20/2018 instead of 4/18/2018 | |
Mon 4/23/2018 | Concurrency Control | Chapter 15 all | Analysis and Comparison of Concurrency Control Techniques | MySQL Concurrency Scheme | |
Wed 4/25/2018 | Database System Architectures & Distributed Databases | Chapter 17 | Architecture of a Database System - UC Berkeley Database Group | |
Mon 4/30/2018 | Project Discussion | Phase 4 of project due | ||
Wed 5/2/2018 | Big Data and Distributed Databases | Chapter 19 up to 19.10 | Homework #6 due | |
Mon 5/7/2018 | Wrap up Alternative Databases and Revisit Query Processing and Presentations | Finish Chapter 12 and use references provided | Bigtable: A Distributed Storage System for Structure Data | Article on NoSQL,Graph Databases and Neo4j | MapReduce paper | Slideshow about NoSQL and MongoDB | List of NoSQL databases | |
Wed 5/9/2018 | Presentations | |||
Mon 5/14/2018 | Presentations - LAST DAY OF CLASSES | 5/16/2018 - Final Project Report due (Includes all previous phases) | ||
Fri 5/18/2018 | Final Exam Section 02 - 1:00 - 3:00 PM | |||
Wed 5/23/2018 | Final Exam Section 01 - 1:00 - 3:00 PM |
**The instructor reserves the right to change this schedule, however, any changes would be communicated to students.