Use of Anchored Datatype in PLSQL block, Need for the use of %TYPE, Case & Example

Use of Record Type. How to create? Built in Record Type %ROWTYPE,  Use & Example

Controlling the flow of the program with conditional statements IF, ELSIF and CASE - Explained with Examples

Different forms of LOOPS, their use under different conditions, Properties of LOOPS explained with examples

PL/SQL cursor basics - What is PL/SQL Cursor - Types of PL/SQL Cursors - Purpose of PL/SQL Cursors - Definitions of Explicit, Implicit, Ref and Sub-query cursors

Form and nature of Explicit Cursor - Properties of Explicit Cursor - Cursor FOR LOOP - Use and Case Example

Form and nature of Implicit Cursor - Properties of Implicit Cursors - Exceptions associated with Implicit Cursors - Case & Examples

What is REF CURSOR? - Types of REF CURSOR - Properties of different types of REF CURSOR - Choosing appropriate type of REF CURSOR - Case & Examples

Form and nature of Strong Typed REF CURSOR - Use of Strong Typed REF CURSOR explained with a case examples

Form and nature of Weak Typed REF CURSOR - Use of Weak Typed REF CURSOR explained with case examples.

Built-in SYS_REFCURSOR - Properties of SYS_REFCURSOR - Use of SYS_REFCURSOR as parameter of procedure - How to draw bulk data from the program by using SYS_REFCURSOR

Concept of Cursor Subqueries - Declaration of Nested Query as Cursor - Use of Cursor Subquery explained with case & examples

What are properties of Function - When to use Function - What to avoid in Function - Cases & Examples

Properties of Procedure - When to use Procedure - Returning value(s) from Procedure - Cases and Examples

What is Package - Properties of Package Header and Body - Public / Private Declaration - Package Example

What is Overloading - Why Overloading of the programs - Conditions of Overloading - Case Examples

What is Package Initialization - Why need Package Initialization - When to use Package Initialization - Private declaration of Programs and variables - Pragma Autonomous Transaction - Case study of Package Initialization

Meaning of Forward Declaration or Forward Calling - When to use Forward Calling - Organization of Packaged Programs by using Forward Declaration - Case study of forward calling

Properties of DML Triggers - ROW level Triggers - TABLE level Triggers - Timing of firing BEFORE & AFTER - Properties of each type - Guidelines for choosing the correct type - Combination of Events to fire the trigger - Case Examples

What is Mutating Table error - Conditions when it appears - Cause analysis of the error - Practical example of work around Mutating Table Error

What are Trigger Predicates - What Trigger Predicates are used for - Execution of lines of code in trigger relevant to the event - Explanation of Trigger Predicates through a practical case example

Preventing unnecessary trigger firing through WHEN clause - When to use WHEN clause - Limitations for the use of WHEN clause - Case example

What are System Level Triggers - Properties of Database Triggers - Database level triggering events - Schema level triggers - System Triggers for auditing user activity - Case Examples

What are Instead of Triggers - Triggers on Views - Why need instead of Triggers - Properties of Instead of Triggers - Case Examples

Understand the basic concept behind the object oriented programming - What is an object explained with a real time example - Why  use object oriented programming - Explanation on various properties of an object - Difference between object type and class

How to create an object type - Properties of an object type - Difference & Similarities between Object Type and Package - Case example of an Object Type - Type Header - Type Body - Object Type Constructor - Object Type initialization - Object Type use in a PL/SQL program

What is an Object Table? Create an Object Table, Concept of Row Object, Data manipulation in Object Table, Method integration with Object Table.