Introduction to Databases, Stanford University

.
.
.
.
.


Week 1: January 7 - 13
Introduction (14 min)
Relational Databases (15 min)
XML Data (44 min)

Assigned Work
Quiz on XML data (due Jan 13)
XML Validation (DTD) Exercises (due Jan 20)

Week 2: January 14 - 20
JSON Data (36 min)
Relational Algebra (38 min)
Prerequisite: Relational Databases

Assigned Work
Quiz on JSON Data (due Jan 20)
Quiz on Relational Algebra (due Jan 20)
Relational Algebra Exercises (core set, due Jan 27)
Relational Algebra Exercises (challenge-level)

Optional Ungraded Work
Relational Algebra Extra Problems

Week 3: January 21 - January 27
SQL (125 min)
Prerequisite: Relational Databases
Recommended: Relational Algebra

Assigned Work
SQL Query Exercises (2 core sets, due Feb 3)
SQL Query Exercises (challenge-level, 2 sets)
SQL Modification Exercises (2 sets, due Feb 3)

Optional Ungraded Work
SQL Query Exercises (extra practice, 2 sets)

Week 4: January 28 - February 3
Relational Design Theory (103 min)
Prerequisite: Relational Algebra

Assigned Work
Quiz on Functional Dependencies (due Feb 3)
Quiz on Multivalued Dependencies (due Feb 3)
Quiz on Normalization (due Feb 3)

Optional Ungraded Work
Relational Design Extra Problems

Week 5: February 4 - 10
Querying XML (76 min)
Prerequisite: XML Data

Assigned Work
XPath and XQuery Exercises (2 core sets, due Feb 17)
XPath and XQuery Exercises (challenge-level, 2 sets)
XSLT Exercises (2 core sets, due Feb 17)
XSLT Exercises (challenge-level, 2 sets)
Midterm Exam - offered Feb. 6 - 8 (Thu-Sat) covering material through week 4

Optional Ungraded Work
XPath and XQuery Exercises (extra practice, 2 sets)
XSLT Exercises (extra practice, 2 sets)

Week 6: February 11 - 17
Unified Modeling Language (53 min)
Prerequisite: Relational Databases
Indexes (14 min)
Prerequisite: SQL
Transactions (45 min)
Prerequisite: SQL

Assigned Work
Quiz on UML (due Feb 17)
Quiz on Indexes (due Feb 17)
Quiz on Transactions (due Feb 17)

Optional Ungraded Work
UML Extra Problems
Transactions Extra Problems

Week 7: February 18 - 24
Constraints and Triggers (119 min)
Prerequisite: SQL

Assigned Work
Quiz on Constraints and Triggers (due February 24)
SQL Triggers Exercises (core set, due March 3)
SQL Triggers Exercises (challenge-level)
Optional Ungraded Work
Constraints Extra Problems
Triggers Extra Problems

Week 8: February 25 - March 3
Views (95 min)
Prerequisites: SQL, Constraints and Triggers
Authorization (11 min)
Prerequisite: SQL, Views

Assigned Work
Quiz on Views (due March 3)
Quiz on Authorization (due March 3)
SQL View-Update Exercises (core set, due March 10)
SQL View-Update Exercises (challenge-level)

Optional Ungraded Work
SQL View-Update Exercises (extra practice)
Defining and Using Views Extra Problems
Views Modifications Using Triggers Extra Problems
Automatic View Modifications Extra Problems
Authorization Extra Problems

Week 9: March 4 - 10
Recursion (63 min)
Prerequisite: SQL
On-Line Analytical Processing (45 min)
Prerequisite: SQL
Assigned Work
Quiz on Recursion (due March 10)
Quiz on OLAP (due March 10)
Optional Ungraded Work
Recursion Extra Problems
OLAP Extra Problems

Week 10: March 11 - 15
NoSQL Systems (47 min)
Prerequisite: SQL

Assigned Work
Final Exam -- offered March. 13-15 (Thu-Sat)