Oracle Database 12c: PL/SQL II – Intermediate
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.
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.
Participants should previously have followed our Oracle Database 12c: PL/SQL I - Introduction course or have Oracle Database PL/SQL knowledge.
Introducing Database-Resident Program Units
Creating Stored Procedures & Functions
Executing Stored Procedures & Functions
Maintaining Stored Program Units
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
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".
You might be interested in our Oracle Database 12c: Administration Workshop.
Next training dates
27 February to 1 March 2019
2.250 EUR (VAT excluded) per person
From 9 AM to 5 PM
De Villermontstraat 9
This training in-company?
Upon your request we can organize this training for you.