Course Contents
Database Management systems
1. Introduction:
1.1 Approach to Data Management
1.2 Advantages of Database Systems
1.3 Functions of DBMS
1.4 Role of a Database Administrator
1.5 Types of Database Systems
1.2 Advantages of Database Systems
1.3 Functions of DBMS
1.4 Role of a Database Administrator
1.5 Types of Database Systems
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