Advance Oracle PL / SQL

Description

Extend the functionality of the SQL language with PL/SQL to write application codes.

Course Content

  1. Introduction to PL/SQL
  2. Declare PL/SQL Identifiers
  3. Write Executable Statements
  4. Interaction with the Oracle Server
  5. Control Structures
  6. Composite Data Types
  7. Explicit Cursors
  8. Exception Handling
  9. Stored Procedures
  10. Stored Functions and Debugging Subprograms
  11. Packages
  12. Deploying Packages
  13. Implement Oracle-Supplied Packages in Application Development
  14. Dynamic SQL
  15. Design Considerations for PL/SQL Code
  16. Triggers
  17. Creating Compound, DDL, and Event Database Triggers
  18. PL/SQL Compiler
  19. Manage PL/SQL Code
  20. Manage Dependencies
    • 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