COURSE DESCRIPTION: This is a 2-day class (6-hours per day) that includes lecture, lab and testing for up to 12 students.
Attendees will learn how to develop Oracle procedures, functions and packages using PL/SQL (Programming Language extension of Structured Query Language). They will also learn about error handling and debugging.
The attendees will construct PL/SQL statements and scripts to solve simple and complex business questions by writing PL/SQL in a variety of tools and applications.
Lectures and topics are enhanced with live illustrations and hands-on exercises.
Introduction to PL/SQL syntax and language structure.
Introduction to PL/SQL commands to develop Oracle procedures, functions and database triggers.
Exposure to Oracle tools SQL*Plus and SQL Developer.
Exposure to Quest Software's application named Toad.
Introduction to advanced PL/SQL topics including cursor management, exception handling, PL/SQL Profiler, PL/SQL Debugger and much more.
AUDIENCE: The focus of this course is to give a working knowledge of PL/SQL to students who already have a working knowledge of SQL.
PREREQUISITES: Working knowledge of SQL.
ATTENDEES RECEIVE: o Study Guide with presentations and relevant white papers o PL/SQL Reference pocket guide o Example files with SQL and SQL*Plus scripts o Tips and Techniques for both Toad and SQL Developer
COURSE OUTLINE: Day 1: Introduction to Oracle PL/SQL o Oracle RDBMS Architecture overview o Introduction to SQL*Plus, SQL Developer and Toad o Introduction to PL/SQL - Syntax - Structure - Variables - Control Structures - IF-Then-Else - Case - Looping - Cursors - Implicit - Explicit - Cursor Loops Day 2: Advanced PL/SQL Topics o PL/SQL Exception Handling o Procedures, Functions and Packages o Passing Parameters o PL/SQL Profiling o PL/SQL Debugging o PL/SQL New Features