Database Management System PPT , PDF , Lecture Notes

Database Management System

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)