CS145 - Introduction to Databases
Autumn Quarter 1997

Exams

The midterm (postscript). The solution and error codes (HTML).

Introductory material

  1. Course Information (HTML).
  2. Course Outline (HTML).

Assignments

  1. Assignment 1 (HTML) Due Weds. Oct. 8, 5PM. Solutions (HTML).
  2. Assignment 2 (HTML) Due Weds. Oct. 15, 5PM. Solutions (HTML).
  3. Assignment 3 (HTML) Due Weds. Oct. 22, 5PM. Solutions (HTML).
  4. Assignment 4 (HTML) Due Weds. Oct. 29, 5PM. Solutions (HTML).
  5. Assignment 5 (HTML) Due Weds. Nov. 12, 5PM. Solutions (HTML).
  6. Assignment 6 (HTML) Due Mon. Nov. 24, 5PM. Solutions (HTML).
  7. Assignment 7 (HTML) Due Mon. Dec. 1, 5PM. Solutions (HTML).

Lecture Notes

Slides for the lectures are available for download.

Notes for Oracle System

  1. Introductory Guide (HTML).
  2. The Oracle Bulk Loader (HTML).
  3. Non-SQL2 Features of Oracle 7.3.2 (HTML).
  4. A member of the class, Kristian Widjaja, has provided a very useful description of Oracle Dates and Times (Text).
  5. Introduction to PL/SQL (HTML).
  6. Introduction to Embedded SQL (HTML).

Copied from Ullman's course in Stanford http://www-db.stanford.edu/~ullman/fcdb/aut97.html.

João Correia Lopes ([email protected]).
Last modified: Mon Dec 8 18:50:13 1997
J. Lopes Home page Página da disciplina (SIBD)