Advanced PL/SQL Tips and Techniques

 

 

 

 

 

 

 

Course name: Advanced PL/SQL Tips & Techniques

Dates: 16th, 17th & 18th May 2018 (3 Days)

Venue: Professional Training Solutions, Building 6500 E, Cork Airport Business Park

Training provider: Professional.ie (Dan Hotka, US Expert, see bio below)

Member fee: €700 (or  €1000 for this course plus the 2 day Oracle SQL Performance Tuning tips & Techniques, 14th & 15th April 2018)

Non-member fee: €1000

To Register your interest or to book a place on this course please email Annette Coburn on skillnet@itcork.ie

 

Description:

Give your IT staff the knowledge of using advanced features of Oracle’s procedural language: PL/SQL. The focus of this course is to advance 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 Oracle10g, Oracle11g and Oracle12c. 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 contains additional white papers on Java and PL/SQL and executing external procedures. 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

Prerequisites:

A working knowledge of SQL and PL/SQL is required.

Oracle Architecture:

Introduction to PL/SQL :

o Syntax and language structure review

PL/SQL Topics :

o Package Usage (both User Defined and Oracle Defined Packages) o Compiler Options, Code Encryption, Conditional Compilation o Cursor Sharing/Cursor Variables o Collections o Triggers o Dynamic SQL o Autonomous Transactions o PL/SQL Coding Tips o Debugging PL/SQL o PL/SQL Profiling

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

Day 1: Advanced Oracle PL/SQL:

– PL/SQL Overview/Review – PL/SQL Compiler Options – Code Encryption – Conditional Compilation – Definer/Invoker Rights – Executing and Exception handling – Autonomous Transactions – Package Options – Overloading – Database Triggers § DML, Instead of, ServerError, Startup, Shutdown, Logon

Day 2: Advanced Oracle PL/SQL:

– Working with Cursors § User Defined Datatypes § Cursor Sharing § Cursor Variables § Strong vs Weak Cursors – Working with Collections § Associate Arrays § Nested Tables § Varrays § Bulk Collect/Forall Bulk Binding § Using Collections for Reference Table – Oracle Provided Packages § DBMS_Alert § DBMS_Job § DBMS_Output § DBMS_Scheduler § UTL_File § UTL_Mail § Other Provided Packages

Day 3: Advanced Oracle PL/SQL:

– DBMS_SQL & Dynamic SQL – Lecture on SQL Injection – Working with Large Objects – Debugging PL/SQL Routines – PL/SQL Profile

About Dan Hotka:

Dan Hotka is a Training Specialist and an Oracle ACE Director who has over 35 years in the computer industry, over 29 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well-published with 12 Oracle books and well over 200 printed articles. He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world. Dan Hotka – Author/Instructor/Oracle ACE Director

 

To Register your interest or to book a place on this course please email Annette Coburn on skillnet@itcork.ie