SQL

  • Oracle Database Introduction
  • Oracle Architecture (Physical and Logical Structure)
  • Some Introductory Terminology
  • Oracle Standard Interfaces (SQL Plus and Toad)
  • Sample Database
  • Oracle Tables and Data Types
  • Normalization
  • Integrity Constraints
  • Data Manipulation Language (Inserting, Modifying and deleting data)
  • Modifying Table Structure
  • Data Retrieval and Ordering Output
  • Relational, Logical, Arithmetic and some special Operator
  • Aggregate and Group By Functions
  • Oracle Built in Functions (Numeric, Character, Date and conversion Functions)
  • Table Joins
  • Sub Queries
  • Set Operators
  • Multi table insert and Merge Statement
  • Analytical Functions
  • Transaction Processing
  • Sequence
  • Synonym
  • Indexes
  • Views
  • Materialized Views
  • DB Links
  • Oracle Net Services
  • Administering User Privileges, Roles and Profiles

PLSQL

Introduction to PLSQL

  • Difference between SQL and PLSQL
  • Understanding PLSQL
  • PLSQL Data Types
  • Variables
  • Looping and Conditional constructs
  • Anchored Data Types
  • Case Statement

Cursors

  • Understanding Cursors
  • Types Of cursors
  • Cursor Operations
  • Cursor Attributes
  • Parameterized Cursors

Exception Handling

  • Understanding Exceptions
  • Named System Exceptions
  • Unnamed System Exceptions
  • Named Programmer Defined Exceptions
  • Unnamed Programmer defined exceptions

Stored Procedures and Functions

  • Understanding Stored Procedures
  • Creating Procedures
  • Parameter Modes
  • Creating Functions
  • Difference between Functions and Procedures

Packages

  • Introduction to packages
  • Package Specification and Body
  • Package Overloading
  • Advantages of Packages

Triggers

  • Understanding Triggers
  • Keywords and parameters
  • Types of triggers
  • Expressions in triggers

PLSQL Records and Tables

  • Introduction to PLSQL Records
  • Defining and declaring PLSQL Records
  • PLSQL Table of records

ORDBMS

  • Feature of object oriented programming
  • Creating Abstract data types and methods
  • Creating tables using abstract data types
  • Constructor Methods

Varying Arrays and Nested Tables

  • Introduction to collections
  • Creating Varrays
  • Creating Nested Tables
  • Manipulating Data

More on Records and Collections

  • Update Database with PLSQL Record Values
  • Restrictions
  • Associative Arrays

Bulk Binds

  • Improving performance with bulk bind
  • Using DML on Collections
  • Rollback on FORALL