Duration : 2-3 Month*
Eligibility : 10 + 2

Course Objective: To make our trainee expert in the following topics theoretically & practically.

  • Data Types: Character, Number, Boolean, Date, LOB Concept
  • Variable Identifiers Concept
  • Collections: Varrays, Nested & Index by Tables Concept
  • Records Type Concept
  • IF THEN ELSE Statement: ELSIF, NESTED-IF Concept
  • CASE Statement
  • LOOP: FOR LOOP, WHILE LOOP Concept
  • Stored Procedure & Functions Concept
  • Exception Handling: Raise User-defined Exception Concept
  • Insert, Update, Delete & Select Into Concept
  • Cursor: Implicit, Explicit, Cursor FOR Loop Concept
  • BULK COLLECT: FORALL Concept
  • Autonomous Transaction in Oracle PL/SQL: Commit, Rollback Concept
  • Package: Type, Specification, Body Concept
  • Trigger Tutorial: Instead of, Compound Concept
  • Object Types Concept
  • Dynamic SQL: Execute Immediate & DBMS_SQL Concept
  • Nested Blocks & Variable Scope in Oracle PL/SQL Concept

Note- We train our trainee until they are satisfied.