Oracle

Introduction to DBMS

Introduction to RDBMS

Sub Language Commands

Introduction to SQL Database Object

Built-in Functions

Grouping the Result of a Query

Working with Integrity Constraints

Querying Multiple Tables (Joins)

Working with Sub Queries

Working with DCL

TCL Commands

Maintaining Database Objects

VIEWS in Oracle

Working with Sequences

Working with Synonyms Working with Index and Clusters

PL-SQL (Procedure Language – SQL)

Advanced PL/SQL

Functions in PL/SQL

Packages in PL/SQL

EXCEPTIONS in PL/SQL

Database Triggers in PL/SQL

File Input/Output

Using LOBS

Using Collections

DBA CONCEPTS .