ICS 321 Data Storage and Retrieval ( Spring 2015 CRN 84959)

Class Schedule (tentative)

Week Date Topic Readings Videos Remarks
1 Mon Jan 12 Course Organization   slides (pdf).
1 Wed Jan 14 The Worlds of Database Systems Ch 1. (screencast)
slides (pdf). Exercise 1 (pdf).
2 Mon Jan 19 Martin Luther King Holiday    
2 Wed Jan 21 The Relational Model of Data Ch 2. slides (pdf). Exercise 2 (pdf).
3 Mon Jan 26 The Relational Model of Data Ch 2. slides (pdf). Exercise 3 (pdf).
3 Wed Jan 28 Algebraic and Logical Query Languages Ch 5. slides (pdf). Exercise 4 (pdf).
4 Mon Feb 2 Algebraic and Logical Query Languages Ch 5. slides (pdf). Exercise 5 (pdf).
4 Wed Feb 4 The Database Language SQL Ch 6. slides (pdf). Exercise 6 (pdf).
5 Mon Feb 9 The Database Language SQL Ch 6. slides (pdf). Exercise 7 (pdf).
5 Wed Feb 11 The Database Language SQL Ch 6. slides (pdf). Exercise 8 (pdf).
6 Mon Feb 16 Presidents' Day Holiday    
6 Wed Feb 18 SQL in a Server Environment Ch 9. slides (pdf).
7 Mon Feb 23 SQL in a Server Environment Ch 9.  
7 Wed Feb 25 Pre-midterm Review   mock-midterm.
8 Mon Mar 2 Midterm Exam    
8 Wed Mar 4 SQL in a Server Environment Ch 9. slides (pdf). Exercise 9 (pdf). jdbc example.
9 Mon Mar 9 High-Level Database Models Ch 4. slides (pdf). Exercise 10 (pdf).
9 Wed Mar 11 Design Theory for Relational Databases Ch 3.{1-4} slides (pdf).
10 Mon Mar 16 Design Theory for Relational Databases Ch 3.{1-4} Exercise 11 (pdf).
10 Wed Mar 18 Review    
11 Mon Mar 23 Spring Break    
11 Wed Mar 25 Spring Break    
12 Mon Mar 30 Design Theory for Relational Databases Ch 3.{1-4} slides (pdf). Exercise 12 (pdf).
12 Wed Apr 1 Design Theory for Relational Databases Ch 3.{1-4} slides (pdf). Exercise 13 (pdf).
13 Mon Apr 6 Constraints, Triggers, Views and Indexes Ch 7., Ch 8 slides (pdf). Exercise 14 (pdf).
13 Wed Apr 8 Overview of Transaction Processing Ch 18.{0-2}, Ch 17.1. slides (pdf). Exercise 15 (pdf).
14 Mon Apr 13 Overview of Transaction Processing Ch 18.{0-2}, Ch 17.1. slides (pdf).
14 Wed Apr 15 Overview of Transaction Processing Ch 18.{0-2}, Ch 17.1. Exercise 16 (pdf).
15 Mon Apr 20 Overview of Storage and Indexing Ch 13.{0-2}, Ch 14.{0-2}. slides (pdf). Exercise 17 (pdf).
15 Wed Apr 22 Overview of Storage and Indexing Ch 13.{0-2}, Ch 14.{0-2}. slides (pdf). Exercise 18 (pdf).
16 Mon Apr 27 Overview of Query Processing Ch 16.1, Ch 15.{0-3}. slides (pdf). Exercise 19 (pdf).
16 Wed Apr 29 The Semi-structured Data Model & Programming Languages for XML Ch 11.,Ch 12. (screencast)
slides (pdf).mock-final.
17 Mon May 4 Project    
17 Wed May 6 Project  

General Information

Topics

Grading (Tentative)

Software Setup

Other Readings

Videos

Useful Links