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||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|