Menu
Live Chat
Contact Us
Scheduling Tool
0800 282 353
 

Home ❯ Oracle

PDF Add to WishList









Preferred method of contact:

Oracle PL/SQL Programming

COURSE TYPE

Intermediate

Course Number

493

Duration

5 Days
Reserve Your Seat

PDF Add to WishList

Increase the productivity, performance, scalability, portability, and security of your Oracle database with this comprehensive PL/SQL programming course. With this training, you learn to write PL/SQL programs, build stored procedures, design and execute modular applications, and increase the efficiency of data movement — essential skills for any Oracle developer.

You Will Learn How To

  • Develop efficient PL/SQL programs to access Oracle databases
  • Create stored procedures and functions for reuse and maintenance
  • Design modular applications using packages
  • Manage data retrieval for front-end applications
  • Invoke native dynamic SQL to develop high-level abstract code

Important Course Information

Requirements:

  • Knowledge at the level of:

Software:

  • This course is currently running on Oracle 12c

Course Outline

  • Introduction and Overview

PL/SQL fundamentals

  • Declaring and anchoring variables to database definitions
  • Flow control constructs

Oracle® 11g and 12c PL/SQL features

  • PL/Scope in Oracle 11g
  • Returning implicit cursor results from stored procedures in Oracle 12c
  • Declaring local functions within SELECT statements in Oracle 12c
  • Data Manipulation Techniques

Maintaining data with DML statements

  • Employing the RETURNING INTO clause
  • Solving the fetch-across-commit problem

Managing data retrieval with cursors

  • Implications of explicit and implicit cursors
  • Simplifying cursor processing with cursor FOR LOOPs
  • Embedding cursor expressions in SELECT statements

Cursor variables

  • Strong vs. weak cursor variables
  • Passing cursor variables to other programs
  • Defining REF CURSORS in packages
  • Developing Well-Structured and Error-Free Code

Error handling using EXCEPTIONs

  • Propagation and scope
  • "Retrying" problem transactions with EXCEPTION processing

Debugging PL/SQL blocks

  • Simplifying testing and debugging with conditional compilation
  • Interpreting compiler messages
  • Applying structured testing techniques
  • Building and applying a test bed
  • Leveraging the debugging facilities in SQL Developer
  • Achieving Maximum Reusability

Writing stored procedures and functions

  • Calling and invoking server-side logic
  • Passing input and output parameters
  • Implementing an autonomous transaction

Coding user-written functions

  • Calling PL/SQL functions from SQL
  • Building table-valued functions

Developing safe triggers

  • Employing :OLD and :NEW variables
  • Avoiding unreliable trigger constructs
  • Exploiting schema and database triggers
  • Exploiting Complex Datatypes

Collection types

  • PL/SQL tables, nested tables, VARRAYs
  • Stepping through dense and nonconsecutive collections

Bulk binding for high performance

  • Moving data into and out of PL/SQL blocks
  • BULK COLLECT INTO and FORALL
  • BULK cursor attributes
  • BULK EXCEPTION handling
  • Invoking Native Dynamic SQL

Finessing the compiler

  • The EXECUTE IMMEDIATE statement
  • The RETURNING INTO clause

Types of dynamic SQL

  • Building SQL statements during runtime
  • Autogenerating standard code
  • Package Tips and Techniques
  • Package structure: SPEC and BODY
  • Eliminating dependency problems
  • Overloading for polymorphic effects
  • Evaluating application frameworks
  • Declaring and using persistent global variables
Show complete outline
Show Less

Convenient Ways to Attend This Instructor-Led Course

Hassle-Free Enrolment: No advance payment required to reserve your seat.
Tuition Fee due 30 days after you attend your course.

In the Classroom

Live, Online

Private Team Training

0800 282 353

info@LearningTree.co.uk

In the Classroom — OR — Live, Online

Tuition Fee — Standard: £2445  

29 Jul - 2 Aug ( 5 Days)
9:00 AM - 4:30 PM BST London / Online (AnyWare) London / Online (AnyWare) Reserve Your Seat

16 - 20 Dec ( 5 Days)
9:00 AM - 4:30 PM GMT London / Online (AnyWare) London / Online (AnyWare) Reserve Your Seat

23 - 27 Mar ( 5 Days)
9:00 AM - 4:30 PM GMT London / Online (AnyWare) London / Online (AnyWare) Reserve Your Seat

AFTERNOON START: Attend these live courses online via Anyware

19 - 23 Aug ( 5 Days)
2:00 PM - 9:30 PM BST Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

16 - 20 Sep ( 5 Days)
2:00 PM - 9:30 PM BST Alexandria, VA / Online (AnyWare) Alexandria, VA / Online (AnyWare) Reserve Your Seat

7 - 11 Oct ( 5 Days)
2:00 PM - 9:30 PM BST New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

10 - 14 Feb ( 5 Days)
2:00 PM - 9:30 PM GMT Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

16 - 20 Mar ( 5 Days)
1:00 PM - 8:30 PM GMT Alexandria, VA / Online (AnyWare) Alexandria, VA / Online (AnyWare) Reserve Your Seat

Show all dates
Show fewer dates

Guaranteed to Run

When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time, location — will run. Guaranteed.

Private Team Training

Enrolling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training.

For details, call 0800 282 353 or Click here »

This event has been added to your cart.

Tuition Fee

Standard

In Classroom or
Online

Standard

£2445

Private Team Training

Contact Us »

Course Tuition Fee Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

Free Course Exam
You can take your Learning Tree course exam on the last day of your course or online any time after class.

Prev
Next

Training Hours

Standard class hours:
9:00 a.m. - 4:30 p.m.

Last day class hours:
9:00 a.m. - 3:30 p.m.

Free Course Exam – Last Day:
3:30 p.m. - 4:30 p.m.

Each class day:
Informal discussion with instructor about your projects or areas of special interest:
4:30 p.m. - 5:30 p.m.

AFTERNOON START class hours:
2:00 p.m. - 9:30 p.m.


Last day class hours:
2:00 p.m. - 8:30 p.m.


Free Course Exam – Last Day:
8:30 p.m. - 9:30 p.m.


Each class day:
Informal discussion with instructor about your projects or areas of special interest
9:30 p.m. - 10:30 p.m.

“The section on triggers and the presentation of the listagg function have become very useful in my daily programming”.

- S. Der, Software Developer
Harris

Prev
Next
Chat Now

Please Choose a Language

Canada - English

Canada - Français