Schedule (Spring 2018)

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.

Weekly homework will be always be distributed on Friday nights and due the following Thursday. Weeks without homework are marked on the schedule.

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

Week (Date) Link to Videos Project Due Dates Notes
1 (2018-01-08) Course Overview, Schemas and File Formats Project 0 is released. Homework #0 (not worth any points) is due on Thursday at 10pm (2018-01-11). Video instruction here ( here ).
2 (2018-01-15) Basic SQL (Create, Insert, Select) Project 0 is due Tuesday (2018-01-16). Project 1 is released.
3 (2018-01-22) Filters, Constraints and Joins Project 1 is due Tuesday (2018-01-23). Project 2 is released.
4 (2018-01-29) Update, Delete, Union, Dates and Times, Foreign Keys, and Checks
5 (2018-02-05) Triggers, Views, Indices, Stored Procedures, CASE, Functions, Aggregates, Collations, Adapters and Converters Project 2 is due on 2018-02-06. Project 3 is released.
6 (2018-02-12) Transations and Schedules
7 (2018-02-19) Locks and Rollbacks Project 3 is due on 2018-03-13. Project 4 is released.
8 (2018-02-26) Optimistic Scheduling
Spring Break (2018-03-05) No Content No homework due this week.
9 (2018-03-12) Entity-Relationship Diagrams
10 (2018-03-19) Normal Forms Project 4 is due on 2018-04-03.
11 (2018-03-26) Exam Details Exam on 2017-03-29 (see details link)
12 (2018-04-02) Indices, B+ Trees, Hashtables, and Bitmaps Project 5 is released.
13 (2018-04-09) Distributed Databases, Distributed Transactions, and RAID
14 (2018-04-16) NOSQL Overview, MongoDB, other NoSQL Databases Project 5 is due on 2018-04-17. Project 6 is released.
15 (2018-04-23) Big Data, Hadoop, Security, and Authorization
Finals Week (2018-04-30) No Content This Week Project 6 is due on 2018-05-01. No Final Exam