Data base Management System and RDBMS – Normalization – Oracle terminology –Database Connection – Creating tables – The Basics of SQL: SQL Grammar.

Data manipulation – data types – Insertions, updation and deletion operation – SELECT Command – Where clause- modifying structure – views – Sequences, SQViewsL & Plus commands.

Manipulating strings – Dealing with Dates - handling Numbers – defining table and Column constraints - Table Indexes.

Sophisticated queries – Builtin group functions – The join operation, views, sequences and synonyms.

Transaction – the Basics of PL/SQL creating and using stored procedures, Functions and Packages – Retrieving Data with cursors. Enforcing Business Rules with Database triggers.