| Week |
Tuesday |
Thursday |
Homework |
|
1
|
Jan 18 Jan 20
Overview of Database Systems
|
Jan 20 Jan 22
Architecture, DBMS Components
|
HW1: Fundamentals
(due 01/23 before 11:59pm)
|
|
2
|
Jan 25
ER Diagrams, Python SQLite
|
Jan 27
Group Project, UML Diagrams
|
HW2: Data Modeling
(due 01/30 before 11:59pm)
|
|
3
|
Feb 01
Relational Model, Key Constraints
|
Feb 03
Dependencies and Normalization
|
HW3: Design Theory
(due 02/13 before 11:59pm)
|
|
4
|
Feb 08
Assessment Day
|
Feb 10
GP1 Feedback, Peer Review
|
GP1: Written Proposal
(due 02/10 present in class)
|
|
5
|
Feb 15
PostgreSQL, pgAdmin, and psql
|
Feb 17
GitHub, Join Queries, Indexes
|
HW4: Postgres Queries
(due 02/27 before 11:59pm)
|
|
6
|
Feb 22
Grouping, Aggregation, Subquery
|
Feb 24
GP2 Feedback, Peer Review
|
GP2: Schema Design
(due 02/24 present in class)
|
|
7
|
Mar 01
Views, Privileges, and Catalogs
|
Mar 03
Exam #1
|
Prepare for Exam
|
|
8
|
Mar 08
SQL Functions by Example
|
Mar 10
GP3 Feedback, Peer Review
|
GP3: Example Queries
(due 03/10 present in class)
|
| |
Mar 15
Spring Break
|
Mar 17
Spring Break
|
|
|
9
|
Mar 22
Web Architecture, 3-Tier Apps
|
Mar 24
Intro to JDBC / SQL Injection
|
HW5: Basic Web App
(due 03/27 before 11:59pm)
|
|
10
|
Mar 29
Text Search, Similarity Search
|
Mar 31
GP4 Feedback, Peer Review
|
GP4: Initial Prototype
(due 03/31 present in class)
|
|
11
|
Apr 05
SQL Recursion, Window Queries
|
Apr 07
NoSQL Intro, Key-Value Stores
|
HW6: Advanced SQL
(due 04/10 before 11:59pm)
|
|
12
|
Apr 12
MongoDB Tutorial (Doc-Based)
|
Apr 14
Neo4j Tutorial (Graph-Based)
|
HW7: NoSQL Report
(due 04/17 before 11:59pm)
|
|
13
|
Apr 19
XML Databases, XPath, XQuery
|
Apr 21
GP5 Feedback, Peer Review
|
GP5: Working Prototype
(due 04/21 present in class)
|
|
14
|
Apr 26
Big Data: Hadoop, Hive, Spark
|
Apr 28
Exam #2
|
Prepare for Exam
|
|
15
|
May 03
How to Present Well, Logistics
|
May 05
GP6 Feedback, Peer Review
|
GP6: Final Presentation
(due 05/05 present in class)
|
|
|
May 10
Final Code Review, 10:30–12:30
|
May 12
Congrats to Class of 2022!
|
|