Schedule (Spring 2017)

All deadlines are at 10pm on the date listed. This includes both homeworks and projects.

Dates subject to change, but if a change is made, an announcement will be made in class or via Piazza.

Links to videos, slides, projects and exam materials will be made available as relevant dates approach.

Homework (via HackerRank) will be always be distributed on Friday nights and due the following Thursday. Weeks without homework are marked on the schedule.

There is a 4 day late period for Projects (see syllabus).

Week (Date) Link to Videos Project Due Dates Notes
1 (2017-01-09) Course Overview, Schemas and File Formats Project 0 is released. Homework #0 (not worth any points) is due on Thursday at 10pm (2017-01-12). Video description of HackerRank assignments here.
2 (2017-01-16) Git and Basic SQL (Create, Insert, Select) Project 0 is due Wednesday (2017-01-18). Project 1 is released.
3 (2017-01-23) Data Types, Keys, Distinct, Where, and Join Project 1 is due Wednesday (2017-01-25). Project 2 is released.
4 (2017-01-30) Update, Delete, Union, Dates and Times, Foreign Keys, and Checks
5 (2017-02-06) Triggers, Views, Indices, Stored Procedures, CASE, Functions, Aggregates, Collations, Adapters and Converters Project 2 is due on 2017-02-07. Project 3 is released.
6 (2017-02-13) Transations and Schedules
7 (2017-02-20) Locks and Rollbacks Project 3 is due on 2017-02-21. Project 4 is released.
8 (2017-02-27) Optimistic Scheduling
Spring Break (2017-03-06) No Content No Homework Due This Week
9 (2017-03-13) Entity-Relationship Diagrams Project 4 is due on 2017-03-14. Homework #8 (released before Spring Break); Due on 2017-03-16
10 (2017-03-20) Normal Forms Project 4 is due on 2017-03-21.
11 (2017-03-27) Exam Details In-Person Exam. Location: Veterinary Medical Center - E100. Time: 2017-03-30 06:00PM. Duration 2 hours. Alternative times have been posted.
12 (2017-04-03) Indices, B+ Trees, Hashtables, and Bitmaps Project 5 is released. Homework #10 is released on Mimir (see lecture); Due on 2017-04-13 (as normal)
13 (2017-04-10) Distributed Databases, Distributed Transactions, and RAID
14 (2017-04-17) NOSQL Overview, MongoDB, other NoSQL Databases Project 5 is due on 2017-04-18. Project 6 is released. HW #11 (on Mimir) is due on 2017-04-20.
15 (2017-04-24) Big Data, Hadoop, Security, and Authorization HW #12 (On Mimir) is due on 2017-04-27.
Finals Week (2017-04-24) No Content This Week Project 6 is due on 2017-05-02. There will only be a two day late period (to allow for grade submission). No Final Exam