This is a Zoom-based class. Use: http://tiny.cc/ist210-zoom/
NOTE: ID/PWD to access course materials will be distributed in the first class
Unit #1 (1/25-2/5): Introduction, E/R Model
Lecture Slides: Introduction, data-model, er1, er2, practice
Homework #1 (due: Feb. 21)
Unit Test: 2/3 (sample-unit-test) => test solution
Unit #2 (2/8-2/19): Relational Model
Special Faculty Candidate Presentation: 2/10
Unit Test: 2/17 (sample-unit-test) => test solution
Unit #3 (2/22-3/5): Integrity and Normalization
Lecture Slides: Integrity, normalization, practice
Project #1 (due: Mar. 12)
Unit Test: 3/3 (sample-unit-test) => test solution
Unit #4 (3/8-3/19): Basic SQL
Lecture Slides: WinLabs Tutorial, basic 1, basic 2 (FK), basic 3 (Join), lab
Unit Test: 3/17 (sample-unit-test) => test solution
Unit #5 (3/22-3/31 4/5): Advanced SQL
Unit Test: 3/31 4/5 MONDAY: (sample-unit-test) => test solution
4/7: no class for wellness day
Project #2 (due: Apr. 30)
Unit #6 (4/5-4/16 4/12-4/21): Storage and Indexing
Homework #2 (due: Apr. 21 Apr. 28) => solution
Unit Test: 4/21 (sample-unit-test) => test solution
Bonus Homework #3 (due: Apr 30)
Unit #7 (4/26-4/30): Putting All Things Together
No lecture slides/videos--Review the materials from Unit #1 to #6
4/26: in-class Q&A
Unit Test: 4/28 => test solution