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 (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)
