RDBMS (BSC-IT 5th)

An Overview of DBMS and DB Systems Architecture : Introduction to Database Management

systems; Data Models; Database System Architecture; Relational Database Management

systems; Candidate Key and Primary Key in a Relation; Foreign Keys; Relational Operators; Set

Operations on Relations; Attribute domains and their Implementation.

Interactive SQL : SQL commands ; Data Definition Language Commands; Data Manipulation

Language Commands; The Data types a cell can hold; insertion of data into the tables; Viewing of

data into the tables; Deletion operations; updating the contents of the table; modifying the

structure of the table; renaming table; destroying tables; Data Constraints; Type of Data

Constraint; Column Level Constraint; Table Level Constraint; Null value Concepts; The UNIQUE

Constraint; The PRIMARY constraint; The FOREIGN key constraint; The CHECK Constraint;

Viewing the User Constraints;

Viewing The Data : Computations on Table Data; Arithmetic Operators; Logical Operators;

Comparison Operators; Range Searching; Pattern Searching; ORACLE FUNCTIONS; Number

Functions; Group Functions; Scalar Functions; Data Conversion Functions; Manipulating Dates

in SQL ; Character Functions;

Sub queries and Joins : Joins; Equip Joins; Non Equip Joins; Self Joins; Outer Joins; Sub

Queries; Correlated Queries; Using Set Operators:- Union , Intersect; Minus ;

Views and Indexes : Definition and Advantages Views; Creating and Altering Views; Using

Views; Indexed Views; Partitioned views; Definition and Advantages of Indexes; Composite Index

and Unique Indexes; Accessing Data With and without Indexes; Creating Indexes and Statistics.

Introduction to PL/SQL : Advantage of PL/SQL; The Generic PL/SQL Block; The Declaration

Section; The Begin Section; The End Section; The Character set; Literals; PL/SQL Data types;

Variables; Constants; Logical Comparison; Conditional Control in PL/SQL; Iterative Control;

Advanced PL/SQL : Types of Cursors; Implicit Cursor; Explicit Cursor; Explicit Cursor attributes;

Cursor For Loop; Parameterized Cursor; Error Handling in PL/sql ;Internal Exceptions; User

Defined Exceptions

Database Objects : Sequences, Creating Sequences; Referencing Sequences; altering a

Sequence; Dropping a Sequence, Stored Procedures and Functions:- Advantages of using a

Procedure or Function; Procedure Versus Functions; Creating stored Procedures and Functions;

Parameters to Procedures and Functions; Deleting a Stored Procedure or a Functions;

Packages:- Components of a Package; Package Objects; Private and Public ; Package state;

Package Dependency; Triggers:- Use of Database Triggers; Database Triggers V/s Procedures;

Database Triggers V/S Integrity constraints; RAISE_APPLICATION_ERROR PROCEDURE;

Types of Triggers:- Row Triggers, statement Triggers; Before V/S After Triggers; Deleting a

Trigger;