Equi non equi self join cartesian joinnatural joins

Equi / Non Equi / Self Join / Cartesian Join/natural joins
 Vertical joins(set operators)
 Sub Queries and Simple sub query
 Complex Sub Query on multiple data source and Co-related Sub
Query
 Top-n queries, hierarchical queries, scalar queries, flashback
queries,version queries.
 Intigrity Constraints
 Oracle Database Objects
 Index and Introduction to Index
 Clusters and Introduction to Cluster
 Type of Clusters and Their Usage
 Explain plan Command Usage and Oracle Scripts
 Views and Introduction to Views
 Type of Views and usage
 Performance issues with Views
 Background process of Views
 DML restrictions on Views
 Materialized View and Usage
 Synonym and Introduction to Synonyms and Usage
 Sequence and Introduction to Sequence and Usage
 Pseudo Columns Usage in Sequence
 Data Control Language commands
 What is privilege
 What is role
 Grating Privilege
 Removing Privilege
 Cascading Privilege
 Sql * Plus Commands

ORACLE SQL
 Environment setting commands
 Alter session language
 Alter system language
 Sql developer
PL/SQL
 Introduction to Programming Language
 Procedures Vs Non-Procedures Language
 Limitation of ANSI SQL and Oracle SQL
 Introduction to Oracle PL/SQL
 PL/SQL Usage in Production Database
 Key benefits of PL/SQL over SQL
 Anchor datatypes or Attributes
 Composite datatypes
 Collections
 PL/SQL block structure & Designing
 Scope and Visibility
 Constructs of PL/SQL
 Assignment operations
 Debugging statement
 Flow Control Statement
 IF / NESTED IF / EXIT / GOTO /
 Iterative statements
 Simple Loop / While Loop / For Loop
 Continue statement(11g)
 Embedded SQL
 Introduction to Embedded SQL
 Role of Embedded SQL in PL/SQL
 Constructs of Embedded SQL
 Transaction Mngmt Using Embedded SQL
 Dynamic SQL
 Introduction to Dynamic SQL
 Usage of Dynamic SQL in PL/SQL
 Introduction to Exceptions
 Importance of Exceptions in PL/SQL
 Type of Exceptions
 Exception handling
 Save exceptions
 Introduction and STANDARD Package
 Introduction to User Defined Exceptions
 Non predefined exceptions
 Exception cases
 Usage of PRAGMA EXCEPTION_INIT()
 Cursor Management in PL/SQL
 Introduction to cursor management

ORACLE SQL
 Pictorial presentation of cursor mechanism
 Introduction and usage of implicit cursor
 Introduction and usage of Explicit cursors
 Cursor attributes
 Cursor using simple loop
 Cursor using while loop
 Cursor using for loop
 Cursor exceptions
 Cursor expression
 Data Locking
 Data Manipulation through Cursor
 REF cursor(strong and weak)
 Using ref cursor variable as parameter
 Bulk Fetch and Bulk Data Retrieval in PL/SQL
 Bulk Collection
 Bulk Binding mechanism of Cursor (for all statement)
 Dynamic behavior of cursor mnt.