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