Slides From Autumn, 2002

1. Powerpoint with voiceover. Note: these PPT files are large, averaging about 20MB for each file.

2. GIF's in one file per set.
3. GIF's, one slide at a time.

Uses of the slides are unrestricted, but please acknowledge the source if you make them available on the Web or otherwise.

Note: these slide sets do not each represent one lecture. Some are less than a 1.25-hour lecture, and some are more. Together, they were used to support about 24 hours of classroom time.

• The Entity-Relationship (E/R) Model. Complete Set (PPT with voiceover) . . . Complete Set (GIF) . . . One-At-A-Time (GIF)
• Relational Model, Conversion from E/R. Complete Set (PPT with voiceover) . . . Complete Set (GIF) . . . One-At-A-Time (GIF)
• Functional Dependencies. Complete Set (PPT with voiceover) . . . Complete Set (GIF) . . . One-At-A-Time (GIF)
• Normalization. Complete Set (PPT with voiceover) . . . Complete Set (GIF) . . . One-At-A-Time (GIF)
• Multivalued Dependencies. Complete Set (PPT with voiceover) . . . Complete Set (GIF) . . . One-At-A-Time (GIF)
• Relational Algebra. Complete Set (PPT with voiceover) . . . Complete Set (GIF) . . . One-At-A-Time (GIF)
• Introduction to SQL. Complete Set (PPT with voiceover) . . . Complete Set (GIF) . . . One-At-A-Time (GIF)
• More SQL: Aggregations, Modifications, Advanced Operations. Complete Set (PPT with voiceover) . . . Complete Set (GIF) . . . One-At-A-Time (GIF)
• Yet More SQL: Views, Data-Definition. Complete Set (PPT with voiceover) . . . Complete Set (GIF) . . . One-At-A-Time (GIF)
• Constraints and Triggers. Complete Set (PPT with voiceover) . . . Complete Set (GIF) . . . One-At-A-Time (GIF)
• Persistent Stored Modules (SQL/PSM). Complete Set (PPT with voiceover) . . . Complete Set (GIF) . . . One-At-A-Time (GIF)
• Oracle's PL/SQL. Complete Set (PPT with voiceover) . . . Complete Set (GIF) . . . One-At-A-Time (GIF)
• Host Languages: Embedded SQL, Call-Level Interface, JDBC. Complete Set (PPT with voiceover) . . . Complete Set (GIF) . . . One-At-A-Time (GIF)
• Authorization. Complete Set (PPT with voiceover) . . . Complete Set (GIF) . . . One-At-A-Time (GIF)
• Transactions. Complete Set (PPT with voiceover) . . . Complete Set (GIF) . . . One-At-A-Time (GIF)
• Object-Relational Systems. Complete Set (PPT with voiceover) . . . Complete Set (GIF) . . . One-At-A-Time (GIF)
• Datalog. Complete Set (PPT with voiceover) . . . Complete Set (GIF) . . . One-At-A-Time (GIF)
• Object-Oriented Databases: ODL/OQL. Complete Set (PPT with voiceover) . . . Complete Set (GIF) . . . One-At-A-Time (GIF)
• Semistructured Data and XML. Complete Set (PPT with voiceover) . . . Complete Set (GIF) . . . One-At-A-Time (GIF)
• Querying Semistructured Data: XPATH and XQUERY. Complete Set (PPT with voiceover) . . . Complete Set (GIF) . . . One-At-A-Time (GIF)
• Warehousing and Data-Mining. Complete Set (PPT with voiceover) . . . Complete Set (GIF) . . . One-At-A-Time (GIF)