Oracle PL/SQL Stored Program Units

3 days training for £1,350 exc. VAT   

Call StayAhead Training on 020 7600 6116 to book your place now quoting course code: OSPU


S6

Oracle PL/SQL Stored Program Units Course Overview

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:

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.

Course Objectives

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

Examinations

Together with the PL/SQL course, the Oracle PL/SQL Stored Program Units course will teach the major topics required for the delegate to work towards achieving the #1Z0-144 - Oracle Database 11g: Program with PL/SQL Oracle examination.

Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.

Exams are not included as part of the course.

Requirements

Practical experience of Oracle SQL*Plus or SQL Developer and a good working knowledge of the fundamentals of the Oracle PL/SQL programming language is required. This can be gained by attendance on the pre-requisite courses.

Pre-Requisite Courses

Follow-On Courses

Notes:

Oracle PL/SQL Stored Program Units Training Course

Course Contents - DAY 1

Course Introduction

Session 1: TRIGGERS

Session 2: PROCEDURES

Session 3: FUNCTIONS


Oracle PL/SQL Stored Program Units Training Course

Course Contents - DAY 2

Session 4: PACKAGES

Session 5: USING PL/SQL RECORDS AND TABLES IN PACKAGES

Session 6: CURSOR VARIABLES (REF CURSORS)

Session 7: MANAGING DEPENDENCIES


Oracle PL/SQL Stored Program Units Training Course

Course Contents - DAY 3

Session 8: NATIVE COMPILATION AND COMPILE-TIME WARNINGS

Session 9: ORACLE-SUPPLIED PACKAGES


Pre-Requisite Courses


Follow-On Courses


Venues and Dates

  Barbican (London) Training Centre 

  • 07 August
  • 18 September
  • 13 November
  • 22 January 20
  • 11 March 20


Additional Resourcing

We have the resources to run this course in Manchester, Birmingham, Bristol, Leeds & Edinburgh.   Please contact us to discuss your needs and we will endeavour to see if we can arrange a date to run this course at the venue of your choice.  We have the resources to run many of our courses at our other venues.

If you have a number of delegates to train then this course can be conducted on your premises or at a venue of your choice as a Closed event. Closed courses can be tailored to meet the specific needs of your business and can prove to be cost effective, convenient and relevant.

StayAhead Virtual Courses available There are options to take this as a Virtual course. Please contact us to discuss your specific requirements and to arrange a date to run this course as a virtual event to suit your schedule.

Note

The 3 Day Stored Program Units course can be combined with the 2 Day Oracle PL/SQL course, this is equivalent to attending the 5 Day Oracle Program with PL/SQL course.




 
StayAhead Training Ltd  https://www.stayahead.com   Publication Date: 19-Jul-2019
telephone: 020 7600 6116   All registered trademarks are acknowledged
email: sales@stayahead.com   Copyright © StayAhead Training Ltd
Call us on 020 7600 6116