25,000+ Courses Nationwide
0345 4506120

Oracle Database: Develop PL SQL Program Units

Special Notices

Please note: In order to provision you with your courseware and lab access for this course we must share several items of basic personal information with our partner (usually your full name and email address).  If you have any questions or concerns please contact us.

Audience

  • Database Administrator
  • Developer
  • Implementer
  • Systems Administrator

Select specific date to see price, venue and full details.

Learning Objectives

  • 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

Pre-Requisites

Required

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

Suggested

  • Familiarity with data processing concepts and techniques
  • Familiarity with programming languages

Course Content

  • Introduction
  • Working with Oracle Database Exadata Express Cloud Service
  • Creating Stored Procedures
  • Creating Functions and Debugging Subprograms
  • Creating Packages
  • Working With Packages
  • Using Oracle-Supplied Packages in Application Development
  • Using Dynamic SQLCreating Triggers
  • Creating Compound, DDL, and Event Database Triggers
  • Design Considerations for PL/SQL Code
  • Using PL/SQL compiler
  • Managing Dependencies

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

We work with the best