Oracle Database 11g: Program with PL/SQL Training Course (1Z0-144)

11g: Program with PL/SQL Certification Training Course Overview

The 11g: Program with PL/SQL training course you will learn to the PL/SQL programming language. In the class, students learn to create PL/SQL blocks of application code.

Who Should do this course?

  • Database Administrators
  • 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 11g: Program with PL/SQL Training Course (1Z0-144) (Duration : 40 Hours) Download Course Contents

Live Virtual Classroom 1850
Group Training
18 - 22 Oct GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

01 - 05 Nov GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

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

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

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 and Class Account Information
  • The Human Resources (HR) Schema
  • Appendices Used in this Course
  • PL/SQL Development Environments
Module 2:Introduction to PL/SQL
  • Understanding the benefits and structure of PL/SQL
  • Understanding PL/SQL Blocks
  • Generating output messages in PL/SQL
Module 3:Declaring PL/SQL Variables
  • Identifying valid and invalid identifiers
  • Declaring and initializing variables
  • Various data types
  • Identifying the benefits of using the %TYPE attribute
  • Using bind variables
Module 4:Writing Anonymous PL/SQL blocks
  • Lexical Units in a PL/SQL Block
  • Using SQL Functions in PL/SQL
  • Data Type Conversion
  • Using Nested Blocks as Statements
  • Referencing an Identifier Value in a Nested Block
  • Qualifying an Identifier with a Label
  • Operators in PL/SQL
  • Using Sequences in PL/SQL Expressions
Module 5: Using SQL Statements within a PL/SQL Block
  • Using SQL Statements in PL/SQL
  • Retrieving Data in PL/SQL with the SELECT statement
  • Using Naming Conventions in DML Statements and data retrieval
  • Manipulating Data on the Server Using PL/SQL
  • SQL Cursors
  • Using SQL Cursor Attributes to Obtain Feedback on DML
  • Saving and Discarding Transactions
Module 6:Writing Control Structures
  • Controlling PL/SQL Flow of Execution
  • Using IF and CASE Statements for conditional processing
  • Handling Nulls
  • Building Boolean Conditions with Logical Operators
  • Using Iterative Control with Loop Statements
Module 7:Working with Composite Data Types
  • Composite Data Types of PL/SQL Records and Tables
  • Using PL/SQL Records
  • Inserting and Updating PL/SQL Records
  • Using INDEX BY Tables
  • Using Associative arrays
  • Declaring and Using VArrays
Module 8:Using Explicit Cursors
  • Cursors
  • Explicit Cursor Operations
  • Controlling Explicit Cursors
  • Using Explicit Cursors to Process Rows
  • Cursors and Records
  • Cursor FOR Loops Using Subqueries
  • Explicit Cursor Attributes
  • %NOTFOUND and %ROWCOUNT Attributes
Module 9:Handling Exceptions
  • Concept of Exception
  • Handling Exceptions with PL/SQL
  • Predefined Exceptions
  • Trapping Predefined and Non-predefined Oracle Server Errors
  • Functions that Return Information on Exceptions
  • Usage of PRAGMA keyword
  • Trapping User-Defined Exceptions
  • Propagating Exceptions
Module 10:Creating Stored Procedures and Functions
  • Overview of Stored Procedures and Functions
  • Differentiating between anonymous blocks and subprograms
  • CREATE OR REPLACE PROCEDURE | FUNCTION
  • Understanding the Header Area of a Stored Procedure and Function
  • Creating Simple Procedures and Functions
  • Creating a Simple Procedure with an IN Parameter
  • Executing a Procedure and a Function
Download Course Contents

Request More Information

Course Prerequisites
  • Familiarity with data processing concepts and technique
  • Familiarity with programming languages
  • Oracle Database 12c: Introduction for Experienced SQL Users

On Completion of this course you will be able to:-

  • Introduction
  • Introduction to PL/SQL
  • Declaring PL/SQL Variables
  • Writing Anonymous PL/SQL blocks
  • Using SQL Statements within a PL/SQL Block
  • Writing Control Structures
  • Working with Composite Data Types
  • Using Explicit Cursors
  • Handling Exceptions
  • Creating Stored Procedures and Functions