Oracle Database 11g: Program With PL/SQL

Product Description

This course starts with an introduction to PL/SQL & proceeds to list the benefits of this powerful programming language. Participants are made aware of how to create PL/SQL blocks of application code that can be shared by multiple forms, reports, & data management applications. In addition, creation of anonymous PL/SQL blocks as well as stored procedures & functions are covered in this course.

Participants enhance their developer skills by learning to develop, execute, & manage PLSQL stored program units such as procedures, functions, packages, & database triggers. Understanding the basic functionality of how to debug functions & procedures using the SQL Developer Debugger gives way to refined lines of code. Participants also learn to manage PL/SQL subprograms, triggers, declaring identifiers, & trapping exceptions. The utilization of some of the Oracle-supplied packages is also in the course. in addition participants learn to use Dynamic SQL, understand design considerations when coding using PL/SQL, understand & influence the PL/SQL compiler, & manage dependencies.

This course is a bundle of Oracle Database: PL/SQL Fundamentals & Oracle Database: Develop PL/SQL Program Units courses.

Students use Oracle SQL Developer to develop these program units. SQL* Plus & JDeveloper are introduced as optional tools.

This is appropriate for a 10g & 11g audience. There are minor changes between 10g & 11g features.

This course is also available as a LIVE Virtual Class. A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

This training may be available onsite; please contact us if you are interested.