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 16 - Disk Storage, Basic File Structures, Hashing, and Modern Storage Architecture (pdf)
Chapter 17 - Indexing Structures for Files and Physical DB Design (pdf)
Chapter 3 - Data Modeling Using the Entity Relationship (ER) Mode (pdf)
Chapter 5 - The Relational Data Model Relational Database Constraints (pdf)
Chapter 6 - Basic SQL (pdf)
Chapter 8 - The Relational Algebra and Relational Calculus (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 7 - More SQL: Complex Queries, Triggers, Views, and Schema Modification (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 25 - Big Data Technologies based on MapReduce and Hadoop (pdf)
Chapter 23 - Distributed Database Concepts (pdf)
Chapter 24 - NOSQL Databases and Big Data Storage Systems (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)
Chapter 28 - Data Mining Concepts (pdf)
Chapter 29 - Overview of Data Warehousing and OLAP (pdf)
Chapter 30 - Database Security (pdf)
Other Materials
Chapter 4 - Enhanced Entity-Relationship (EER) Modeling (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)