The following slides are available in PDF.
They are from Jeff Ullman's offering of the CS145 course in the Autumn
of 2000.
- Lecture 1, Intro, E/R Model
PDF
- Lecture 2, More E/R Model
PDF
- Lecture 3, Relational Model
PDF
- Lecture 4, Functional Dependencies, Normalization
PDF
- Lecture 5, Multivalued Dependencies, Relational algebra
PDF
- Lecture 6, Intro to SQL
PDF
- Lecture 7, More SQL: Aggregation, Duplicates, DB Modification
PDF
- Lecture 8, Yet More SQL: Schema Definition, Views
PDF
- Lecture 9, Yet More SQL: NULL's, Outerjoins, Constraints
PDF
- Lecture 10, Constraints: Triggers, Assertions
PDF
- Lecture 11, PL/SQL, Embedded SQL
PDF
- Lecture 12, Intro. to Object-Relational SQL
PDF
- Lecture 13, More O-R SQL, Transactions, Authorization
PDF
- Lecture 14, Datalog
PDF
- Lecture 15, Recursion in Datalog and SQL3
PDF
- Lecture 16, ODL
PDF
- Lecture 17, Queries in OQL
PDF
- Lecture 18, More OQL
PDF
- Lecture 19, Semistructured Data, XML
PDF
- Lecture 20, Data Warehouses, Data Mining
PDF