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.

Doelgroep

• Applicatie Ontwikkelaar met PL/SQL
• Technisch consultant

Voorkennis

• Previous programming experience
• Basic Knowledge of PL/SQL

Inhoud

• Introduction
• Creating Stored Procedures
• Creating Stored Functions
• Creating Packages
• Working With Packages
• Using Oracle-Supplied Packages in Application Development
• Using Dynamic SQL
• Design Considerations for PL/SQL Code
• Creating Triggers
• Creating Compound, DDL, and Event Database Triggers
• Using the PL/SQL Compiler
• Managing PL/SQL Code
• Managing Dependencies

• Gratis brochure aanvragen
• Contact opnemen