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, SWL & Plus commands

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

Sophisticated queries – Builtin group functions – The joint 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.