Oracle Program with PL SQL

Duration: 
5 days
Codes: 
STA-OPPL,PL,SQL

Overview

Not available. Please contact.

Audience

Who will the Course Benefit? 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.

Skills Gained

The delegate will learn and acquire skills as follows:

  • Writing and running PL/SQL programs from SQL*Plus or SQL Developer
  • Assigning and manipulating values
  • Using SQL statements within PL/SQL
  • Implementing conditional execution and loop constructs
  • 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

Using a variety of Oracle-supplied packages Course Objectives Course Objectives

To provide the skills needed to develop, write and maintain PL/SQL scripts, triggers, stored program units and packages.

Prerequisites

A working knowledge of Oracle SQL or SQL Developer is required along with practical experience in writing SQL statements. This can be obtained by attendance on the pre-requisite courses. Some previous programming experience will also prove advantageous as well as practical experience in writing SQL statements.

Course Outline

The delegate will learn and acquire skills as follows:

  • Writing and running PL/SQL programs from SQL*Plus or SQL Developer
  • Assigning and manipulating values
  • Using SQL statements within PL/SQL
  • Implementing conditional execution and loop constructs
  • 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

Using a variety of Oracle-supplied packages Course Objectives Course Objectives

To provide the skills needed to develop, write and maintain PL/SQL scripts, triggers, stored program units and packages.

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
London London5 3750 £3750 2019-11-11
London London5 3750 £3750 2019-11-11