Contents

1.Relational Database Design Using PLSQL

1. Introduction to PL/SQL

2. PL/PgSQL

3. Controlling the Program Flow, Conditional Statements, Loops

4. Stored Procedures

5. Stored Functions

6. Handling Errors and Exceptions

7. Cursors

8. Triggers

2. Transaction Concepts and Concurrency Control

1. Introduction

2. Describe a Transaction, Properties of Transaction, State of the Transaction

3. Executing Transactions Concurrently Associated Problem in Concurrent Execution

4. Schedules, Types of Schedules, Concept of Serializability, Precedence Graph of Serializability

5. Ensuring Serializability by Locks, Different Lock Modes,2PL and its Variations

6. Basic Timestamp Method for Concurrency, Thomas Write Rule

7. Locks with Multiple Granularity, Dynamic Database Concurrency (Phantom Problem)

8. Timestamps Versus Locking

9. Deadlock and Deadlock Handling-Deadlock Avoidance (wait-die, wound-wait)

10.Deadlock Avoidance (Wound-Wait, Wait-die)

11.Deadlock Detection and Recovery (Wait For Graph)

3. Database Integrity and Security Concepts

1. Introduction

2. Domain Constraints 2

3. Referential Integrity

4. Introduction to Database Security Concepts

5. Methods of Database Security

6. Use of Views in Security Enforcement

7. Overview of Encryption Technique for Database

8. Statistical Database Security

4. Crash Recovery

1. Introduction 2

2. Failure Classification

3. Recovery Concepts

4. Log Based Recovery Techniques (Deferred and Immediate Update)

5. Checkpoints, Relationship between Database Manager and Buffer Cache. Aries recovery Algorithm

6. Recovery with Concurrent Transactions (Rollback, Checkpoints, Commit)

7. Database Backup and Recovery from Catastrophic Failures

5. Other Databases

1. Introduction to Parallel and Distributed Databases

2. Introduction to Object Based Databases

3. XML databases

4. NoSQL Databases

5. Multimedia Databases

6. Big Data Databases