SUMMARY:   Give your IT staff the knowledge of using Oracle’s procedural language: PL/SQL. The focus of this course is to give students with a working knowledge of SQL the ability to develop Oracle procedures, functions, and database triggers using PL/SQL. The attendees have the opportunity to construct various PL/SQL routines to solve simple and complex business questions. The course covers how to code PL/SQL, access data in a variety of methods, error handling, and will touch on debugging PL/SQL. The optional 3rd day involves training the attendees in how to use TOAD or Oracle’s free SQL Developer tool to assist with their day-to-day development needs. Attendees will be able to use TOAD or SQL Developer to do the lab exercises and learn how to use the Procedure Editor and debug their PL/SQL routines. Students will also see how to enter their SQL using the TOAD or SQL Developer interface, easily create spreadsheets from data, display data, see various application relationships, and more. The course utilizes a variety of current tools. Students will have the opportunity to learn more about SQL Developer, TOAD, as well as the Oracle tools like SQL*Plus. PREREQUISITES:   A working knowledge of SQL is required. DURATION:   2 days (3 days with optional SQL Editor Tips and Techniques) COURSE CONTENT:   Oracle RDBMS Architecture overview Introduction to SQL Developer/TOAD/SQL*Plus Introduction to PL/SQL Basic Syntax Variables Cursors Implicit & Explicit Cursor Loops PL/SQL Control Structures PL/SQL Exception Handling Procedures/Functions/Database Triggers Passing Parameters Packages PL/SQL 10g New Features Array Processing Optional: SQL Developer or TOAD Tips and Techniques Viewing/changing Data Creating reports Extracting Data Working with SQL Discovering all of the help available Minimizing key strokes using templates and auto substitution Working with scripts Working with spreadsheets MS/08