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.
A working knowledge of SQL and PL/SQL is required.
3 Days/Lecture & Lab
Attendees receive a hands-on opportunity to learn more about Oracle, TOAD, and SQL Developer.