Search
START TYPING AND PRESS ENTER TO SEARCH

    Have a Question About This Course?





    Image

    Introduction to Oracle PL/SQL

    Database Development - 5 Days
    Introduction to Oracle PL/SQL is a hands-on course designed for those who already understand Oracle SQL and want to dive into the powerful procedural capabilities of PL/SQL. This course teaches the core concepts and structures of PL/SQL programming and equips learners to develop robust, secure, and maintainable applications within the Oracle Database environment.

    Participants will explore key PL/SQL features, including blocks, variables, control structures, subprograms (procedures and functions), exception handling, cursors, packages, and triggers. Each concept is reinforced with practical exercises and real-world examples to solidify understanding and build real development skills.

    Introduction to Oracle PL/SQL Objectives

    • Understand the structure and purpose of PL/SQL blocks
    • Declare and manage variables and data types
    • Use conditional and loop control structures
    • Write and execute procedures and functions
    • Handle exceptions and errors gracefully
    • Work with implicit and explicit cursors for data retrieval
    • Create reusable code units with packages
    • Define triggers to automate database actions
    • Key Benefits
    • Hands-On Learning: Apply what you learn through guided labs and real-world scenarios
    • Build Application Logic: Go beyond SQL to build procedural logic directly in the Oracle Database
    • Improve Maintainability: Write modular reusable code with PL/SQL subprograms and packages
    • Boost Performance and Security: Use PL/SQL to execute complex logic securely and efficiently Career Growth: Build a strong foundation for advanced Oracle development and DBA roles

    Need Assistance Finding the Right Training Solution

    Our Consultants are here to assist you
    Arrange a consultation

    Key Point of Training Programs

    We have different work process to go step by step for complete our working process in effective way.
    • Introduction to Oracle PL/SQL Prerequisites

      Audience: Developers, analysts, and database professionals with a working knowledge of Oracle SQL

      Must have hands on experience of Oracle SQL

    • Introduction to Oracle PL/SQL Format

      In-Person

      Online

    • Introduction to Oracle PL/SQL Outline

      PL/SQL Basics
      The HR Schema
      What is PL/SQL?
      Blocks
      Outputting Information
      Variables and Constants
      Constants
      Data Types
      Naming Variables and Other Elements
      Embedding SQL in PL/SQL
      SELECT…INTO and RETURNING…INTO
      Using Variables (Exercise)
      PL/SQL Features
      Subprograms
      Introduction to Subprograms
      Procedures
      Variable Declarations
      Parameters
      Parameters with Default Values
      Parameter Modes
      IN Mode
      OUT Mode
      IN OUT Mode
      Named Notation
      Using SQL in a Subprogram
      %TYPE
      Creating a Procedure (Exercise)
      Functions
      Creating a Function (Exercise)
      Using PL/SQL Functions in SQL Queries
      Dropping a Subprogram
      Conditional Processing
      Conditions and Booleans
      IF-ELSIF-ELSE Conditions
      Creating a get_age() Function (Exercise)
      ELSIF
      Creating a check_rights() Procedure (Exercise)
      Creating an is_manager() Function (Exercise)
      BOOLEAN Values and Standard SQL
      The CASE Statement
      CASE Expressions
      Replacing the Head Honcho (Exercise)
      Exceptions
      Introduction to Exceptions
      Predefined Exceptions
      The EXCEPTION Part of the Block
      Catching NO_DATA_FOUND Exception (Exercise)
      User-defined Exceptions
      User-defined Exceptions in Subprograms
      Re-raising Exceptions
      Replacing the Head Honcho (revisited) (Exercise)
      Adding Exceptions to update_employee_manager() (Exercise)
      Naming Unnamed Predefined Exceptions
      WHILE Loops
      When to Use Exceptions
      Cursors
      Implicit Cursors
      Using Implicit Cursor Attributes (Exercise)
      Explicit Cursors
      %ROWTYPE
      Explicit Cursor Use Case
      Cursor FOR LOOP
      Using an Explicit Cursor (Exercise)
      Cursor Parameters
      Packages
      Package Basics
      The Package Specification
      The Package Body
      Modifying the Package (Exercise)
      Building an Employee Package
      Adding a get_manager() Function (Exercise)
      Overloading Subprograms
      Adding Overloaded Functions to the Package (Exercise)
      Auditing
      Validation Procedures
      Adding a Validation Procedure (Exercise)
      Package Cursors
      Adding a Cursor to the Package (Exercise)
      Benefits of Packages
      Triggers
      What are Triggers?
      Trigger Parts
      Validation Triggers
      Creating a Trigger on the jobs Table (Exercise)
      The WHEN Clause
      Using the WHEN Clause (Exercise)
      Audit Triggers
      Statement-level Triggers
      Compound Triggers
      Trigger Warning