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.
Reference Book:
Ivan Bayross, “Commercial Application Development using Oracle Developer 2000”,BPB Publication, 2004 . Ivan Bayaross , “Oracle – 7 the complete reference”, B. P. B. Publications 1995
Text Book:
David Loctman, “Developing Personal Oracle for windows 95 Application “, SAMS PUBSHLING, 2nd Edition