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