DBMS

• Database Management System (DBMS) 

• E R MODEL 

• DBMS User  

• SQL

• Aggregate Function  

• Joining Tables and SQL Constraints 

• File Structures (B and B+ Trees)  

• Database Design 

• Normalization 

• Transactions  

• Concurrency Control with Locks  

• Lock Types  

• Time Stamp Ordering Protocols  

• Functional Dependency (FDs)  

• Decomposition  

• Type of Schedule  

• B+ Tree  

• Strict Recoverable  

• Database Security 

• Countermeasures: Computer-Based Controls 

• DBMSs abd Web Security  

• Software Depression and DB system development life cycle 

• Building Conceptual Data Model 

• Building Logical Data Model 

• Fact - Finding Techniques 

• Relational Model 

   

  Books :

   Microsoft SQL Server 2008 Administrator's Pocket Consultant 

  Oracle Database 12c Security Cookbook Paperback – Import, 6 Jan 2016 by Zoran Pavlovic (Author), Maja Veselica (Author)