Program with PL/SQL

This course includes an introduction to PL/SQL and 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, and data management applications. In addition, the creation of anonymous PL/SQL blocks as well as stored procedures and functions are covered in this course.

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

This course is the bundle of Oracle Database: PL/SQL Fundamentals and Oracle Database: Develop PL/SQL Program Units courses; and appropriate for a 10g and 11g audience. There are minor changes between 10g and 11g features.

Prerequisite

Taken course PT-OR1101 - Oracle Database 11g: Introduction to SQL or equivalent experience

Training Format

Instructor Led Sessions with Intensive Hands-on Training, utilizing our (Lecture | Lab | Review) Delivery. Comprehensive Study Materials and Pre/Post-Class Mentoring and Practice Test. Oracle 11g Enterprise Edition installed on your PC (Laptop preferred)

Bonus : Exposure to Basic UNIX Scripting, Linux, TOAD, SQL*Loader, SFTP, and SecureCRT

Certification

Though our training places more emphasis on a comprehensive understanding of Oracle technologies, students are also adequately prepared to take applicable Oracle certification exam to earn Oracle Certified Associate (OCA). Our student’s exam success rate is excellent