HOME
 

Oracle Program with PL/SQL

Focus on Training
Course summary
Nationwide
Next available date: - United Kingdom
Professional Training

Course description

The Oracle Program with PL/SQL training course introduces the delegate to Oracle's PL/SQL programming language and provides practical experience in writing stand-alone programs, developing database triggers and implementing stored functions, procedures and packages. It also introduces some of the Oracle-supplied packages.

The delegate will learn and acquire skills as follows:

  • Writing and running PL/SQL programs from SQL*Plus or SQL Developer
  • Declaring and using variables and constants
  • Assigning and manipulating values
  • Using SQL statements within PL/SQL
  • Implementing conditional execution and loop constructs
  • Declaring and using cursors with and without parameters
  • Updating data with cursors
  • Trapping and handling errors and exceptions in code
  • Implementing nested and labelled loops and blocks
  • Raising exceptions
  • Handling PL/SQL records and Index-By tables
  • Using PL/SQL Index-By table built-in functions
  • 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 Index-By 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, software development personnel and database support staff who need to write PL/SQL scripts and implement or maintain database triggers, program units and packages.

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

Contact info

Focus on Training

Olympus House, Werrington Centre
PE4 6NA Peterborough

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


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