Database Management systems

1. Introduction:


2. The Internal Level
2.1 Clustering
2.2 Indexing
2.3 Hashing

3. The Relational Model
3.1 Relational Databases: Terminology
3.2 Properties of Relations
3.3 Integrity Rules
3.4 Relational Algebra Operators

4. SQL
4.1 Overview
4.2 Data Manipulation Language
4.3 Data Definition Language
4.4 Data Control Language

5. Recovery and Concurrency

5.1 Transaction
5.2 Recovery from System Failures
5.3 Recovery: An Example
5.4 Concurrency
5.5 Locking
5.6 Deadlocks

6. Query Optimization
6.1 Overview
6.2 An Example of Query Optimization
6.3 The Query Optimization Process
6.4 Query Optimization in Oracle