Home » Other » Test » need your valuable suggestions
need your valuable suggestions [message #279996] Mon, 12 November 2007 04:29 Go to next message
Messages: 4
Registered: November 2007
Location: chennai
Junior Member

Is this list of lessons are enough for a beginners[ 2 votes ]
1. yes 2 / 100%
2. no 0 / 0%
3. no comments 0 / 0%

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



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

[Updated on: Mon, 12 November 2007 04:33]

Report message to a moderator

Re: need your valuable suggestions [message #279998 is a reply to message #279996] Mon, 12 November 2007 04:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68454
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You succeeded the test.
Now if it is a real post you have to put it in MarketPlace forum.

Re: need your valuable suggestions [message #280006 is a reply to message #279998] Mon, 12 November 2007 04:53 Go to previous message
Messages: 21765
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd rather put it into the Training forum, though ...

Hari-2006, you don't have to write a new topic if this is a "real" one - moderators can move it for you (just say so).

[EDIT] Nope, I believe you are right, Michel - I should have read it more carefully. Also, Hari-2006 has already opened a new topic in the Marketplace forum.
It seems I've wasted some space here for nothing ...

[Updated on: Mon, 12 November 2007 04:56]

Report message to a moderator

Previous Topic: First Post
Next Topic: Testpoll etc
Goto Forum:

Current Time: Tue Jun 06 14:42:04 CDT 2023