Oracle 11g PL/SQL Training

Course Duration: 72 Hours

Course Fee: 20,000 tk

Registration

Course Overview

ORACLE 11G PL/SQL TRAINING OVERVIEW

   
  •     Understand the environment and context in which PL/SQL operates
  •    Consider the advantages and benefits of PL/SQL within a database environment
  •    Declare program variables and complex data types
  •    Develop logic within PL/SQL program blocks
  •    Fetch data from the database into program variables
  •    Return program output to users
  •    Handle program exceptions
  •    Use explicit and implicit database cursors
  •    Maintain and implement triggers
  •    Monitor Tablespaces
  •    About Resumable Space Allocation
  •    Table Storage Management
  •    Pctfree Illustrated
  •    Use The Segment Advisor
  •    Cascade To Dependent Objects
  •    Optionally Call Delete_Task()

Course Curriculum

ORACLE 11G PL/SQL TRAINING CURRICULUM

   Part1: Choosing a SQL & PL/SQL Interface
  •    Using SQL Developer
  •    Using SQL*PLUS
  •    Using Application Express
  •    Using JDeveloper Studio
   Part2: Language Features
  •    Understanding PL/SQL
  •    Structure of A PL/SQL Program Block
  •    Using PL/SQL from SQL*PLUS
   Part3: Declare Clause
  •    About the Declare Clause
  •    Declare Simple Types
  •    Declare Complex Types
  •    Type … Table
  •    Type … Record
   Part4: Begin Clause
  •    About the Begin Clause
  •    Performing Data Manipulation
  •    Logic Control & Branching
  •    Loop
  •    If-Then-Else
  •    Case
    •    Part5: Exception Clause
  •    About the Exception Clause
  •    Isolating the Specific Exception
  •    Pragma Exception_Init
  •    SQL%Rowcount & Select…Into
    •    Part6: Explicit Cursors
  •    About Explicit Cursors
  •    Advanced Cursor Techniques
    •    Part7: Introducing Database Program Units
  •    About Database Program Units
  •    Types of PL/SQL Program Units
  •    Types of Stored Program Units
  •    Advantages of Using Stored Program Units
    •    Part8: Creating Stored Procedures & Functions
  •    About Stored Procedures & Functions
  •    Creating Procedures & Functions
  •    Executing Procedures & Functions
    •    Part9: Maintaining Stored Procedures & Functions
    •    Recompiling & Dropping Programs
    •    Data Dictionary Storage
    •    Managing Dependencies
       Part10: Creating & Maintaining Packages
    •    About Packages
    •    Creating Packages
    •    Advanced Programming Techniques
    •    Maintaining Packages
       Part11: Advanced Cursor Techniques
    •    Using Cursor Variables
    •    Using Cursor Expressions
       Part12: Using System-Supplied Packages
    •    DBMS_OUTPUT()
    •    UTL_FILE()
       Part13: Creating Database Triggers
    •    About Database Triggers
    •    Statement-Level Triggers
    •    Row-Level Triggers
    •    Examples of Triggers
    •    Instead of Triggers
    •    Employing Triggers within an Application
       Part14: Maintaining Database Triggers
    •    Call Syntax
    •    Trigger Maintenance Tasks
    •    Show Errors Trigger
    •    Drop Trigger
    •    Alter Trigger
    •    Handling Multiple Triggers for A Table
    •    Handling Mutating Table Issues
       Part15: Implementing System Event Triggers
    •    What Are System Event Triggers?
    •    Defining the Scope
    •    Available System Events
    Share This Article If You Liked It :)