RDBMS (B-TECH computer science engineering 6th)

 RELATIONAL DATA BASE MANAGEMENT SYSTEMS – II 

Data base system architecture, data independence, storage structures, data representation, indexing, relational data structure, relations, attributes, keys, embedded SQL, Relational Algebra, Query by example, relational calculus, normalization & normal forms, functional dependence, over view of security, integrity, recovery, backup, etc. [25 % ]

SQL, Transact-SQL, PL SQL, SQL *PLUS, Managing Database and Queries: Creating, defining and modifying Table structure, Transact-SQL PLUS and substitution of variables. [35%]

Introduction to SQL Server and Oracle Server [5%]

Indexes [5%]

Views [5%]

Packages [5%]

Triggers And Stored Procedures [10%]

Cursors [5%]

Control structure [5%]