PL / SQL Fundamentals

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
    • +63 2 8891 0722
    • +63 2 8891 0713
    • +63 2 8751 6482
    • Intramuros
    • +63 2 8524-5572
    • Intramuros
    • 658 Muralla St., Intramuros, Manila 1002, Philippines


    • Makati
    • 333 Sen. Gil Puyat Ave., Makati City 1200, Philippines