Oracle Database: Develop PL SQL Program Units Eğitimi

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

• 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

• 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