Oracle Database: Develop PL/SQL Program Units

Learn 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

Suggested Prerequisite

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

Required Prerequisite

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

Audience

  • Database Administrator
  • Developer
  • Implementer
  • Systems Administrator

Course 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

Course Topics

  • 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 SQL
  • Creating Triggers
  • Creating Compound, DDL, and Event Database Triggers
  • Design Considerations for PL/SQL Code
  • Using PL/SQL compiler
  • Managing Dependencies

 

Kursdetails

Startdatum 18.12.2023 - 09:00
Enddatum 20.12.2023 - 17:00
Anmeldungsende 15.12.2023
Netto Einzelpreis € 2.880,00
Speaker English
Number Hours 9:00-17:00 Uhr
Kurs-Nr. OD1001: Oracle Database: Develop PL/SQL Program Units
Ort Live Online
Abgeschlossen

Kurssuche

Von Datum
Bis Datum
Ort