Bài đăng

Đang hiển thị bài đăng từ tháng một, 2013

Introduction to Database

Hình ảnh
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 F…