| Slides From Autumn,
2001
|
The following slides are available in postscript and PDF.
They are from Jeff Ullman's offering of the CS145 course in the Autumn
of 2001.
Each set of slides represents a 1.25 hour lecture, of which there were 19
in this course.
You are welcome to download these slides and use them as you wish.
- Lecture 1, Intro, E/R Model
Postscript
PDF
- Lecture 2, Weak Entity Sets, E/R Design
Postscript
PDF
- Lecture 3, Relational Model, Functional Dependencies
Postscript
PDF
- Lecture 4, Normal Forms, Multivalued Dependencies
Postscript
PDF
- Lecture 5, Relational algebra
Postscript
PDF
- Lecture 6, Intro to SQL
Postscript
PDF
- Lecture 7, More SQL: Subqueries, Grouping/Aggregation,
Modifications
Postscript
PDF
- Lecture 8, Yet More SQL: Schemas, Views
Postscript
PDF
- Lecture 9, Constraints
Postscript
PDF
- Lecture 10, Triggers, PL/SQL
Postscript
PDF
- Lecture 11, Embedded SQL, CLI, JDBC
Postscript
PDF
- Lecture 12, Object-Relational SQL
Postscript
PDF
- Lecture 13, More O-R SQL, Transactions, Authorization
Postscript
PDF
- Lecture 14, Datalog
Postscript
PDF
- Lecture 15, More Datalog, SQL Recursion, Intro to ODL
Postscript
PDF
- Lecture 16, More ODL, Intro to OQL
Postscript
PDF
- Lecture 17, More OQL
Postscript
PDF
- Lecture 18, Information Intrgration, Semistructured Data, XML, Xquery
Postscript
PDF
- Lecture 19, Data Warehouses, Data Mining
Postscript
PDF