SQL * PLUS AND DATA DEFINITION COMMANDS

Definition of SQL and SQL* PLUS

The Create Object Commands

The alter, Drop Commands

Referential integrity and other constraints 

 DATA MANIPULATION COMMANDS

Insert, Select, Update and delete commands 

Relating data through join concepts

Joining tables

Equi and non equi joins

Inner and outer joins

Sub queries and their usage

Multiple sub queries

Correlated sub queries 

ARITHMATIC AND GROUP EXPRESSIONS

Usage of arithmetic operations in SQL*PLUS

Usage of arithmetic functions in SQL*PLUS

Usage of group functions in SQL*PLUS

Date Operations

Usage of NULL values 

VIEWS AND SYNONYMS

Creation of Views

Querying of Views

Creation of Synonyms 

TRANSCTIONAL CONTROL STATEMENTS

Commit, Rollback and Save points 

SHARING, COLUMN FORMATS and INDEXES and SEQUENCES

Sharing and deadlocks

Formatting commands in SQL*PLUS

Definition of indexes and sequences

Oracle PL/SQL:

COMPONENTS OF PL/SQL

Relationship between SQL and PL/SQL

Advantages of PL/SQL

Attributes and Expressions in PL/SQL

LOOPs and Conditional statements in PL/SQL 

ERROR HANDLING AND CURSORS IN PL/SQL

Definitions of Exceptions

Exception handling in PL/SQL

Cursor  management in PL/SQL

PL/SQL Execution environments

Transaction handling 

ADVANCED FEATURES

Subprograms and procedures

Stored procedures and functions

Triggers

Packages

Extra Topics:   

Administering Database Users

Securing the Oracle Databases

Detecting and Recovering from Database Corruption

Normalization

Data Warehousing and Data Mining