ICS 321 Data Storage and Retrieval (Spring 2013 CRN 86434)

General Information

Topics

Grading (Tentative)

Class Schedule (tentative)

Week Date Topic Readings Remarks
1 Mon Jan 7 Course Organization   slides (pdf).
1 Wed Jan 9 The Worlds of Database Systems Ch 1. slides (pdf). Exercise 1 (pdf).
2 Mon Jan 14 The Relational Model of Data Ch 2. Quiz 1 due. slides (pdf). Exercise 2 (pdf).
2 Wed Jan 16 The Relational Model of Data Ch 2. slides (pdf). Exercise 3 (pdf). (html).
3 Mon Jan 21 MLK Holiday   Quiz 2 due on Tue 1130h
3 Wed Jan 23 Design Theory for Relational Databases Ch 3. Assignment 1 due at 1700h. slides (pdf). Exercise 4 (pdf).
4 Mon Jan 28 Design Theory for Relational Databases Ch 3. Quiz 3 due.slides (pdf). Exercise 5 (pdf).
4 Wed Jan 30 Design Theory for Relational Databases Ch 3. slides (pdf). Exercise 6 (pdf).
5 Mon Feb 4 High-Level Database Models Ch 4. Quiz 4 due. slides (pdf). Exercise 7 (pdf).
5 Wed Feb 6 Algebraic and Logical Query Languages Ch 5. slides (pdf). Exercise 8 (pdf).
6 Mon Feb 11 Algebraic and Logical Query Languages Ch 5. Quiz 5 due. slides (pdf). Exercise 9 (pdf). Project Part 1 Proposals due 1700h
6 Wed Feb 13 The Database Language SQL Ch 6. Assignment 2 due at 1700h. slides (pdf). Exercise 10 (pdf).
7 Mon Feb 18 Presidents' Day Holiday   Quiz 6 due on Tue 1130h.
7 Wed Feb 20 Pre-Midterm Review   (mock-midterm).
8 Mon Feb 25 Midterm Exam   No Quiz.
8 Wed Feb 27 The Database Language SQL Ch 6. slides (pdf). Exercise 11 (pdf).
9 Mon Mar 4 The Database Language SQL Ch 6. Quiz 7 due. slides (pdf). Exercise 12 (pdf).
9 Wed Mar 6 SQL in a Server Environment Ch 9. slides (pdf). Exercise 13 (pdf). sqc (zip).
10 Mon Mar 11 SQL in a Server Environment Ch 9. Quiz 8 due. slides (pdf). odbc (zip). jdbc (zip).
10 Wed Mar 13 Constraints, Triggers, Views and Indexes Ch 7., Ch 8 slides (pdf). Exercise 14 (pdf).
11 Mon Mar 18 Post-Midterm Review   Quiz 9 due. Assignment 3 due at 1700h.
11 Wed Mar 20 Overview of Transaction Processing Ch 18.{0-2}, Ch 17.1. slides (pdf). Exercise 15 (pdf).
12 Mon Mar 25 Spring Recess    
12 Wed Mar 27 Spring Recess    
13 Mon Apr 1 Overview of Transaction Processing Ch 18.{0-2}, Ch 17.1. Quiz 10 due.Project (part 1) & Part 2 proposal due Apr 2 1700h. slides (pdf). Exercise 16 (pdf).
13 Wed Apr 3 Overview of Storage and Indexing Ch 13.{0-2}, Ch 14.{0-2}. slides (pdf). Exercise 17 (pdf).
14 Mon Apr 8 Overview of Storage and Indexing Ch 13.{0-2}, Ch 14.{0-2}. Quiz 11 due. slides (pdf). Exercise 18 (pdf).
14 Wed Apr 10 Overview of Query Processing Ch 16.1, Ch 15.{0-3}. slides (pdf). Exercise 19 (pdf).
15 Mon Apr 15 Overview of Query Processing Ch 16.1, Ch 15.{0-3}. Quiz 12 due. Exercise 20 (pdf).
15 Wed Apr 17 Final Exam Review   mock-final (pdf).
16 Mon Apr 22 The Semi-structured Data Model & Programming Languages for XML Ch 11.,Ch 12. Quiz 13 due. Part 1 | Part 2 | Part 3
16 Wed Apr 24 The Semi-structured Data Model & Programming Languages for XML Ch 11.,Ch 12. Part 4 | Part 5 | Part 6 (optional)
17 Mon Apr 29 Project Presentation    
17 Wed May 1 Project Presentation    

Software Setup

Other Readings

Videos

Useful Links