An essential component of client/server application development is the creation of database server-side program units. This course discusses the subjects of database triggers and stored procedures. Advanced topics such as using system-supplied packages, programming for superior performance, object oriented encapsulation of logic into packages and many others are discussed in detail.
Oracle Training Prerequisites
- The course Introduction To Oracle9i SQL
- The course Introduction To Oracle9i Advanced SQL
- The course Introduction To Oracle9i PL/SQL Language
Suggested Next Courses
- The course Oracle 9i New & Advanced Features For Developers or
- The course Oracle 9iDS Forms I: Build Internet Applications
Oracle Training Audience
Oracle developers and database administrators
Oracle Training Objectives
- Build comprehensive database triggers
- Build new Oracle9i system triggers
- Developer stored procedures and functions
- Encapsulate program units into packages
- Use Oracle Procedure Builder for debugging and code development
Oracle Training Course duration
3 Days
Oracle Training Course outline
UNDERSTANDING THE TUNING ISSUES
USING TKPROF & AUTOTRACE
USING THE STATSPACK UTILITY SETTING SNAMPSHOT LEVELS & SQL THRESHOLDS MAINTAINING THE STATISTICS PERFORMANCE TABLES
EXPLOITING & MANAGING CURSOR SHARING BIND VARIABLES & CURSOR PEEKING USING THE CURSOR_SHARING PARAMETER
USING CURSOR VARIABLES USING SYS_REFCURSOR
INVOKING EXTERNAL PROCEDURES REGISTERING WITH THE DATABASE ORACLE NET CONFIGURATION
ADVANCED PROGRAM UNITS USING INVOKER RIGHTS NATIVE DYNAMIC SQL AUTONOMOUS TRANSACTIONS
USING COLLECTIONS BULK BIND USING COLLECTIONS COLLECTION METHODS
PL/SQL TUNING WITH DBMS_PROFILER() INSTALLING DBMS_PROFILER() USING DBMS_PROFILER() TO MANAGE RUNS
EVALUATING THE PL/SQL PROFILER DATA USER QUERIES OF THE CROSS RUN TABLES SYSTEM-SUPPLIED CROSS RUN TABLES QUERIES
PL/SQL TUNING TECHNIQUES USING NOCOPY FOR PARAMETERS USING THE RETURNING CLAUSE CHOOSING THE OPTIMUM DATATYPE USEFUL PL/SQL CODING TECHNIQUES
PL/SQL DEBUGGING WITH DBMS_TRACE() INSTALLING DBMS_TRACE() USING DBMS_TRACE() TO MANAGE RUNS
EXAMINING THE PLSQL_TRACE_ ... TABLES
