Course Overview
This Oracle Database: PL/SQL Program Units course builds on existing knowledge of PL/SQL block structure, variables, control structures and exception handling to explore the benefits of building Progran Units in this powerful programming language.
Through hands-on instruction from expert Oracle instructors, you'll learn to develop stored procedures, functions, packages and triggers and utilise Oracle provided packages.
Who should attend
- Database Administrator
- Developer
- Implementer
- Systems Administrator
Prerequisites
Required
- Oracle Database Introduction to SQL
- Oracle Database: PL/SQL Fundamentals
- Familiarity with data processing concepts and technique
- Familiarity with programming languages
Suggested
- Familiarity with data processing concepts and techniques
- Familiarity with programming languages
Course Objectives
- Develop sound, reliable program units to standardise and streamline your organisation's approach to maintaining data.
- You'll use Oracle SQL Developer to develop these program units. SQL*Plus is also available as an optional tool.
Delegates will learn how to
- Create triggers to solve business challenges
- Manage dependencies between PL/SQL subprograms
- Design PL/SQL code for predefined data types, local subprograms, additional pragmas and standardized constants and exceptions
- Use the compiler warnings infrastructure
- Create, use, and debug 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
- Write dynamic SQL for more coding flexibility
- Use conditional PL/SQL compilation and obfuscate (hide) code
Course Content
- Develop stored procedures to carry out database modifications.
- Write functions to be called from PL/SQL code or SQL statements.
- Use PL/SQL packages to group and contain related constructs.
- Create triggers to solve business challenges.
- Use Oracle supplied PL/SQL packages to generate screen output and file output.
- Examine the dependency chain on program units prior to implementing changes.