SkillBuilders Welcome  |  Log in
All Oracle Classes

Advanced Oracle 11g PL/SQL Programming
Two Day Onsite / 14 Hour Online Hands-On Training.

Oracle PL/SQL developers will learn to use advanced features enabling improved programming and enhanced performance.

Upon successful completion of this course, class attendees should, with the aid of appropriate documentation be able to:

  • Use advanced features of Oracle-supplied packages to enrich applications
  • Maximize performance of PL/SQL through design and tuningUse Oracle object features including User-Defined Types, Nested Tables,Varrays, REFs, and Object Views via PL/SQL
  • Use advanced data handling functionality including collections and bulk bind
  • Know when dynamic SQL may be used to improve performance or functionality
  • Create PL/SQL that uses external applications and the operating system
  • Design and use PL/SQL packages, procedures, functions, and triggers to maximize performance
  • Become aware of PL/SQL's new features and how to use them
  • Use XML from PL/SQL
Average Student Rating:
Charles Fursdon Sherwin Williams
[What did you particularly like about the course?] Width of subjects covered, teacher interaction with student questions and examples given.

Brian Leahy Sherwin Williams
it was all great

Daniel Latarski Sherwin Williams
[suggestions for improving the online software or delivery techniques?] none

Instructor was knowledgeable and had very good examples.

The depth of the topic could be extended to an additional day. More time to work on exercises.

Jasna Klenjoska Sherwin Williams
The teacher new his material and he was very helpful.

Everything was good

Therese Parish Sherwin Williams
We had plenty of hands-on exercises which helps reinforce the learning topics

SkillBuilders Sample Video