Course Code: 5617

Oracle Database 12c: PL/SQL Fundamentals I and II

Class Dates:
5 Days
Class Time:


  • Course Overview
  • 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.

  • Audience
  • 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".


  • Oracle Database 12c: SQL - Fundamentals (Levels I & II) or Oracle Database 12c: SQL (Levels I, II & III) are recommended.

Course Details