Class: M/W/F 9–9:50am, LSB 212
Instructor: Henry Feild, Ph.D.
Office Hours: M/T/R/F 10–10:50am; W 2–2:50pm; in LSB 113.
|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—
|Feb. 22, 24, 26||Relational databases||HW 4|
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|
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 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.
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)