Note: This schedule is subject to change and will be adjusted as needed throughout the semester. Check back often. The lecture slides will be posteed after each class, by end of the day. means we have an in-class practice; bring your laptop!
# | Date | Topics | Reading | Assignments |
---|---|---|---|---|
Introduction and Querying | ||||
1 | M Jan 8 | Course Overview | ||
2 | R Jan 11 | SQL: Introduction |
Setup SQLite, Setup SQLite (Chrome optional), Setup Gradiance, |
Q1 |
M Jan 15 | No class: MLK day | |||
3 | R Jan 18 | SQL: Intermediate | SAMS Ch 1-4, 12 Setup PostgreSQL |
Q2 |
4 | M Jan 22 | SQL: Intermediate | SAMS Ch 5-9 | |
5 | R Jan 25 | SQL: Advanced | SAMS Ch 10-17 GUW Ch 6 |
Q3, HW1 |
6 | M Jan 29 | SQL: Advanced | ||
7 | R Feb 1 | SQL: Advanced & Practice | Q4, HW2 | |
Database Design and Normal Forms | ||||
8 | M Feb 5 | Database Design: ER Diagrams | GUW Ch 2 | |
9 | R Feb 8 | Database Design: ER Diagrams | GUW Ch 3.2-3.7 | Q5, HW3 |
10 | M Feb 12 | Exam 1 Database Design: ER Diagrams |
||
11 | R Feb 15 | Database Design: ER Diagrams | Q6 | |
M Feb 19 | No class: President's Day | |||
12 | R Feb 22 | Database Design: Relations | P1 (FR 2/23) | |
13 | M Feb 26 | Database Design: Normalization | ||
14 | R Mar 1 | Database Design: Normalization | Jupyter Activities Setup Jupyter (slides) | Q7, HW4 (FR 3/2) |
M Mar 5 | No class: Spring break | |||
R Mar 8 | No class: Spring break | |||
Transaction Processing | ||||
15 | M Mar 12 | Database Design: Decompositions,
Transactions |
GUW Ch 6.6, 18 | |
16 | R Mar 15 | Concurrency | ||
Query Processing and Database Internals | ||||
17 | M Mar 19 | Exam 2 I/O Cost Models & Merge Sort |
GUW Ch 15.1-15.4 | |
18 | R Mar 22 | I/O Cost Models & External Sort | Q8 | |
19 | M Mar 26 | Indexing and B+ trees | GUW Ch 14.1-14.2 | |
20 | R Mar 29 | Joins 1 | GUW Ch 15.3 | |
21 | M Apr 2 | Joins 2 & Relational Algebra 1 | GUW Ch 2 | HW5 |
NoSQL | ||||
22 | R Apr 5 | Relational Algebra 2 & Query Optimization, NoSQL 1 | GUW Ch 16.2 | P2 (R 4/5), Q9 (FR 4/6) |
23 | M Apr 9 | NoSQL 2 | ||
24 | R Apr 12 | NoSQL 3, Class Review and Course Evaluation0 | Q10 (optional) | |
M Apr 16 | No class: Patriot's day | Optional PPTX (Wed 4/18) | ||
R Apr 19 | No class: Reading day | HW6 (R 4/19) | ||
M Apr 23 | Exam 3 (1-3pm, location: Cargill Hall 097) |