It will cover all the GATE concepts of DBMS and you can expect a deep understanding of database from this course. It will cover 

Unit–I

Introduction to Databases and TransactionsWhat is database system, purpose of database system, view of data, relationaldatabases, database architecture, transaction management,

Unit-II

Data ModelsThe importance of data models, Basic building blocks, Business rules, The evolutionof data models, Degrees of data abstraction.

Unit-III

Database Design ,ER-Diagram and Unified Modeling LanguageDatabase design and ER Model:overview, ER-Model, Constraints, ER-Diagrams, ERDIssues, weak entity sets, Codd’s rules, Relational Schemas, Introduction to UMLRelational database model:Logical view of data, keys, integrity rules.Relational Database design: features of good relational database design, atomicdomain and Normalization (1NF, 2NF, 3NF, BCNF).

Unit-IV

Relational Algebraand CalculusRelational algebra: introduction, Selection and projection, set operations, renaming,Joins, Division, syntax, semantics. Operators, grouping and ungrouping,relationalcomparison.Calculus: Tuple relational calculus, Domain relational Calculus, calculus vs algebra,computational capabilities.

Unit-V

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

Unit-VI

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