Oracle 10g/11g Course Details

The Oracle database environment

Basic SQL*PLUS commands

Basic SELECT Statement

Ordering the output

Conditional retrieval of data

Working with variables

Pseudo columns and functions

Using non-character function 

Using the SET operators 

Aggregating data using group functions

Creating Sub queries 

 

Enhancing groups function 

Transaction Control Languag 

Processing hierarchies

Data Manipulation Language

Data Definition Language

Using Declarative Constraints

Database Security

Improving query performance 

PL/SQL

Blocks

Variables

Control structures

Cursors

Printing Values to Screen

Procedures

 

Functions

 

Package

Design Tips and Techniques

Triggers

Dynamic SQL

Oracle Supplied packages

Collection data types