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
   Recording Available only $99

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

Top Trending Technologies

 Cloud Computing Certification Training Courses
 IT Security and Cybersecurity Certification Courses
 Fundamentals Training and Certification Courses
 System Administration Training and Certification Courses
 Cloud Architect Certification Training Courses
 CRM Training and Certification Courses
 Big Data Analytics Courses & Certification Training
 Data Analytics Certification and Training Courses
 Security Testing Training & Certification Courses
 Programming Courses Training and Certification

FAQ's