Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
Business Analysis
Business Intelligence
Business Objects
Business Skills
C++ programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Datawarehousing
DB2
Desktop Application Software
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Oracle Database 10g: Advanced PL/SQL Programming & Tuning
Oracle Training Overview

This Oracle 10g courseware training guide book will teach experienced PL/SQL developers to write efficient programs. Advanced techniques which not only improve execution speed but also enhance the functionality of the programs are also discussed.

Oracle Training Prerequisites

  • The course Oracle Database 10g: Introduction to SQL - Complete Library
  • The course Oracle Database 10g: Program With PL/SQL - Complete Library
Oracle Training Audience

The target audience for this course is senior application developers. Developers who will be building, debugging and tuning PL/SQL program units will benefit from this course.

Oracle Training Objectives

Among the specific objectives to be met with this course are these:
  • Exploiting and managing cursor sharing.
  • Utilizing cursor variables.
  • Invoking external procedures.
  • Including dynamic SQL and other advanced programming techniques.
  • Efficiently executing dynamic SQL using bulk bind techniques.
  • Tuning with the DBMS_PROFILER() system-supplied package.
  • Debugging with the DBMS_TRACE() system-supplied package.
  • Performance tuning and analysis of PL/SQL applications
Oracle Training Course duration

4 Days

Oracle Training Course outline

PL/SQL DEVELOPMENT SUPPORT FROM EM
  • ABOUT EM & PL/SQL
  • MANAGING INVALID OBJECTS
EXPLOITING & MANAGING CURSOR SHARING
  • ABOUT CURSOR SHARING
  • BIND VARIABLES & CURSOR PEEKING
  • USING THE CURSOR_SHARING PARAMETER
DYNAMIC SQL
  • NATIVE DYNAMIC SQL
USING COLLECTIONS
  • ABOUT COLLECTIONS
  • BULK BIND USING COLLECTIONS
  • COLLECTION METHODS
RETRIEVING DDL WITH DBMS_METADATA()
  • WHY RETRIEVE OBJECT DEFINITIONS?
  • RETRIEVING DEFAULT METADATA
  • RETRIEVING CUSTOMIZED METADATA
ADVANCED DBMS_METADATA() PROCESSING
  • SET_TRANSFORM_PARAM()
  • GET_QUERY()
PROCESSING DEPENDENT OBJECTS WITH DBMS_METADATA()

REDEFINING TABLES WITH DBMS_REDEFINITION()
  • ABOUT TABLE REDEFINITION
  • USING THE DBMS_REDEFINITION() PACKAGE
USING OTHER SYSTEM-SUPPLIED PACKAGES
  • DBMS_DESCRIBE()
  • UTL_MAIL
  • DBMS_SCHEDULER()
USING LARGE OBJECTS (LOBS) ADVANCED INTERFACE METHODS
  • ABOUT EXTERNAL PROCEDURES
  • REGISTERING WITH THE DATABASE
  • ORACLE NET CONFIGURATION
  • CALLING EXTERNAL PROCEDURES
ABOUT PL/SQL PERFORMANCE TUNING
  • ABOUT THE TUNING EFFORT
  • THE DIFFICULTY OF TUNING
  • THE SQL & PL/SQL EXECUTION ENVIRONMENT
  • THE IMPACT OF THE SYSTEMS INFRASTRUCTURE
USING THE TUNING UTILITIES

INFLUENCING ORACLE10G PL/SQL COMPILATION
  • PLSQL_WARNINGS
  • PLSQL_OPTIMIZE_LEVEL
  • PL/SQL NATIVE EXECUTION
PL/SQL TUNING WITH DBMS_PROFILER()
  • ABOUT DBMS_PROFILER()
  • INSTALLING DBMS_PROFILER()
  • USING DBMS_PROFILER() TO MANAGE RUNS
  • EXAMINING THE PROFILER TABLES
EVALUATING THE PL/SQL PROFILER DATA
  • ABOUT THE PROFILER DATA
  • USER QUERIES OF THE CROSS RUN TABLES
  • SYSTEM-SUPPLIED CROSS RUN TABLES QUERIES
PL/SQL ADVANCED PROGRAMMING & TUNING TECHNIQUES
  • AUTONOMOUS TRANSACTIONS
  • USING NOCOPY FOR PARAMETERS
  • CHOOSING THE OPTIMUM DATATYPE
  • USEFUL PL/SQL CODING TECHNIQUES
PL/SQL DEBUGGING WITH DBMS_TRACE()
  • ABOUT THE TRACE FACILITY
  • INSTALLING DBMS_TRACE()
  • USING DBMS_TRACE() TO MANAGE RUNS
  • EXAMINING THE PLSQL_TRACE_... TABLES

 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy