CompuWorks Class Information Oracle Database 11g: Advanced PL/SQL Programming & Tuning Description: The objective of this course is to allow 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. Days: 5 Prerequisites: Oracle Database 11g: Introduction to SQL and Oracle Database 11g: Program With PL/SQL Audience: The target audience for this course is senior application developers. Developers who will be building, debugging andtuning PL/SQL program units will benefit from this course. USING SQL DEVELOPER · PREPARING THE EXECUTION ENVIRONMENT · INSTALLING SQL DEVELOPER · BASIC CONNECTION TYPE · TNS CONNECTION TYPE · ADVANCED CONNECTION TYPE · MANAGING CONNECTIONS · EXECUTING EXTERNAL SCRIPTS · USING BIND VARIABLES FROM SQL DEVELOPER USING THE DATABASE RESULT CACHE · CONFIGURING THE RESULT CACHE · USING THE RESULT CACHE 1 / 5 CompuWorks Class Information · MANAGING & MONITORING THE RESULT CACHE ORACLE BASICFILES & SECUREFILES · LOB CONCEPTS & TERMINOLOGY · BASICFILES LOB · TABLE DDL WITH LOBS · CONTROLLING LOB PHYSICAL STORAGE · INITIALIZE INTERNAL LOBS · INITIALIZE EXTERNAL LOBS · LOB COLUMNS & SQL · SECUREFILES LOBS · MIGRATING BASICFILES TO SECUREFILES · MONITORING SECUREFILES PERFORMANCE DATABASE-RESIDENT PROGRAM UNIT ENHANCEMENTS · MIXED NOTATION PROCEDURE REFERENCES · CREATING DISABLED TRIGGERS · CONTROLLING THE ORDER OF TRIGGER EXECUTION · DEVELOPING COMPOUND TRIGGERS · 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() 2 / 5 CompuWorks Class Information · WHY RETRIEVE...
Website: www.compuworks.com | Filesize: 587kb
No of Page(s): 5
Download Oracle Database 11g: Advanced PL/SQL Programming & Tuning.pdf
No comments:
Post a Comment