Databse Managment System including SQL Server/MY SQL.

1. About DBMS

2. Creating DATABASE.

3. Writting queries

4. Stored procedures/Views/Trigeers

5. SQL Joins

6. Normalisation

7. Transactions

8. Database Backup/Restore

9. Other

Introduction to Databases and Transactions What is database system, purpose of database system, view of data, relational databases, database architecture, transaction management

Relational database model: Logical view of data, keys, integrity rules, Relational Database design: features of good relational database design, atomic domain and Normalization

Constraints, types of constrains, Integrity constraints, Views: Introduction to views, data independence, security, updates on views, comparison between tables and views SQL: data definition, aggregate function, Null Values, nested sub queries, Joined relations. Triggers.

Transaction management and Concurrency Control Transaction management: ACID properties, serializability and concurrency control, Lock based concurrency control (2PL, Deadlocks), Time stamping methods, optimistic methods, database recovery management.

PL-SQL: Beginning with PL / SQL, Identifiers and Keywords, Operators, Expressions, Sequences, Control Structures, Cursors and Transaction, Collections and composite data types, Procedures and Functions, Exceptions Handling, Packages, With Clause and Hierarchical Retrieval