Oracle Database 12c R2: Program with PL/SQL Ed 2 Course Overview

Oracle Database 12c R2: Program with PL/SQL Ed 2 Course Overview

The Oracle Database 12c R2: Program with PL/SQL Ed 2 course is designed to educate learners on the advanced features of PL/SQL in order to design and tune PL/SQL efficiently. With hands-on learning, it prepares participants for the 1Z0-144 Oracle Database 12c: Program with PL/SQL exam, part of the Oracle 1Z0-144 certification process. Through this comprehensive training, individuals will understand how to use PL/SQL to access Oracle databases and how to use the language's features to create robust database applications.

Students will gain knowledge in a variety of key areas, such as writing powerful PL/SQL programs, creating stored procedures and functions, utilizing control structures, handling exceptions, and working with composite data types. The course also emphasizes best practices and considerations for optimizing PL/SQL performance. By the end of the course, learners will have a solid foundation to write efficient and scalable PL/SQL code, which is essential for managing data in Oracle databases.

Koenig's Unique Offerings


1-on-1 Training

Schedule personalized sessions based upon your availability.


Customized Training

Tailor your learning experience. Dive deeper in topics of greater interest to you.


4-Hour Sessions

Optimize learning with Koenig's 4-hour sessions, balancing knowledge retention and time constraints.


Free Demo Class

Join our training with confidence. Attend a free demo class to experience our expert trainers and get all your queries answered.

Purchase This Course

Fee On Request

  • Live Online Training (Duration : 40 Hours)
  • Per Participant
  • Guaranteed-to-Run (GTR)
  • date-img
  • date-img

♱ Excluding VAT/GST

Classroom Training price is on request

  • Live Online Training (Duration : 40 Hours)
  • Per Participant

♱ Excluding VAT/GST

Classroom Training price is on request

Request More Information

Email:  WhatsApp:

Course Prerequisites

To ensure that you can make the most of the Oracle Database 12c R2: Program with PL/SQL Ed 2 course, the following prerequisites are recommended:

  • Basic understanding of database concepts, including what a database is, what tables and indexes are, and familiarity with how data is stored and retrieved.
  • Fundamental knowledge of SQL, including the ability to construct simple SELECT, INSERT, UPDATE, and DELETE statements.
  • Experience with any programming language would be beneficial, although it's not mandatory. Familiarity with basic programming concepts such as variables, loops, and conditional statements will help you grasp the PL/SQL content more effectively.
  • An analytical mindset and problem-solving skills will aid in understanding PL/SQL programming logic and practices.
  • Ability to navigate through basic computer software and use a text editor for coding purposes.
  • Interest in learning how to develop database-driven applications using Oracle PL/SQL.

These prerequisites are designed to provide a baseline understanding that will help you quickly adapt to the course content. If you are new to some of these concepts, we encourage you to explore introductory materials before starting this course to ensure the best learning experience.

Target Audience for Oracle Database 12c R2: Program with PL/SQL Ed 2

Oracle Database 12c R2: Program with PL/SQL Ed 2 is designed for professionals seeking to master SQL and PL/SQL programming on Oracle databases.

  • Database Administrators
  • Application Developers
  • PL/SQL Developers
  • Data Analysts
  • Business Intelligence Professionals
  • IT Consultants
  • Software Engineers
  • Technical Consultants
  • Data Warehouse Administrators
  • Back-End Developers
  • System Analysts

Learning Objectives - What you will Learn in this Oracle Database 12c R2: Program with PL/SQL Ed 2?

Introduction to the Oracle Database 12c R2: Program with PL/SQL Ed 2 Course Outcomes

This course equips students with the skills to write PL/SQL programs for Oracle Database 12c R2, enabling efficient data manipulation and enhanced performance.

Learning Objectives and Outcomes

  • Understand the structure and benefits of PL/SQL within Oracle databases, including how to create and execute anonymous blocks and store output.
  • Define and manipulate various PL/SQL identifiers, variables, and data types, making effective use of the %TYPE attribute and bind variables.
  • Write executable statements following best practices in PL/SQL syntax, incorporating SQL functions, and handling data type conversions.
  • Interact seamlessly with the Oracle Server using SELECT statements, cursors, and DML operations, and manage transactions within PL/SQL blocks.
  • Implement control structures for conditional processing and iteration, utilizing IF, CASE statements, and various loop constructs.
  • Work with composite data types such as PL/SQL records, INDEX BY tables, and the %ROWTYPE attribute for efficient data handling.
  • Manage data retrieval with explicit cursors, understanding their lifecycle, attributes, and usage in cursor FOR loops.
  • Develop robust error handling procedures to manage exceptions, including predefined, non-predefined, and user-defined exceptions, using RAISE_APPLICATION_ERROR for custom errors.
  • Design and implement stored procedures to modularize code, including creating, calling, removing, and managing parameters and their modes.
  • Gain insights into the PL/SQL execution environment and subprograms, discerning the advantages of using modularized PL/SQL code blocks.