TruTek

Intermediate Oracle PL/SQL Tips and Techniques

Give your IT staff the knowledge of using features of Oracle's procedural language:  PL/SQL.

The focus of this course is to increase attendee knowledge of the PL/SQL programming language.  This is an excellent course for those people that need a better knowledge of the PL/SQL language.  This course covers all the latest features of PL/SQL using databases Oracle 9i, Oracle 10g, and Oracle 11g.

The attendees have the opportunity to learn how to find the poorly-performing components of PL/SQL routines, use Oracle's newer DEBUG routines to find problems in PL/SQL logic and how to use the latest features of the PL/SQL language such as the new optimizing compiler and collections.

The course utilizes a variety of current tools.  Students will have the opportunity to learn more about TOAD, SQL Developer, as well as the Oracle tools like SQL*Plus.

Workshop Prerequisites

      Basic knowledge of and experience with SQL and PL/SQL is required.

Topics Covered

- Oracle Architecture

- Introduction to PL/SQL

• Syntax and language structure review

- PL/SQL Topics

• Package Usage (both User Defined and Oracle Defined Packages)
• Profiling/Debugging/Compiling
• Cursor Sharing/Cursor Variables
• Collections
• Dynamic SQL
• Autonomous Transactions
• PL/SQL Coding Tips
• Debugging PL/SQL
• PL/SQL Profiling
• Tracing PL/SQL

Attendees Receive

• Study guide and relevant white papers
• Diskette full of useful SQL and SQL*Plus scripts
• A hands-on opportunity to learn more about Oracle, TOAD, and SQL Developer