Database Management Systems   Course Contents   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   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   7. References       Home : About Us : Courses : Photos : Contact Us Copyright © 2009 Tata Consultancy Services Limited.