Schedule

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)

Resources