ICS 321 Data Storage and Retrieval (Fall 2014 CRN 71629)

Class Schedule (tentative)

Week Date Topic Readings Videos Remarks
1 Tue Aug 26 Course Organization   slides (pdf).
1 Thu Aug 28 The Worlds of Database Systems Ch 1. (screencast)
slides (pdf). Exercise 1 (pdf).
2 Tue Sep 2 The Relational Model of Data Ch 2. slides (pdf). Exercise 2 (pdf).
2 Thu Sep 4 The Relational Model of Data Ch 2. slides (pdf). Exercise 3 (pdf).
3 Tue Sep 9 Algebraic and Logical Query Languages Ch 5. slides (pdf). Exercise 4 (pdf).
3 Thu Sep 11 Algebraic and Logical Query Languages Ch 5. slides (pdf). Exercise 5 (pdf).
4 Tue Sep 16 The Database Language SQL Ch 6. slides (pdf). Exercise 6 (pdf).
4 Thu Sep 18 The Database Language SQL Ch 6. slides (pdf). Exercise 7 (pdf).
5 Tue Sep 23 The Database Language SQL Ch 6. slides (pdf). Exercise 8 (pdf).
5 Thu Sep 25 SQL in a Server Environment Ch 9. Networking Primer (screencast)
slides (pdf).
6 Tue Sep 30 SQL in a Server Environment Ch 9. slides (pdf). Exercise 9 (pdf).
6 Thu Oct 2 Pre-midterm Review   mock-midterm. Project Proposal due 1700.
7 Tue Oct 7 Midterm Exam    
7 Thu Oct 9 High-Level Database Models Ch 4. slides (pdf). Exercise 10 (pdf).
8 Tue Oct 14 Design Theory for Relational Databases Ch 3.{1-4} slides (pdf). Exercise 11 (pdf).
8 Thu Oct 16 Design Theory for Relational Databases Ch 3.{1-4} slides (pdf). Exercise 12 (pdf).
9 Tue Oct 21 Design Theory for Relational Databases Ch 3.{1-4} slides (pdf). Exercise 13 (pdf).
9 Thu Oct 23 Constraints, Triggers, Views and Indexes Ch 7., Ch 8 slides (pdf). Exercise 14 (pdf).
10 Tue Oct 28 Overview of Transaction Processing Ch 18.{0-2}, Ch 17.1. slides (pdf). Exercise 15 (pdf).
10 Thu Oct 30 Overview of Transaction Processing Ch 18.{0-2}, Ch 17.1. slides (pdf). Exercise 16 (pdf).
11 Tue Nov 4 Election Day (no class)    
11 Thu Nov 6 Overview of Transaction Processing Ch 18.{0-2}, Ch 17.1.  
12 Tue Nov 11 Veteran's Day (no class)    
12 Thu Nov 13 Guest lecture by Jim Sarset    
13 Tue Nov 18 Overview of Storage and Indexing Ch 13.{0-2}, Ch 14.{0-2}. slides (pdf). Exercise 17 (pdf).
13 Thu Nov 20 Overview of Storage and Indexing Ch 13.{0-2}, Ch 14.{0-2}. slides (pdf). Exercise 18 (pdf).
14 Tue Nov 25 Overview of Query Processing Ch 16.1, Ch 15.{0-3}. slides (pdf). Exercise 19 (pdf).
14 Thu Nov 27 Thanksgiving Holiday    
15 Tue Dec 2 Project Presentation    
15 Thu Dec 4 Project Presentation    
16 Tue Dec 9 Project Presentation    
16 Thu Dec 11 Project Presentation   mock-final.

General Information

Topics

Grading (Tentative)

Software Setup

Other Readings

Videos

Useful Links