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)




































  • Nhận xét

    Bài đăng phổ biến từ blog này

    Vượt trên tất cả