This 5 day training begins with an explanation of the intent and usage of the PL/SQL programming language for database applications. Important reasons why one should incorporate PL/SQL modules within the application architecture right from the initial design and planning phase are presented. Next one learns how to begin building executable PL/SQL program units. One learns about each of the major segments of a working program and how these interact with each other during program execution, including the important error or exception handling capabilities of the language.
Part 2 - 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.
The target audience for this textbook is all Oracle professionals. Among the specific groups for whom this textbook will be helpful are:
• Application designers and database developers
• Database administrators
• Web server administrators
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".
Prerequisites
Oracle Database 12c: SQL - Fundamentals (Levels I & II) or Oracle Database 12c: SQL (Levels I, II & III) are recommended.
*Course Cost listed does not include the cost of courseware. Please refer to your Invoice for any additional costs. If you have any questions, please contact us at learn@vtec.org or 207-775-0244. Course is subject to minimum enrollment to run. If the minimum is not met this class may run as a Virtual Instructor Led class.