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

Overview Schedule & Fees Course Benefits Student Feedback FAQ Course Modules

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 18 - 22 Oct 09:00 AM - 05:00 PM CST (8 Hours/Day) 01 - 05 Nov 09:00 AM - 05:00 PM CST (8 Hours/Day) 06 - 10 Dec 09:00 AM - 05:00 PM CST (8 Hours/Day)	1-on-1 Training (GTR) 3600 4 Hours 8 Hours Week Days Weekend Start Time : At any time 12 AM 12 PM Training Schedule: GTR=Guaranteed to Run

Special Solutions for Corporate Clients! Click here

Hire Our Trainers! Click here

Customers who bought this course also bought

Developing Applications for the Java EE 7 Platform Ed 1

Oracle Database 19C:Administration Workshop Certification Training Course

Oracle SQL Certification Training Course

R12.x Oracle General Ledger Management Fundamentals

10% discount on 2nd course:

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

Request a call back?

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