Oracle Database & Serval Database

1:CONCEPTS of Oracle - Introduction to the database management system, Types of Database, The Relational Database Management System, Normalization, Entity Relationship Diagram, Client / Server Architecture Model

2:SQL & SQL PLUS in Oracle - Introduction to SQL , Classification of SQL Statement ( DDL, DML, DCL ), SQL Operator and Functions, The SQL Select Statement and Types of Queries, Different Set of Operators and Joins, What is SQL Plus, Creating Reports using SQL Plus

3:PL / SQL in Oracle - Introduction to PL/ SQL, The PL/SQL Block Construct, Using Variables and SQL statement in the PL/SQL BLOCK , PL/SQL Constructs like If, Elseif, Elseif, Else, Endif, Loop...

4: End Loop , While Loop etc, Working with Cursor, Creating and Using Shared Functions, Procedures and Packages, Writing Event Driven Database Level Triggers, Using Oracle Packages

5:INTRODUCTION TO OBJECT ORIENTED DBMS in Oracle

6:NEW DATATYPES in Oracle - Lob's ( Large Objects), Type of Lob's,

7: Creating and Managing Tables using Lob's, Using DBMS_LOB, Packing to work with Lob's

8:ORACLE OBJECT OPTION The Objects Data Type,:

9: Create Type Statement, Creating Tables Based on Object Data Types, Using SQL AND PL/SQL Statement to work with object Table.

10:COMPOSITE DATA TYPES in Oracle

11:OBJECT VIEWS in Oracle