| CPSC 343 | Database Theory and Practice | Fall 2026 |
Dates for things in light gray are for planning purposes and are subject to change.
| Assignments | ||||
|---|---|---|---|---|
Week 1: 8/31-9/4Topics: course introduction; DB foundations; SQL — basic queries |
||||
| Mon |
Materials from class:
|
|||
| Wed | Materials from class: | |||
| Fri |
Materials from class:
|
homework 1 SQL basic queries |
||
Week 2: 9/7-9/11Topics: SQL — joins, subqueries, aggregation |
||||
| Mon |
Materials from class:
|
homework 2 SQL — joins |
||
| Wed | *** bring laptop to class if you are able to (set up for VDI access) | |||
| Fri | *** bring laptop to class if you are able to (set up for VDI access) | |||
Week 3: 9/14-9/18Topics: |
||||
| Mon | homework collected (weeks 1-2) |
|||
| Wed | ||||
| Fri | milestone 1 due topic and requirements |
|||
Week 4: 9/21-9/25Topics: |
||||
| Mon | homework collected (weeks 2-3) |
|||
| Wed | ||||
| Fri | ||||
Week 5: 9/28-10/2Topics: |
||||
| Mon | homework collected (weeks 3-4) |
|||
| Wed | ||||
| Fri | ||||
Week 6: 10/5-10/9Topics: |
||||
| Mon | homework collected (weeks 4-5) |
|||
| Wed | ||||
| Fri | milestone 2 due modeling and design |
|||
Week 7: 10/12-10/16Topics: |
||||
| Mon |
exam 1
|
homework collected (weeks 5-6) |
||
| Wed | ||||
| Fri | ||||
Week 8: 10/19-10/23Topics: |
||||
| Mon | fall break | |||
| Wed | ||||
| Fri | ||||
Week 9: 10/26-10/30Topics: |
||||
| Mon | homework collected (weeks 6-8) |
|||
| Wed |
exam 2
|
|||
| Fri | ||||
Week 10: 11/2-11/6Topics: |
||||
| Mon | homework collected (weeks 8-9) |
|||
| Wed | milestone 3 due implementation |
|||
| Fri | ||||
Week 11: 11/9-11/13Topics: |
||||
| Mon | homework collected (weeks 9-10) |
|||
| Wed |
exam 3
|
|||
| Fri | ||||
Week 12: 11/16-11/20Topics: |
||||
| Mon | homework collected (weeks 10-11) |
|||
| Wed | milestone 4 due data integrity and security hardening |
|||
| Fri | ||||
Week 13: 11/23-11/27Topics: |
||||
| Mon | homework collected (weeks 11-12) |
|||
| Wed | Thanksgiving break | |||
| Fri | ||||
Week 14: 11/30-12/4Topics: |
||||
| Mon | ||||
| Wed |
exam 4
|
|||
| Fri | ||||
Week 15: 12/7-12/11Topics: |
||||
| Mon | homework collected (weeks 12-14) |
|||
| Wed | milestone 5 due performance audit and final handin |
|||
| Fri | homework collected (weeks 13-14) |
|||
Reading Period: 12/12-12/14 |
||||
| Sat | ||||
| Sun | ||||
| Mon | ||||
Final Exams: 12/15-12/18 |
||||
| Tue | ||||
| Wed | ||||
| Thu | ||||
| Fri |
exam 5
final exam 12/18 7-10pm |
end-of-semester deadline no work accepted after 12/18 10pm |
||