Introduction and Relational Model: 01-intro.pdf
Basic SQL & Relational Algebra: 02-sql-ra.pdf
Entity Relationship (ER) Diagrams : 03-design.pdf
ER diagram to relational database translation: 04-ER-to-relational.pdf
More SQL: 05-sql.pdf
SQL programming: 05a-sql-prog.pdf (not in exam)
Functional Dependencies and Normal Forms: 06-fds-normalform.pdf
Project: WebApp and Flask Overview (Guest Lecture by Danai Adkisson and from CoLab): 07-project-webapp-flask-by-colab.pdf (not in exam)
Storage and Index: 08-storage-index.pdf
External Sorting and Join Algorithms: 09-sort-joinalgo.pdf
Sorting review on whiteboard: 09a-sort-whiteboard-review.pdf
XML: 10-xml.pdf
Discussion 8: XML and JSON (JSON not in exam)
Query Optimization and Cost Estimation: 11-qo.pdf
MongoDB and JSON: 12-mongodb.pdf (not in exam)
Transactions: Intro and Concurrency Control: 13-transaction.pdf
Transaction: Recovery: 14-tr-recovery.pdf
SQL Recursion: 15-recursion.pdf (not in exam)
Parallel databases and MapReduce (overview): 16-paralleldb-mr.pdf (not in exam)
Review: 17-review.pdf
Calendar
This calendar has lectures, discussions, and assignments due dates. Please check the office hour calendar (on Ed) for office hours schedule
The schedule is subject to change - please check frequently
Click on the lecture to see the links to notes and slides.
"Notes" are incomplete slides to encourage discussions and will be uploaded prior to lectures
"Slides" will be uploaded after the lectures