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

Download Course Contents

11g: Program with PL/SQL 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
  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Methodology
Flexible Dates
4-Hour Sessions
  • • View video
  • • The course will be free if we are not able to start within 7 days of booking.
  • • Only applicable for courses on which this logo appears.

Your will learn:

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
  • Understanding the benefits and structure of PL/SQL
  • Understanding PL/SQL Blocks
  • Generating output messages in PL/SQL
  • Identifying valid and invalid identifiers
  • Declaring and initializing variables
  • Various data types
  • Identifying the benefits of using the %TYPE attribute
  • Using bind variables
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
Live Online Training (Duration : 40 Hours)
Group Training 1650 Per Participant Incl. Official Courseware
30 May - 03 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
06 - 10 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 - 08 Jul 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training 3300 1850 + If you accept merging of other students. Incl. Official Courseware
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Can’t Attend Live Online? Buy Flexi For Only $99 (Video Recording of Live Online)
Ultra-Fast Track

If you can't spare 40 hours. We can offer you an Ultra-Fast Track for 20 hours for only USD 1,480

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

Trending Technologies

 Cloud Computing
 Security
 Fundamentals
 CRM
 Cloud Architect
 Cloud Administration
 Data Analytics
 DevOps
 System Administration
 Virtualization

Request More Information

Add Name and Email Address of participant (If different from you)

Privacy Policy

FAQ's

Yes, fee excludes local taxes.
The Fee includes:
  • Official courseware
  • Testing Via Qubits
  • Remote Labs
Yes, Koenig Solutions is a Oracle Learning Partner