D80170 - Oracle Database: Develop PL/SQL Program Units

Overview

Duration: 3 days

This course is designed for developers with basic PL/SQL and SQL language skills. Students learn to develop, execute, and manage PL/SQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage, PL/SQL subprograms and triggers.

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.

Objectives

Upon completing this course, the learner will be able to meet these overall objectives:

Use conditional PL/SQL compilation and obfuscate (hide) code
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

Content

Module 1: Introduction
Module 2: Working with Oracle Database Exadata Express Cloud Service
Module 3: Creating Stored Procedures
Module 4: Creating Functions and Debugging Subprograms
Module 5: Creating Packages
Module 6: Working With Packages
Module 7: Using Oracle-Supplied Packages in Application Development
Module 8: Using Dynamic SQL
Module 9: Creating Triggers
Module 10: Creating Compound, DDL, and Event Database Triggers
Module 11: Design Considerations for PL/SQL Code
Module 12: Using PL/SQL compiler
Module 13: Managing Dependencies

Audience

PL/SQL Developer
Database Administrators
System Analysts
Forms Developer
Technical Consultant
Portal Developer

Prerequisites

Familiarity with data processing concepts and technique
Familiarity with programming languages
Oracle Database 12c: Introduction for Experienced SQL Users

Suggested Prerequisites:

Familiarity with data processing concepts and techniques
Familiarity with programming languages

Certification

This course is not associated with any Certification.

Schedule

Show Schedule for:

Enquiry Form