ICS 321 Data Storage and Retrieval (Spring 2014 CRN 85380)

Class Schedule (tentative)

Week Date Topic Readings Videos Remarks
1 Mon Jan 13 Course Organization   slides (pdf).
1 Wed Jan 15 The Worlds of Database Systems Ch 1. (screencast)
slides (pdf). Exercise 1 (pdf).
2 Mon Jan 20 MLK Holiday    
2 Wed Jan 22 The Relational Model of Data Ch 2. (screencast)
slides (pdf). Exercise 2 (pdf).
3 Mon Jan 27 Design Theory for Relational Databases Ch 3. (screencast)
slides (pdf). Exercise 4 (pdf).
3 Wed Jan 29 Design Theory for Relational Databases Ch 3. (screencast)
slides (pdf). Exercise 5 (pdf).
4 Mon Feb 3 The Relational Model of Data Ch 2. (screencast)
slides (pdf). Exercise 3 (pdf). (html).
4 Wed Feb 5 High-Level Database Models Ch 4. (screencast)
(screencast)
slides (pdf). Exercise 7 (pdf).
5 Mon Feb 10 Design Theory for Relational Databases Ch 3. (screencast)
slides (pdf). Exercise 6 (pdf).
5 Wed Feb 12 Algebraic and Logical Query Languages Ch 5. (screencast)
slides (pdf). Exercise 8 (pdf).
6 Mon Feb 17 President's Day Holiday    
6 Wed Feb 19 Algebraic and Logical Query Languages Ch 5. (screencast)
slides (pdf). Exercise 9 (pdf).
7 Mon Feb 24 Pre-Midterm Review   mock-mideterm (pdf).
7 Wed Feb 26 Midterm Exam    
8 Mon Mar 3 The Database Language SQL Ch 6. (screencast)
slides (pdf). Exercise 10 (pdf).
8 Wed Mar 5 The Database Language SQL Ch 6. (screencast)
slides (pdf). Exercise 11 (pdf). Project Proposals due Fri Mar 7.
9 Mon Mar 10 The Database Language SQL Ch 6. (screencast)
slides (pdf). Exercise 12 (pdf).
9 Wed Mar 12 SQL in a Server Environment Ch 9. Networking Primer (screencast)
(screencast)
Bring your laptops. slides (pdf). sqc (zip).
10 Mon Mar 17 SQL in a Server Environment Ch 9. (screencast)
Bring your laptops. slides (pdf). Exercise 13 (pdf). odbc (zip). jdbc (zip).
10 Wed Mar 19 Constraints, Triggers, Views and Indexes Ch 7., Ch 8 (screencast)
slides (pdf). Exercise 14 (pdf).
11 Mon Mar 24 Spring Recess    
11 Wed Mar 26 Spring Recess    
12 Mon Mar 31 Overview of Transaction Processing Ch 18.{0-2}, Ch 17.1. (screencast)
(screencast)
slides (pdf). Exercise 15 (pdf).
12 Wed Apr 2 Overview of Transaction Processing Ch 18.{0-2}, Ch 17.1. (screencast)
(screencast)
slides (pdf). Exercise 16 (pdf).
13 Mon Apr 7 Overview of Storage and Indexing Ch 13.{0-2}, Ch 14.{0-2}. (screencast)
slides (pdf). Exercise 17 (pdf).
13 Wed Apr 9 Overview of Storage and Indexing Ch 13.{0-2}, Ch 14.{0-2}. (screencast)
slides (pdf). Exercise 18 (pdf).
14 Mon Apr 14 Overview of Query Processing Ch 16.1, Ch 15.{0-3}. (screencast)
slides (pdf). Exercise 19 (pdf).
14 Wed Apr 16 Guest Lecture    
15 Mon Apr 21 Overview of Query Processing Ch 16.1, Ch 15.{0-3}. (screencast)
Exercise 20 (pdf).
15 Wed Apr 23 The Semi-structured Data Model & Programming Languages for XML Ch 11.,Ch 12. (screencast)
slides (pdf).
16 Mon Apr 28 Special Topics    
16 Wed Apr 30 Project Presentations    
17 Mon May 5 Project Presentations    
17 Wed May 7 Project Presentations & Final Exam Review   mock final (pdf).

General Information

Topics

Grading (Tentative)

Software Setup

Other Readings

Videos

Useful Links