HOME
 

Oracle PL/SQL Stored Program Units

Focus on Training
Course summary
1,250 GBP
Professional Training
Next available date: 22/09/2021 - Online courses
Course Dates
Online courses
1,250 GBP
22/09/2021

Online courses
1,250 GBP
17/11/2021

City of London
1,250 GBP
22/09/2021

City of London
1,250 GBP
17/11/2021

Course description

The Oracle PL/SQL Stored Program Units course provides practical experience in developing and writing triggers, functions, procedures and packages. It also introduces some of the Oracle-supplied packages.

The delegate will learn and acquire skills as follows:

  • Implementing various types of trigger
  • Creating, managing and invoking stored procedures
  • Creating, managing and executing stored functions
  • Developing and using packages
  • Using package features and constructs effectively
  • Wrapping packages
  • Using Cursor Variables
  • Using records and tables or associative arrays in packages
  • Implementing Bulk Binding and Bulk Collecting techniques
  • Managing program unit dependencies
  • Implementing Native Compilation and Compile-time Warnings
  • Implementing Native Dynamic SQL
  • Using a variety of Oracle-supplied packages

Who will the Course Benefit?

Oracle database administrators and software development personnel who need to write new or maintain existing, PL/SQL triggers, program units and packages.

Practical experience of Oracle SQL and of using SQL*Plus or SQL Developer and a good working knowledge of the fundamentals of the Oracle PL/SQL programming language are required.

About provider

Focus on Training: Best Practice Skills from the Specialists

Focus on Training is a professional training company specialising in offering accredited Project Management and IT programmes. With over 10,000 courses offered in over 100 locations throughout the United Kingdom, Focus is a premier training provider. All programmes can be booked online...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Oracle PL/SQL Stored Program Units.

  Contact the provider

  Get more information

  Register your interest

Country *

Contact info

Focus on Training

Olympus House, Werrington Centre
PE4 6NA Peterborough

 Show phone number
www.focus-on-training.co.uk


Request information

Find out more about this Oracle PL/SQL Stored Program Units course - simply fill out your details:

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here