Syllabus of DataBase Management System

Introduction :

• Database and Database Users. 
• Characteristics of the Database Approach. 
• Different people behind DBMS. 
• Implications of Database Approach. 
• Advantages of using DBMS. 
• When not to use a DBMS.

Database System Concepts and Architecture:

• Data Models. 
• Schema and Instances.
• DBMS Architecture and Data Independence. 
• Database languages and interfaces. 
• The Database system Environment. 
• Classification of Database. 
• Management Systems.

Data Modeling Using the Entity-Relationship Model:

• High level Conceptual Data Models for Database Design with an example., Entity types, Entity sets,Attributes, Keys, ER Model Concepts, Notation for ER Diagrams,Proper naming of Schema Constructs, Relationship types of degree higher than two.

 Record Storage and Primary File Organization:

• Secondary Storage Devices.
• Buffering of Blocks.
• Placing file Records on Disk.
• Operations on Files.
• File of unordered Records (Heap files).
• Files of Ordered Records (Sorted files).
• Hashing Techniques and Other Primary file Organization. 

Functional Dependencies and Normalization for Relational Databases :

• Informal Design Guidelines for Relational Schema.
• Functional Dependencies.
• Normal Forms Based on Primary Keys.
• General Definitions of Second and Third Normal Forms.
• Boyce–Codd Normal Form. 

 Relational Data Model and Relational Algebra:

• Relational Model Concepts.
• Relational Model Constraints and Relational Database Schema.
• Defining Relations.
• Update Operations on Relations.
• Basic Relational Algebra Operations.
• Additional Relational Operations.
• Examples of Queries in the Relational Algebra.
• Relational Database design Using ER– to–Relational Mapping.

Relational Database Language:

• Data definition in SQL.
• Queries in SQL, Insert.
• Delete and Update Statements in SQL.
•  Views in SQL, Specifying General Constraints as Assertions, Specifying indexes, Embedded SQL.

PL / SQL:

• Introduction
• Exceptions & Cursor Management.
• Database Triggers.
• Functions.
• Procedures and packages.

Transaction Processing Concepts:

• Introduction.
• Transaction and System Concepts.
• Desirable properties of transaction.
• Schedules and Recoverability.
• Serializability of Schedules.
• Transaction Support in SQL.
• Locking Techniques for Concurrency Control.
• Concurrency Control based on time stamp ordering.
• Optimistic Concurrency control techniques.
• Using locks for Concurrency Control in Indexes. 

"Very Useful tutorial for Practical Part"