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
|
15.07.2020 - 08:00 |
Enddatum
|
17.07.2020 |
Anmeldungsende
|
11.07.2020 |
Netto Einzelpreis
|
€ 1.989,00 |
Ort
|
LVC
|
Abgeschlossen