ORACLE 9i Online TrainingCourse Duration - 35hrs   DBMS Concepts of DBMS Introduction Importance and Need Database Models and Normalization Relational Object ormalization Techniques  Introduction to RDBMS Concepts of RDBMS Introdution Comparision with DBMS COOD Rules Normalization Revisited Concepts of ORDBMS & OODBMS Introduction to ORDBMS Introduction to OODBMS Comparision and analysis  Structured Query Language(SQL) Introduction to SQL Predefined Data Types Introduction to database objects Table,View  Commands in SQL Data Defination Language(DDL) Data Manipulation Language(DML) Data Control Language(DCL) Transaction Control Language(TCL) Database Security and Privileges(DCL)  Working with DDL,DML,TCL Commands Operators Conditional,Logical,Comparison,SET Functions Date,Number,Character,String,Group,Group by,Having clause Transformation Functions DECODE,TRANSLATE NVL,NVL2(9i) Aggregate Functions  Integrity Constraints Different Types of Integrity Constraint Use of Integrity Constraint in table  Joins Usage of Joins Different Types of Joins Equi Join Cartesian join Self Join Outer join  Sub Queries Need of Sub Queries Nested Sub queries Co-related Sub Quries Flash Back Queries (9i)  View Importance of views Creating,Manipulating Views Materialized views(9i)  Working with database objects Sequences and synonyms Index,Cluster,Creating cluster table  Using External Tables(9i) System Privileges Table Privileges  Locks and SQL Plus editor commands  PL/SQL Introduction to PL/SQL Advantage of PL/SQL Data Types in PL/SQL Variables and Constants Referencing NON-PL/SQL Variable Using built in Functions Conditional and iterative Statements SQL in PL/SQL Composite Data Types Cursors Exceptions:-Predefined ,User Defined Records and PL/SQl table types  Advanced PL/SQL Introduction to Triggers Types of Triggers : - Row level,Statement Level Before and After ,Instead of Triggers Procedures,Functions in PL/SQL User Defined Packages Dropping triggers,Procedures,Functions