About Us
Free Tools
Contact Us
Activia for Oracle Pl/sql Advanced
Tutor led training that gets results
Bookings and Enquiries:
Customer Service:
0333 6000 111
0333 6000 555
Icon for Oracle® PL/SQL Advanced

Oracle® Foundation Courses From Activia

Oracle® PL/SQL Advanced

Contact information Click to request a callback
A Three-Day Training Course
Course Outline
About the Course
Dates and Venues
More Information
Course Outline

This course is a three-day training course structured into 11 modules.

Module 1
Designing Pl/Sql Code For Performance
Topics covered
  • Oracle Predefined Data Types
  • Create Subtypes Based on Existing Types for an Application
  • Guidelines for Cursor Design
  • Use Cursor Variables
  • Pass Cursor Variables as Program Parameters
  • Compare Cursor Variables to Static Cursors
  • 0
    Module 2
    Use Collections
    Topics covered
  • Overview of Collections
  • Associative Arrays
  • Nested Tables
  • Varrays
  • Create PL/SQL Programs that use Collections
  • Use Collections Effectively
  • 0
    Module 3
    Advanced Interface Methods
    Topics covered
  • The Benefits of External Routines
  • External Routine Components
  • Call an OS Supplied DLL
  • Call Java from PL/SQL
  • Call C from PL/SQL
  • Call Java from PL/SQL
  • 0
    Module 4
    Vpd And Fine-Grained Access Control
    Topics covered
  • Overview of Fine-Grained Access Control
  • The Features of Fine-Grained Access Control
  • Overview of an Application Context
  • Create an Application Context
  • Set an Application Context
  • Describe the Package DBMS_RLS
  • Implement a Policy
  • Query the Data Dictionary for Fine-Grained Access Control
  • Information
  • 0
    Module 5
    Manipulate Large Objects
    Topics covered
  • Overview of a LOB Object
  • Manage Internal LOBs
  • Character Large Objects
  • Binary Large Objects
  • External Large Objects - BFILEs
  • Create and Use the DIRECTORY Object to Access and Use BFILEs
  • The DBMS_LOB Package
  • Delete LOBs
  • Create a Temporary LOB using the Package DBMS_LOB
  • 0
    Module 6
    Administer Securefile Lobs
    Topics covered
  • Overview of SecureFile LOBs
  • Configure the Environment for SecureFile LOBs
  • Store Documents using SecureFile LOBs
  • Convert BasicFile LOBS to SecureFile LOBs
  • Evaluate the Performance of SecureFile LOBs
  • Establish Space Utilization of a LOB File
  • Set up Encryption
  • Enable Compression and Deduplication
  • 0
    Module 7
    Tuning Pl/Sql Code For Performance
    Topics covered
  • Understand the PL/SQLCompiler
  • Influence the Compiler
  • Tuning PL/SQL Programs
  • Tuning SQL
  • Reducing the Number of SQL Calls
  • PL/SQL Tuning
  • PL/SQL Native Compilation
  • 0
    Module 8
    Use Sql And Pl/Sql Caching To Improve Performance
    Topics covered
  • The Importance of the Shared Pool
  • Library Cache
  • The Data Dictionary Cache
  • Pinning Code in the Shared Pool
  • SQL and PL/SQL Caching
  • PL/SQL Function Cache
  • 0
    Module 9
    Analyze Pl/Sql Code
    Topics covered
  • Use Data Dictionary Views to View Coding Information
  • Use Supplied Packages to View Coding Information
  • Use the DBMS_METADATA Package to View Metadata as XML
  • Use the DBMS_METADATA Package to Create DDL that can be used to Re-create Objects
  • Determine Identifier Types and Usages with PL/Scope
  • 0
    Module 10
    Profile and Trace PL/SQL Code
    Topics covered
  • Trace PL/SQL Program Execution
  • Profile PL/SQL Applications
  • Access the Trace Data
  • 0
    Module 11
    Safeguard Code
    Topics covered
  • Overview of SQL Injections
  • Detecting Attacks
  • Review of Dynamic SQL
  • The Attack Surface
  • Typical SQL Attacks
  • Reduce Attack Surfaces
  • Use the DBMS_ASSERT Package
  • Design Immune Code
  • Test Code for SQL Injection Flaws
  • 0 0

    About the Course

    Headline details for Oracle PL/SQL Advanced.

    Course Aims

    By the end of this Oracle Advanced PL/SQL course, delegates will be able to effectively tune PL/SQL code; create subtypes; create and use collections; execute external C programs and Java programs from PL/SQL; use fine-grained access control; use LOB data types and the DBMS_LOB package; use SecureFile LOBs; effectively design cursors; improve memory usage with PL/SQL result caching and SQL result sets and apply coding standards to avoid SQL injection attacks.

    Target Audience

    This course is designed for Oracle database administrators and software development personnel who need to gain practical experience of the advanced features of PL/SQL such as program design, packages, cursors, large objects and collections.
    NOTE: Practical experience of Oracle SQL or SQL Developer and a good working knowledge of the fundamentals of the PL/SQL programming language are required.


    This Oracle Advanced PL/SQL course is suitable for delegates intending to sit the Oracle examination #1Z0-146: Oracle Database 11g: Advanced PL/SQL.
    Exams are not included as part of the course.
    Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.

    Follow On Courses

    • Oracle 10g SQL Performance Tuning
    • Oracle 11g SQL Performance Tuning
    • Oracle Database 10g DBA - Part I
    • Oracle Database 11g Release 2 DBA - Part I

    Dates and Venues  for our public classes

    Click on 'Book now' against the class you wish to book.

    Oracle PL/SQL Advanced
    Oct 26, 2015
    London Barbican
    Book Now
    Nov 18, 2015
    London Barbican
    Book Now
    Dec 14, 2015
    London Barbican
    Book Now
    Jan 11, 2016
    London Barbican
    Book Now
    Prices:  Oracle PL/SQL Advanced
    Please note : all prices exclude VAT.
    Scheduled public classes
    [The simplest and most cost-effective option for 1, 2 or 3 delegates]
    •  Oracle PL/SQL Advanced
    First delegate: £1,199
    2nd delegate: £1,129
    3rd delegate +: £1,059 each
    To view scheduled dates, click the "Dates" button on the right

    We do not deliver classes at customer offices for

    More Information:
    Oracle PL/SQL Advanced

    All training courses use the latest content, qualified and experienced trainers, and provide delegates with the best learning experience. Training is interactive and classroom-based, and the ability to ask questions reinforces knowledge acquisition during the class.

    Class sizes

    Maximum class sizes vary, but there is always adequate time for delegates to ask questions of the instructor.

    How to book
    • Decide on the course you want, the date(s) you can attend, and the number of delegates involved
    • if at any time you want help or advice, or you want to book on the telephone, just call us on 0845 230 6150 to speak to one of our friendly training advisors

    Note: With non-credit card bookings you must sign and return a Booking Form before we can confirm your training.

    Also note: If you are a private individual you must pay by credit card at the time of booking.

    The confirmation process
    • Your place is allocated, along with workbooks (and lunches if it's at our centre)
    • You receive an official confirmation, with joining instructions (and directions if it's at our centre)
    • You receive a VAT invoice

    Note: Please allow 1 - 2 working days for your confirmation and invoice.

    What happens on the day

    If you are coming to our centre, dress code is smart casual.   The timetable is as follows:

    • 9:15: - Arrival time
    • 9:30: - Training starts
    • 11:00: - Mid-morning break
    • 1:00: - Lunch break (one hour)
    • 3:15: - Mid-afternoon break
    • 4:30: - Wrap up

    Note: break times can vary according to the needs of the training, and course duration for smaller class sizes can be shorter because fewer delegates have fewer questions !

    What you get

    With your training course from Activia, you get a free workbook, so you can review and revise afterwards to reinforce your knowledge.

    Quick Links Icon for Oracle® PL/SQL Advanced
    Quick Links
    Related  courses
    Related courses

    Oracle® Foundation Courses from Activia

    Activia Training logo

    We can provide courses for Oracle Foundation at any of our ten centres UK wide, or we can come to your offices – if you have groups of staff who need training, this is a particularly convenient, flexible and cost effective option.

    We have been training business all over the UK since 1995 and have continually developed our philosophy of high quality, flexible and cost effective provision of courses for Oracle Foundation.   This means you can be confident that we have the expertise, and the experience, to give all you need with training skills course in Oracle Foundation.

    Activia Training logo
    Quality Assurance
    Quality assurance from Activia Training
    Privacy Policy     |     Terms & Conditions     |     Blog     |     Course Finder     |     Request a callback