| Tentative schedule, Updated weekly; 25 April 2022 | |||
| Material | Date | Day | |
| Week 1 | Introductions to the course | ||
| No Lab | 21 Feb | M | |
| 22 | T | ||
| 24 | Th | ||
| Introduction to Course, | |||
| Purpose and Characteristics, | |||
| Week 2 | Introductions to the course | ||
| Lab | 28 | M | |
| 1 March | T | ||
| 3 | Th | ||
| Simple Databases and SQL | |||
| Structure of Relational Databases | |||
| Relational Operations | |||
| Week 3 | Introductions to the course | ||
| Lab | 7 | M | |
| 8 | T | ||
| 10 | Th | ||
| Queries, integrity constraints, primary keys | |||
| Advanced queries and aggregates | |||
| Week 4 | Introductions to the course | ||
| Lab | 14 | M | |
| 15 | T | ||
| 17 | Th | ||
| Structural Queries | |||
| Foreign keys, Query Structure | |||
| Advanced queries, joins and aggregates | |||
| Short Review | |||
| Week 5 | |||
| Spring Break!!! | 21 | M | |
| Spring Break!!! | 22 | T | |
| Spring Break!!! | 24 | Th | |
| Week 6 | |||
| No Lab | 28 | M | |
| 29 | T | ||
| 31 | Th | ||
| Working with keys and joins | |||
| DBBrowser, Discussion of Exam 1 | |||
| Week 7 | |||
| Exam 1 | 4 April | M | |
| Lab 04 assignment | 5 | T | |
| 7 | Th | ||
| Python DB automation | |||
| Python DB automation | |||
| Week 8 | |||
| 11 | M | ||
| 12 | W | ||
| 14 | F | ||
| Python DB automation | |||
| Python DB automation | |||
| Week 9 | |||
| Lab | 18 | M | |
| 19 | T | ||
| 21 | Th | ||
| Django and its Database | |||
| Streamlit and SQL | |||
| Week 10 | |||
| Lab | 25 | M | |
| 26 | T | ||
| 28 | Th | ||
| Project Assignments | |||
| MongoDB | |||
| Week 11 | |||
| Exam 2 : Project DB and update | 2 May | M | |
| 3 | T | ||
| 5 | Th | ||
| MongoDB | |||
| PyMongo: automating databases | |||
| Week 12 | |||
| Lab | 9 | M | |
| 10 | T | ||
| 12 | Th | ||
| Neo4J | |||
| Visual Searches and Queries | |||
| Week 13 | |||
| No Lab | 16 | M | |
| Projects are due | 18 | Wed | |
| No extensions possible | |||