Introduction to Database

Dropbox Link: https://www.dropbox.com/sh/oitzb2hl072z4gu/TneuiiaAbW

Course Schedule:
Week 1: January 15 - 21
Video Lectures

Introduction (14 min)

Relational Databases (15 min)

XML Data (44 min)

Assigned Work

Quiz on XML data (due Jan 21)

XML Validation (DTD) Exercises (due Jan 28)

Week 2: January 22 - 28
Video Lectures

JSON Data (36 min)

Relational Algebra (38 min)

Assigned Work

Quiz on JSON Data (due Jan 28)

Quiz on Relational Algebra (due Jan 28)

Relational Algebra Exercises (core set, due Feb 4)

Relational Algebra Exercises (challenge-level)

Optional Ungraded Work

Relational Algebra Extra Problems

Week 3: January 29 - February 4
Video Lectures

SQL (125 min)

Assigned Work

SQL Query Exercises (2 core sets, due Feb 11)

SQL Query Exercises (challenge-level, 2 sets)

SQL Modification Exercises (2 sets, due Feb 11)

Optional Ungraded Work

SQL Query Exercises (extra practice, 2 sets)

Week 4: February 5 - 11
Video Lectures

Relational Design Theory (103 min)

Assigned Work

Quiz on Functional Dependencies (due Feb 11)

Quiz on Multivalued Dependencies (due Feb 11)

Quiz on Normalization (due Feb 11)

Optional Ungraded Work

Relational Design Extra Problems

Week 5: February 12 - 18
Video Lectures

Querying XML (76 min)

Assigned Work

XPath and XQuery Exercises (2 core sets, due Feb 25)

XPath and XQuery Exercises (challenge-level, 2 sets)

XSLT Exercises (2 core sets, due Feb 25)

XSLT Exercises (challenge-level, 2 sets)

Midterm Exam - offered Feb. 14 - 16 (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 19-25
Video Lectures

Unified Modeling Language (53 min)

Indexes (14 min)

Transactions (45 min)

Assigned Work

Quiz on UML (due Feb 25)

Quiz on Indexes (due Feb 25)

Quiz on Transaction (due Feb 25)

Optional Ungraded Work

UML Extra Problems

Transactions Extra Problems

Week 7: February 26 - March 4
Video Lectures

Constraints and Triggers (119 min)

Assigned Work

Quiz on Constraints and Triggers (due March 4)

SQL Triggers Exercises (core set, due March 11)

SQL Triggers Exercises (challenge-level)

Optional Ungraded Work

Constraints Extra Problems

Triggers Extra Problems

Week 8: March 5 - 11
Video Lectures

Views (95 min)

Authorization (11 min)

Assigned Work

Quiz on Views (due March 11)

Quiz on Authorization (due March 11)

SQL View-Update Exercises (core set, due March 18)

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 12 - 18
Video Lectures

Recursion

On-Line Analytical Processing

Assigned Work

Quiz on Recursion (due March 18)

Quiz on OLAP (due March 18)

Optional Ungraded Work

Recursion Extra Problems

OLAP Extra Problems

Week 10: March 19 - 23
Video Lectures

NoSQL Systems (47 min)

Assigned Work

Final Exam -- offered March. 21-23 (Thu-Sat)