Oracle Database 12c: PL/SQL II – Intermediate

Duration

3 days

Overview

This course is intended for those who have already learned the basics of the Oracle PL/SQL database programming language and its syntax, and who are now ready to employ the language in the development of database applications. In particular, the focus of this course will be on the use of database-resident stored program units such as procedures, functions, packages and database triggers. New features introduced with the Oracle 12c release of the database are also explained and demonstrated.

Course Objectives

This course explains how database-resident program units can be used as part of the overall database application architecture and the benefits realized by doing so. It then builds upon one's knowledge of database-resident program units and applies these to the development of PL/SQL packages. In a production environment most PL/SQL program units should be packaged, and these advanced database programming capabilities along with the benefits of using these are discussed. It concludes with extensive demonstrations on how a particular type of database-resident program unit known as a database trigger can be used as part of an advanced database application design.

Prerequisites

Participants should previously have followed our Oracle Database 12c: PL/SQL I - Introduction course or have Oracle Database PL/SQL knowledge.

Course Content

  • Introducing Database-Resident Program Units

  • Creating Stored Procedures & Functions

  • Executing Stored Procedures & Functions

  • Maintaining Stored Program Units

  • Managing Dependencies

  • Creating & Maintaining Packages

  • Advanced Package Capabilities

  • Advanced Cursor Techniques

  • Using System-Supplied Packages

  • Database Triggers Concepts

  • Creating Database Triggers

  • Maintaining Database Triggers

  • Implementing System Event Triggers

Certification

This course considers subjects applicable to certification as both an Oracle PL/SQL Developer Certified Associate (OCA) and an Oracle Advanced PL/SQL Developer Certified Professional (OCP).

The topics considered are included within "Exam 1Z0-144: Program With PL/SQL".

Get in touch with the Test Center in Kontich or Hasselt.

What’s next?

You might be interested in our Oracle Database 12c: Administration Workshop.

 
 

Next training dates

  • 27 February to 1 March 2019

Training cost

2.250 EUR (VAT excluded) per person

Practical details

3 days
Classroom
From 9 AM to 5 PM

Language

English

Location

De Villermontstraat 9
2550 Kontich
Belgium

This training in-company?

Upon your request we can organize this training for you.