+44 (0) 845 643 1611 info@unitrain.co.uk

Oracle Database: Develop PL SQL Program Units

This Oracle Database: PL/SQL Program Units course builds on existing knowledge of PL/SQL block structure, variables, control structures and exception handling to explore the benefits of building Progran Units in this powerful programming language.

Through hands-on instruction from expert Oracle instructors, you'll learn to develop stored procedures, functions, packages and triggers and utilise Oracle provided packages.

Learn To:

  • Develop stored procedures to carry out database modifications.
  • Write functions to be called from PL/SQL code or SQL statements.
  • Use PL/SQL packages to group and contain related constructs.
  • Create triggers to solve business challenges.
  • Use Oracle supplied PL/SQL packages to generate screen output and file output.
  • Examine the dependency chain on program units prior to implementing changes.

Benefits to You:

  • Develop sound, reliable program units to standardise and streamline your organisation's approach to maintaining data.
  • You'll use Oracle SQL Developer to develop these program units. SQL*Plus is also available as an optional tool.

Course Prerequisites



  • Familiarity with data processing concepts and techniques
  • Familiarity with programming languages


  • Database Administrator
  • Developer
  • Implementer
  • Systems Administrator

Oracle Database: Develop PL SQL Program Units Key Facts
Course Duration (days)


Course Price (ex VAT)


Course Vendor


Contact Us

Submit this form and one of our friendly team will contact you within 4 working hours. Or give us a call on +44 0845 643 1611 and let us take care of your training needs.




    Health & Safety Training

    IT Courses

    eLearning Training

    Business Skills & Personal Development

    Project and Programme Management

    Tailor Made Courses

    Call Us

    +44 0845 643 1611

    Email Us


    Privacy Policy