1. Database system architecture : Data Abstraction, Data Independence, Data Definition Language (DDL), Data Manipulation Language (DML). (Chapter - 1) 2. Data models : Entity-relationship model, network model, relational and object oriented data models, integrity constraints, data manipulation operations. (Chapter - 2) 3. Relational query languages : Relational algebra, Tuple and domain relational calculus, SQL3, DDL and DML constructs, Open source and Commercial DBMS - MYSQL, ORACLE, DB2, SQL server. (Chapter - 3) 4. Relational database design : Domain and data dependency, Armstrong's axioms, Normal forms, Dependency preservation, Lossless design. (Chapter - 4) 5. Query processing and optimization : Evaluation of relational algebra expressions, Query equivalence, Join strategies, Query optimization algorithms. (Chapter - 5) 6. Storage strategies : Indices, B-trees, hashing. (Chapter - 6) 7. Transaction processing : Concurrency control, ACID property, Serializability of scheduling, Locking and timestamp based schedulers, Multi-version and optimistic Concurrency Control schemes, Database recovery. (Chapter - 7) 8. Database security : Authentication, Authorization and access control, DAC, MAC and RBAC models, Intrusion detection, SQL injection. (Chapter - 8) 9. SQL concepts : Basics of SQL, DDL,DML,DCL, structure - creation, alteration, defining constraints - Primary key, foreign key, unique, not null, check, IN operator, aggregate functions, Built-in functions - numeric, date, string functions, set operations, sub-queries, correlated sub-queries, join, Exist, Any, All , view and its types., transaction control commands. (Chapter - 9) 10. PL/SQL concepts : Cursors, Stored Procedures, Stored Function, Database Triggers. (Chapter - 10)
