Schedule

Date Topic Homeworks Notes
Jan. 25, 27, 29 Overview of CRUD
Feb. 1, 3, 5 CSV, XML, JSON HW 1
Feb. 8, 10, 12 HW 2
Feb. 15, 17, 19 NoSQL HW 3 No class Monday—
Presidents Day
Feb. 22, 24, 26 Relational databases HW 4
Feb. 29,
Mar. 2, 4		 SQL HW 5 Exam 1 Friday
Mar. 7, 9, 11 HW 6
Mar. 14, 16, 18 No class—Spring break
Mar. 21, 23, 25 Database design HW 7
Mar. 28, 30, Apr. 1 HW 8
Apr. 4, 6, 8 Advanced SQL Blabber: Initial database design Exam 2 Friday
Apr. 11, 13, 15 Transactions and indexes Blabber: RDBMS tables setup
Apr. 18, 20, 22 Constraints and triggers Blabber: 3 API functions No class Monday—Patriots day
Apr. 25, 27, 29 Views Blabber: 50% of API
May 2, 4, 6 Review Final Project due Wednesday
May 13 Final Exam: 8–10am in LSB 212
(Back to top)

Assignments

Homeworks

Most weeks, there will be a homework due Wednesday night at 11:59pm. Not all homeworks will necessarily be graded. For homeworks that are graded, you may come to office hours within two weeks of the grades being released on Canvas with corrections to get full points back on problems that were reasonably attempted in the original submission. You must be able to explain what you did wrong as well as the nature of your corrections. All homeworks are posted on Canvas a week before the due date.

Labs

Labs are short assignments that we will usually start in class and you will finish as homework by the deadline given. You can work individually or in pairs on labs. Labs cannot be made up. Not all labs will necessarily be graded.

Final project

A final project will be given that will test your understanding of database design, CRUD, and polyglot persistence. You may work in pairs for this. You will present your work in the final week of class. You can find the assignment here.

(Back to top)

Resources

(Back to top)