Home | Syllabus | Schedule | Homework,
Projects, & Handouts | Readings
_______________________________________________________________________________________________________________________
Lecture Schedule
The index of each slide corresponds with the associated chapter in the textbook.
Chapter 1 - Databases and Database Users (pdf )
Chapter 2 - Database System Concepts and Architecture (pdf )
Chapter 3 - Data Modeling Using the Entity Relationship (ER) Model (pdf )
Chapter 4 - Enhanced Entity-Relationship (EER) Modeling (pdf )
Chapter 5 - The Relational Data Model Relational Database Constraints (pdf )
Chapter 6 - Basic SQL (pdf
)
Chapter 7 - More SQL: Complex Queries, Triggers, Views, and Schema Modification (pdf
)
Chapter 8 - The Relational Algebra and Relational Calculus (pdf)
Chapter 9 - Relational Database Design by ER- and EER-to-Relational Mapping (pdf)
Chapter 10 - Introduction to SQL Programming Techniques (pdf)
Chapter 11 - Web Database Programming Using PHP (pdf)
Chapter 12 - Object, Object-Relational, and XML: Concepts, Models, Languages, and Standards(pdf)
Chapter 14 - Basics of Functional Dependencies and Normalization for Rational Databases
(pdf)
Chapter 15 - Relational Database Design and Algorithms and Further Dependencies (pdf)
Chapter 17 - Indexing Structures for Files and Physical DB Design (pdf)
Chapter 18 - Strategies for Query Processing (pdf)
Chapter 19 - Query Optimization (pdf)
Chapter 20 - Introduction to Transaction Processing Concepts and Theory (pdf)
Chapter 21 - Concurrency Control Techniques (pdf)
Chapter 22 - Database Recovery Techniques (pdf)
Chapter 23 - Distributed Database Concepts (pdf)
Chapter 24 - NOSQL Databases and Big Data Storage Systems (pdf)
Chapter 25 - Big Data Technologies based on MapReduce and Hadoop (pdf)
Chapter 26 - Enhanced Data Models:
Introduction to Active,
Temporal, Spatial, Multimedia,
and Deductive Databases (pdf)
Chapter 27 - Introduction to Information Retrieval
and Web Search (pdf)