Oracle Advanced PL SQL & Query Tuning Training Course Tutorial

Course Description


This advanced Oracle database developer course is meant for those who are looking for advanced pl sql query tutorial course. It is also relevant for those preparing for Oracle certifications like ocp on the Oracle developer track. This advanced pl sql Oracle course expects participants to be familiar with database basics and the sql and pl sql language. We work towards advanced PL SQL programming language for everyday database tasks. Participants looking at Oracle certification for in depth query performance tuning will find this as a very useful foundation course which gives them knowledge of practical concepts and query performance tuning. As there are not many online oracle classes and very few training institutes to teach Oracle database or sql, we make it completely hands on Oracle db pl sql tutorial teaching what participants need to know for working on the job everyday. We give them many examples at the training center to work on. You come out to be a very confident Oracle sql developer after this tutorial course.

Free Career Guidance

Fee Details

Course Code Course Name Duration Course Fees (SGD)

OracleTM Advanced PLSQL & Query Tuning

2 Days
(16 Hrs)
$ 1797
Registration & Material Fees of $S 50 Applies.
Register your interest by filling the form below
Email Me Full Details Course Content Related Courses Funding Options Corporate Clients


Get All Details About This Course Now!

Course Content

Click Here To View Fee Details
Module 1: Designing PL/SQL code for Performance
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
Module 2: Use Collections
Overview of Collections
Associative Arrays
Nested Tables Vs arrays
Create PL/SQL Programs that use Collections
Use Collections Effectively
Module 3: Advanced Interface Method
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
Module 4: Using Dynamic SQL
Execute Immediate - Basic usage
Usage of bind variables in Dynamic SQL
REF Cursors and Dynamic SQL
Module 5: Manipulate Large Objects
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
Module 6: Administer SecureFile LOBs
Overview of SecureFile LOBs
Configure the Environment for SecureFile LOBs
Store Documents using SecureFile LOBs
Store Documents using SecureFile LOBs
Convert BasicFile LOBS to Secure File LOBs
Evaluate the Performance of SecureFile LOBs
Establish Space Utilization of a LOB File
Set up Encryption
Enable Compression and Deduplication
Module 7: Tuning PL/SQL Code For Performance
Understand the PL/SQL Compiler
Influence the Compiler
Tuning PL/SQL Programs
Tuning SQL
Reducing the Number of SQL Calls
PL/SQL Tuning
PL/SQL Native Compilation
Module 8: Use SQL & PL/SQL Caching To Improve Performance
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
Module 9: Analyze PL/SQL Code
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
Module 10: Profile & Trace PL/SQL Code
Trace PL/SQL Program Execution
Profile PL/SQL Applications
Access the Trace Data



This is an advanced course on Oracle PLSQL programming, hence participants should have good knowledge and experience of working in Oracle database environment and must know SQL and PLSQL.

Funding For This Course

Click the course name below to get full details.

OracleTM Database SQL/PLSQL Basics For Beginners OracleTM DBA Basics For Beginners
Unix / Linux Basics For Beginners Tutorial

Audience For This Course

PL/SQL is the de facto language used in OracleTM database. This course is intended for Database Developers in particular who need to work with PL/SQL everyday.

This course needs prior knowledge of database and SQL / PLSQL.

Training Duration

Full-Time : 9.30am to 6.30pm

Part-Time : Weekdays - 10.00am - 1.00pm (or) 2.00pm - 5.00pm

Part-Time : Weekends (Saturday & Sunday) - 10.00am - 1.00pm (or) 2.00pm - 5.00pm

Training Methodology & Materials

  1. 100% hands-on Practical Job Oriented Training
  2. Well designed exercises/sessions
  3. Discussion on real life situations / problems faced on the job and their solutions
  4. Indepth Project work with each course to enhance learning and give the participant a feel of difficulty, thus ensuring they apply in realtime everything they have learnt.
  5. Task based teaching methodology where students are given tasks to do in class, as required in the real world.
  6. Assessments at the end of the course help gauge student progress and learning.

Certificate Of Attendance

Certificate Of Attendance will be awarded to participants completing the course achieving minimum 85% attendance.

View All Testimonials
View Hand-Written Feedback Forms

* Oracle is a registered trademark of Oracle Corporation and it is used here only for listing of the course; we own no rights on the Oracle trademark.