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...