1. What is Database?
2. What is Database System?
3. Different types of Database Models
4. Different types of Relations
5. E.F.CODD’S Rules
6. RDMBS
7. ORDMBS
8. Different version of Oracle
9. Features of Oracle

SQL

1. What is SQL?
2. Role of SQL in RDBMS
3. What is SQL * PLUS
4. Types of PLUS commands

Data types of Oracle 9i
Naming rules in Oracle 9i

SQL commands

1. Data Definition Language (DDL) Commands
2. Create, Alter and Drop
3. System Defined Tables
4. Data Diction Tables
5. What is Tables
6. What is Schema

DML Commands Insert

1. Insertion of data
2. Copying of rows
3. from table to table

Select                                                                   Top

1. Data Projection

Order By clause

2. Data Sorting

Distinct Clause

3. Eliminating duplicate values

Where Clause

4. Data Restriction

Operators

5. Arithmetic Operators
6. Relational Operators
7. Relational Negation Operators
8. Logical Operators
9. Set Operators

Integrity Constraints

1. What is Data Integrity?
2. What is Data Redundancy?
3. What is Data Inconsistenancy
4. Normalization
5. What is Constraint

Different type of Constraints                                    Top

1. Domain Integrity Constraints
2. Entity Integrity Constraints
3. Referential Integrity Constraints

Joins

1. What is Join
2. Cartesian Join
3. Inner Join
4. Equi Join
5. Non- Equi Join
6. Self Join
7. Outer Join
8. Left Outer Join
9. Right Outer Join
10. Full Outer Join
11. Natural Join
12. Cross Join
13. Using Clause
14. On Clause

Sub Queries

1. Simple Sub Queries
2. Sub queries on multiple tables
3. Co-relation Sub Query

Functions
Single Row Functions

1. Numeric Functions
2. Character Functions
3. Data Functions
4. Data conversion Function
5. Miscellaneous Functions
6. Group Functions

Update                                                            Top

1. Data Updating
2. Updating data using sub queries

Delete

3. Deleting data
4. Deleting data using sub queries
5. Deleting data using join

Transaction Control Language (TCL)

1. Commit
2. Roll back
3. Save Point

Data Control Language (DCL) Commands

1. What is privilege?
2. Granting Privilege
3. Denying Privilege
4. What is role

Database Objects
Index

1. Unique Index
2. Non-Unique index
3. Bitmap Index

Cluster Sequence                                                     Top

1. Pseudo columns

View

2. Importance of View
3. Forced view
4. Rules for DML on Views

Synonym

1. Private synonym
2. Public Synonym

Object Technology

1. Objects on Technology
2. Abstract Data Types

Data Partitions

1. Type of Partitions
2. Range partition
3. Hash partition
4. Index partition

PL/SQL

1. Introduction to PL/SQL
2. Advantages of PL/SQL
3. Architectures of PL/SQL
4. Structure of PL/SQL
5. Data Types
6. Variables/Constants
7. Assignment Operator
8. Debugging Statement
9. Comment Mechanism

Flow Control Statements                                          Top

1. If….else…
2. Nested if …else
3. Ladder if … elsif…
4. Exit
5. Goto
6. Raise
7. Iterative Statements
8. While Loop
9. Simple Loop
10. For Loop
11. Reverse For Loop

Embedded SQL

1. Use of Select Statement
2. Attribute Data Types
3. %type
4. %Rowtype
5. Exceptions
6. What is Exception
7. Predefine Exception
8. User defined Exception
9. Raise
10. Raise
11. Pragma

Cursor Management

1. What is Cursor
2. Importence of Cursor
3. Implict Cursor
4. Explicit Cursor

Cursor Declaration
Cursor Attributes
Cursor For Loop
Cursor Parameters

5. Static Cursor
6. Dynamic Cursor
7. Refcursor

Sub Programs                                                          Top

1. Types of PL/SQL Blocks
2. Procedure
3. Function

Packages
Database Trigger

1. What is trigger
2. Importance of trigger
3. Instead of trigger

PL/SQL TABLES
Advanced Concepts
Oracle database Architecture