Special Notices

Please note that Oracle courses running at London training centres are subject to a 10% surcharge.

Please note: In order to provision you with your courseware and lab access for this course QA must share several items of basic personal information with our partner (usually your full name and email address). For more information on this please visit our QA Partner data sharing page. If you have any questions or concerns please contact your QA account manager.

Important Note: Your official Oracle digital course material now includes an additional 5 hours of content for you to consume after the course to help embed the learning. Your ELS will be accessible for 90 days from purchase.

Prerequisites

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

Audience

  • Database Administrator
  • Developer
  • Implementer
  • Systems Administrator

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

Outline

  • 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