Oracle Database 11g: Develop PL/SQL Program Units

This course is designed for developers with basic PL/SQL and SQL language skills. Students learn to develop, execute, and manage PLSQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage, PL/SQL subprograms and triggers. Students are introduced to the utilization of some of the Oracle-supplied packages.

Additionally students learn to use Dynamic SQL, understand design considerations when coding using PL/SQL, understand and influence the PL/SQL compiler and manage dependencies.

In this course, students use Oracle SQL Developer as the main tool and SQL*Plus is introduced as an optional tool.

This course counts towards the Hands-on course requirement for the Oracle Database 11g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses DO NOT meet the Hands-on Requirement.

Learn to:

• Create, and execute stored procedures and functions.
• Design and use PL/SQL packages
• Create overloaded package subprograms for more flexibility.
• Utilize Oracle-Supplied Packages in Application Development
• Create triggers to solve business challenges.
• Build and execute SQL statements dynamically.

Audience:

• Applicatie Ontwikkelaar met PL/SQL
• Database Beheerder

Course Objectives:

• Manage dependencies between PL/SQL subprograms
• Use conditional compilation to customize the functionality in a PL/SQL application without removing any source code
• Create, and use stored procedures and functions
• Design and use PL/SQL packages to group and contain related constructs
• Create overloaded package subprograms for more flexibility
• Use the Oracle supplied PL/SQL packages to generate screen output, file output, and mail output
• Create triggers to solve business challenges
• Write dynamic SQL for more coding flexibility
• Use the compiler warnings infrastructure
• Design PL/SQL code for pre-defined data types, local subprograms, additional programs and standardized constants and exceptions

Required Prerequisites:

• Oracle Database 11g: Introduction to SQL (combination of Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II)      
• Previous programming experience
• Basic Knowledge of PL/SQL