Oracle Database 12c R2: Program with PL/SQL Ed 2/1Z0-144

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

Oracle Database 12c R2: Program with PL/SQL Ed 2 training course is designed to introduce about PL/SQL and then explores the benefits of this powerful programming language. In this training class, you'll learn to develop stored procedures, functions, packages and more.

Target Audience:

  • Application Developers
  • Database Administrators
  • Developer
  • Forms Developer
  • PL/SQL Developer
  • Portal Developer
  • System Analysts
  • Technical Consultant
This course prepares you for Exam 1Z0-144. Test your current knowledge Qubits42

Oracle Database 12c R2: Program with PL/SQL Ed 2 (40 Hours) Download Course Contents

Live Virtual Classroom
Group Training 3100
02 - 06 Aug 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 10 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 3550
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Course Modules

Module 1:Introduction
  • Course Objectives
  • Course Agenda
  • Describe the Human Resources (HR) Schema
  • PL/SQL development environments available in this course
  • Introduction to SQL Developer
Module 2:Introduction to PL/SQL
  • Overview of PL/SQL
  • Identify the benefits of PL/SQL Subprograms
  • Overview of the types of PL/SQL blocks
  • Create a Simple Anonymous Block
  • How to generate output from a PL/SQL Block?
Module 3:Declare PL/SQL Identifiers
  • List the different Types of Identifiers in a PL/SQL subprogram
  • Usage of the Declarative Section to Define Identifiers
  • Use variables to store data
  • Identify Scalar Data Types
  • The %TYPE Attribute
  • What are Bind Variables?
  • Sequences in PL/SQL Expressions
Module 4:Write Executable Statements
  • Describe Basic PL/SQL Block Syntax Guidelines
  • Learn to Comment the Code
  • Deployment of SQL Functions in PL/SQL
  • How to convert Data Types?
  • Describe Nested Blocks
  • Identify the Operators in PL/SQL
Module 5: Interaction with the Oracle Server
  • Invoke SELECT Statements in PL/SQL
  • Retrieve Data in PL/SQL
  • SQL Cursor concept
  • Avoid Errors by using Naming Conventions when using Retrieval and DML Statements
  • Data Manipulation in the Server using PL/SQL
  • Understand the SQL Cursor concept
  • Use SQL Cursor Attributes to Obtain Feedback on DML
  • Save and Discard Transactions
Module 6:Control Structures
  • Conditional processing using IF Statements
  • Conditional processing using CASE Statements
  • Describe simple Loop Statement
  • Describe While Loop Statement
  • Describe For Loop Statement
  • Use the Continue Statement
Module 7:Composite Data Types
  • Use PL/SQL Records
  • The %ROWTYPE Attribute
  • Insert and Update with PL/SQL Records
  • INDEX BY Tables
  • Examine INDEX BY Table Methods
  • Use INDEX BY Table of Records
Module 8:Explicit Cursors
  • What are Explicit Cursors?
  • Declare the Cursor
  • Open the Cursor
  • Fetch data from the Cursor
  • Close the Cursor
  • Cursor FOR loop
  • The %NOTFOUND and %ROWCOUNT Attributes
  • Describe the FOR UPDATE Clause and WHERE CURRENT Clause
Module 9:Exception Handling
  • Understand Exceptions
  • Handle Exceptions with PL/SQL
  • Trap Predefined Oracle Server Errors
  • Trap Non-Predefined Oracle Server Errors
  • Trap User-Defined Exceptions
  • Propagate Exceptions
  • RAISE_APPLICATION_ERROR Procedure
Module 10:Stored Procedures
  • Create a Modularized and Layered Subprogram Design
  • Modularize Development With PL/SQL Blocks
  • Understand the PL/SQL Execution Environment
  • List the benefits of using PL/SQL Subprograms
  • List the differences between Anonymous Blocks and Subprograms
  • Create, Call, and Remove Stored Procedures
  • Implement Procedures Parameters and Parameters Modes
  • View Procedure Information
Download Course Contents

Request More Information

Course Prerequisites
  • Basic Computer Knowledge.
  • Manage dependencies between PL/SQL subprograms
  • Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
  • Create stored procedures and functions
  • Use conditional compilation to customize the functionality in a PL/SQL application without removing any source code
  • Use the Oracle supplied PL/SQL packages to generate screen output, file output and mail output
  • Write dynamic SQL for more coding flexibility
  • Create overloaded package subprograms for more flexibility
  • Create triggers to solve business challenges
  • Create and debug stored procedures and functions
  • Describe the features and syntax of PL/SQL
  • Design PL/SQL anonymous blocks that execute efficiently
  • Design PL/SQL packages to group related constructs
  • Handle runtime errors