Database Fundamentals

Topic	Download
Fundamental Database Concepts	lecture slides (Powerpoint) lecture slides (PDF)
Entity-Relationship Diagrams (Mail-order schema added as last slide)	lecture slides (Powerpoint) lecture slides (PDF)
Enhanced Entity-Relationship   Diagrams	lecture slides (Powerpoint) lecture slides (PDF)
The Relational Data Model	lecture slides (Powerpoint) lecture slides (PDF)
ER to Relational Translation	lecture slides (Powerpoint) lecture slides (PDF)
The Relational Algebra	lecture slides (Powerpoint) lecture slides (PDF)
More Relational Algebra	lecture slides (Powerpoint) lecture slides (PDF)
SQL Queries	lecture slides (Powerpoint) lecture slides (PDF)
Exam 1	See Exam page
SQL: Data Definition and Data   Manipulation Installing MySql with XAMPP	Lecture Slides (PDF) Lecture Slides (Powerpoint) MySql installation and adminstration notes SQL to build and populate employee database (text)
Views, Semantic Constraints and   Triggers	Lecture Slides (PDF) Lecture Slides (Powerpoint)
Schema Design and Normalization	Lecture Slides (PDF) Lecture Slides (Powerpoint)
SQL Application Interfaces	Lecture Slides (PDF) Lecture Slides (Powerpoint) Sample Code (Java and PHP)
Physical Storage	Lecture Slides (PDF) Lecture Slides (Powerpoint)
File Organization	Lecture Slides (PDF) Lecture Slides (Powerpoint)
Review for Exam 2	See Exam page
Static Indexes	Lecture Slides (PDF) Lecture Slides (Powerpoint) Exercises (PDF)
Dynamic Indexes	Lecture Slides (PDF) Lecture Slides (Powerpoint) Exercise (PDF)
Query Processing	Lecture Slides (PDF) Lecture Slides (Powerpoint) Exercise (PDF)
Query Processing: Select and Join Continued exercise from Tuesday	Lecture Slides (PDF) Lecture Slides (Powerpoint)
Security	Lecture Slides (PDF) Lecture Slides (Powerpoint) MySql Access Control Example (PDF)
Exam 3
Transactions and Serializability	Lecture Slides (PDF) Lecture Slides (Powerpoint) Serializability Exercises (PDF)
Recoverability Classes Concurrency Control	Lecture Slides (PDF) Lecture Slides (Powerpoint) Exercises (PDF)
Concurrency Control Recovery	Lecture Slides (PDF) Lecture Slides (Powerpoint) review: Transactions, CC, Recovery (PDF) Recovery in SQL Server (PDF)
Object-Oriented Databases Object-relational Databases	Lecture Slides (PDF) Lecture Slides (Powerpoint) Additional Notes on ODMG (PDF) Advanced Topics (PDF) Advanced Topics (Powerpoint)

DATABASE MANAGEMENT SYSTEM PPT SLIDES

INSTRUCTOR: Dr. Khamis Omar

DBMS SLIDES

1.  Introduction                                
2. Entity-Relationship Model                                
3. Relational Model                                
4. SQL                                
5. Other Relational Languages
6. Integrity and Security                                
7. Relational Database Design                                
8. Object-Oriented Databases                                
9. Object-Relational Databases
10. XML                                
11. Storage  and File Structure                                
12. Indexing and Hashing                                
13. Query Processing                                
14. Query Optimization                                
15. Transactions                                
16. Concurrency Control                                
17. Recovery System                                
18. Database System Architectures                                
19. Distributed Databases                                
20. Parallel  Databases                                
21. Application  Development and Administration                                
22. Advanced Querying and Information Retrieval
23. Advanced  Data Types and New Applications                                

Appendixes             :

1. Network  Model                                
2. Hierarchical   Model                                
3. Advanced Normalization Theory

Course Title: Database Management Systems

Branch: Computer science and Engineering

Author: Raghu Ramakrishnan and Johannes Gehrke .

Text Books Required: Database Management Systems, Third Edition, by Raghu Ramakrishnan and Johannes Gehrke .

Download Slides here:

I Foundations

• Chapter 1: Introduction (postscript)
• Chapter 2: ER Model and Conceptual  Design (postscript)
• Chapter 3: The Relational  Model and SQL DDL (postscript)
• Chapter 4: Relational Algebra (postscript) and Relational Calculus     (postscript)
• Chapter 5: SQL (postscript)

II Applications

• Chapter 6: Database Application Development
• Chapter 7: Database-backed Internet Applications

III Systems

• Chapter 8: Overview of Storage and Indexing (postscript)
• Chapter 9: Data Storage(postscript)
• Chapter 10: Tree Indexes (postscript)
• Chapter 11: Hash Indexes (postscript)

IV Systems

• Chapter 12: Overview of Query Evaluation (postscript)
• Chapter 13: External Sorting (postscript)
• Chapter 14: Evaluation of Relational Operators: First     part (joins)  (postscript)     and second     part (other operators) (postscript)
• Chapter 15: A Typical     Relational Optimizer (postscript)

V Systems

• Chapter 16: Overview of Transaction Management
• Chapter 17: Concurrency Control
• Chapter 18: Recovery

VI Applications

• Chapter 19: Schema Refinement, Functional Dependencies, Normalization
• Chapter 20: Physical     Database Design, Database Tuning
• Chapter 21: Security and Authorization

VII Advanced Topics

• Chapter 22: Parallel     Database Systems. Distributed Database Systems.
• Chapter 23: Data Warehousing and Decision Support.     Views.
• Chapter 24: Object Database Systems
• Chapter 25: Deductive Databases
• Chapter 26: Data Mining
• Chapter 27: Information Retrieval and XML Data Management. Slides come in     five parts:

• Introduction to IR  Systems: Supporting Boolean Text Search
• Computing  Relevance, Similarity: The Vector Space Model
• Web Search Engines
• Introduction to Semistructured Data and XML
• XQuery
• Chapter 28: Spatial Databases