Oracle (SQL & PL/SQL)

• What is Database?
• What is Database System?
• F.CODD’s Rules
• RDBMS
• ORDBMS
• Difference Between DBMS, RDBMS & ORDBMS

2.SQL

• What is SQL?
• DDL Commands
• Create, Alter, Drop
• Truncate, Rename
• DML Command – Insert

SQL SELECT statements

• What is SQL?
• DDL Commands
• Create, Alter, Drop
• Truncate, Rename
• DML Command – Insert

Constraints

• Primary Key Constraint
• Unique Constraint
• Not Null Constraint
• Foreign Key Constraint
• Check Constraint
• Cascade Constraints

Joins

• What is a Join?
• Cartesian Join
• Equi Join
• Non – Equi Join
• Self Join
• Outer Join
• Left Outer Join
• Right Outer Join
• Full Outer Join
• Pseudo Columns

Functions

• Numeric Functions
• Character Functions
• Date Functions
• Conversion Functions
• General Functions
• Aggregating Data Using Group Functions

Sub Queries

• Simple Sub Queries
• Multiple Row Sub Queries

Update

• Data Updating
• Updating data using Sub Queries

Delete

• Deleting Data
• Deleting data using Sub Queries
• Deleting data using join

Transaction Control Language (TCL)

• Commit
• Roll back
• Save point

Database Objects

• View
• Synonym
• Sequence
• Index
• Privileges

View

• Simple View
• Complex View
• In Line View

Synonym

• Private Synonym
• Public Synonym

Privileges

• Grant
• Revoke

3.PL/SQL

• Block Structure of PL/SQL
• Data Types, Variables & Constants

Flow Control Statements

• Simple IF
• IF-THEN-ELSE Statements
• IF-THEN-ELSIF Statements

Iterative Statements

• Simple Loop
• While Loop
• For Loop

Attribute Data Types

• %type
• %Rowtype

Cursor Management

• What is Cursor?
• Implicit Cursor
• Explicit Cursor
• Cursor with parameters
• Cursor with For Loop

Exceptions

• What is an Exception?
• Predefined Exception
• User defined Exception

Sub Programs

• Named PL/SQL Block
• Stored Procedures
• Types of Parameters
• Stored Function
• Difference between Function and Procedure

Package

• What is package?
• Importance of package

Triggers

• What is a Trigger?
• Row Level Trigger
• Table Level Trigger
• Instead of Trigger
• DML Triggers
• System Trigger