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