Providing Technology Training and Mentoring For Modern Technology Adoption
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.
The target audience for this course is all Oracle professionals. Among the specific groups for whom this course will be helpful are:
Either of the Oracle Database 12c: SQL Fundamentals (Levels I & II) or Oracle Database 12c: SQL Complete Library (Levels I, II, & III) courses are recommended prerequisites for this course.