Home » Other » Marketplace » oracle training for begineers
oracle training for begineers [message #280001] Mon, 12 November 2007 04:40 Go to next message
hari-2006
Messages: 4
Registered: November 2007
Location: chennai
Junior Member
hi all ..

Here, i have given the lesson list for oracle 9i. This lesson list is created for the layman who is new to oracle.

I want my viewers to write comments about this list. I will post the content in upcoming posts.

your comments are very important for me to present the content very effective..


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
Re: oracle training for beginners [message #280101 is a reply to message #280001] Mon, 12 November 2007 08:33 Go to previous message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
I would suggest putting this on the wiki so people can contribute to it. In fact, most of your topics already have wiki pages.
Previous Topic: market for oracle apps dba - seniors please advice
Next Topic: Opening for Oracle Financial Consultant - Dubai
Goto Forum:
  


Current Time: Wed Dec 25 14:03:04 CST 2024