ORACLE 9I DATABASE TRAINING

Introduction to Oracle 9i SQL

INTRODUCTION:

LESSON 1 : Writing Basic SQL Select Statements

LESSON 2 : Restricting and Sorting Data

LESSON 3 : SQL - Functions

LESSON 4 : Displaying Data From Multiple Tables

LESSON 5 : Group Functions

LESSON 6 : Sub Queries

LESSON 7 : Producing Readable Output with iSQL*Plus
LESSON 8 : Data Manipulation Language (DML)
LESSON 9 : Creating and Managing Tables
LESSON 10 : Table Constraints

LESSON 11 : Creating Views

LESSON 12 : Other Database Objects
LESSON 13 : Controlling User Access
LESSON 14 : Using Set Operators
LESSON 15 : Enhancement to the GROUP BY Clause
LESSON 16 : Advanced Subqueries