PL / SQL Fundamentals

Duration

40 hours, 5-day training workshop

Delivery

Face to face training or online training

Course Inclusive

Description

The course introduces PL/SQL programming language basics, including the basic programming block structure, conditional statements, looping constructs, and additional functionality to extend the use of SQL.

Course Content

  1. Overview of PL-SQL
  2. Entering and running PL/SQL Code
  3. PL/SQL Block Structure
  4. Variables and Identifiers
  5. Using %TYPE and %ROWTYPE
  6. PL/SQL Control Structures
  7. Using Local PL/SQL Procedures and Functions
  8. Using Cursor Variable to Retrieve Data
  9. Working with PL/SQL Data Structures
  10. Handling PL/SQL Errors
  11. Overview of Procedures, Functions and Packages
  12. Managing Stored Procedures and Functions
  13. Managing Packages
  14. Overview of Triggers
  15. Designing Triggers
  16. Managing Triggers in a Database
  17. Manipulating Large Objects
    • MAKATI
    • 333 Sen. Gil Puyat Ave., Makati City 1200, Philippines

    • Contact No.
    • +63 2 8891 0713
      +63 2 8751 6482

    • Email Address
    • inquiries@mapua.edu.ph

    • INTRAMUROS
    • 658 Muralla St., Intramuros, Manila 1002, Philippines

    • Contact No.
    • +63 2 8524-5572


    • Email Address
    • ccesc@mapua.edu.ph