Slides From Autumn, 2004
The following slides are from Jeff Ullman's offering of the CS145 course in the Autumn of 2004. Uses of the slides are unrestricted, but please acknowledge the source if you make them available on the Web or otherwise.

  1. Brief Introduction to CS145.
  2. Entity-Relationship Model.
  3. Relational Model.
  4. Functional Dependencies.
  5. Relational Design and Normalization.
  6. Multivalued Dependencies.
  7. Relational Algebra.
  8. Introduction to SQL, Part I.
  9. Introduction to SQL, Part II.
  10. Constraints.
  11. PSM.
  12. PL/SQL.
  13. Embedded SQL, CLI, JDBC.
  14. Object-Relational DBMS's.
  15. Semistructured Data/XML.
  16. XPath.
  17. XQuery.
  18. Authorization.
  19. Introduction to Transactions.
  20. Warehousing, Data-Mining.
  21. ODL/OQL.
  22. Datalog.

Additional materials not presented in class:

  1. UML, not presented in 2004.
  2. More Extensive ODL/OQL than presented in 2004.
  3. More Extensive Datalog than presented in 2004.