Training on ORACLE 9i

Chapter 01 Fundamentals of ORACLE

• History of ORACLE

• What is oracle?

• Why oracle

• Introduction to Oracle 9i

Chapter 02 Setting up Environment

• Checklist for Installation

• Installation Process

• Trouble Shooting

• Opening application

Chapter 03-Introduction to Database

• What is Database?

• Types of database

• Oracle Architecture

• RDBMS

• ORDBMS

Chapter 04-SQL Basics

• Introduction to sql

• Data types

• Operators and their precedence

• How to open sql * plus for the first time

• Simple select statement

Chapter 05-Data definition Language

• Simple table creation

• Altering a table

• Table creation with sub query

• Constraints in table creation

• Renaming and removing a table

Chapter 06-Data Manipulation language

• Data insertion

• Copying rows

• Updating a table

• Transaction process in table

• Data insertion from other table

• Creating report

Chapter 07-Functions

• Character function

• Date function

• Conversion functions

• Transformation functions

• GROUP function

• Group by and having

• Set operators

Chapter 08- Sub queries and special functions

• If then else

• Decode

• Case

• Sub queries

• Advanced sub queries

Chapter 9-joins, sub queries and user access

• CROSS JOIN or Cartesian product

• NATURAL join or EQUI join

• Outer join (LEFT,RIGHT and FULL)

• Controlling and managing user access

Chapter 10-Managing Schema objects

• External table

• index

• view

• Sequence and synonyms

• Accessing remote Data

Chapter 11-PL SQL

• Introduction to PL/SQL

• DML statements in pl/sql

• Conditions and loops

• PL/SQL Records

• PL/SQL Table

Chapter 12-Cursor, trigger and Handling exceptions

• Explicit and Implicit cursor

• cursor and cursor for loop

• Advanced cursor

• Triggers

• Types of Triggers

• Exception block in pl/sql

Chapter 13-Procedures, functions and packages

• Procedure creation

• Advanced usage of procedures

• Difference: procedure and function

• Function creation

• Package description

• Advanced package concepts

Chapter 14- introduction to data base administration

• Oracle architecture

• Instance

• Oracle process

• Tools for DBA

• Data files

• Control and redo log files