Oracle Sql Plsql

INTRODUCTION
Introduction to Oracle
TwoThree tier architecture
DBMS Concepts
Definition of Database
Database Management System
Database models and Relations
Relational Database management System
Dr. E.F. Codd Rules
Database Design
Entity Relationship Diagram
Normalization
Features of Oracle
SQL
Introduction to SQL
Features of SQL
SQL Sub Languages
Data Definition Language
Data types
Constraints
Data Manipulation Language
Data Retrieval Language
Operators
Data Control Language
Transaction Control Language
Functions
Aggregate functions
Character functions
Date functions
Arithmetic functions
General functions
Joins
Equi joins
Non equi joins
Self joins
Outer joins
Set operators
Cartesian joins
Full outer joins
Natural joins
Inner joins
Cross joins
Sub queries
Correlated Subqueries
Large Database objects
Views
Sequences
Synonyms
Indexes
Clusters
Roles
SQL * Plus commands
PLSQL
Introduction to PLSQL
Architecture of PLSQL
Advantages of PLSQL
PLSQL Block structure
Variables and constants
Attributes
Control statements
If statement
If else statement
Multiple elsif statement
Nested if statement
Loops
For statement
While statement
Cursors
Explicit cursors
Implicit cursors
Cursor for loop
Parameterized cursors
Ref cursors
Composite datatypes
PLSQL Tables
PLSQL Records
Exception handling
Sub Programs
Procedures
Functions
Using mode parameters
Packages
Pragma restrict_references
Database triggers
Instead of triggers
UTL Files
New and improved datatypes
Concept of object oriented
Programming
Object relational features
Object tables
Collections
Nested tables
Varrays
Partitioning tables
Maintaining partitions
Oracle 9i features
J2EE and XML Applications
Oracle 10g11g features