D80170 - Oracle Database: Develop PL/SQL Program Units
This course is designed for developers with basic PL/SQL and SQL language skills. Students learn to develop, execute, and manage PL/SQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage, PL/SQL subprograms and triggers.
Learn To:
- Create, and execute stored procedures and functions.
- Design and use PL/SQL packages.
- Create overloaded package subprograms for more flexibility.
- Utilize Oracle-Supplied Packages in Application Development.
- Create triggers to solve business challenges.
- Build and execute SQL statements dynamically.
Upon completing this course, the learner will be able to meet these overall objectives:
- Use conditional PL/SQL compilation and obfuscate (hide) code
- 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
- PL/SQL Developer
- Database Administrators
- System Analysts
- Forms Developer
- Technical Consultant
- Portal Developer
- Module 1: Introduction
- Module 2: Working with Oracle Database Exadata Express Cloud Service
- Module 3: Creating Stored Procedures
- Module 4: Creating Functions and Debugging Subprograms
- Module 5: Creating Packages
- Module 6: Working With Packages
- Module 7: Using Oracle-Supplied Packages in Application Development
- Module 8: Using Dynamic SQL
- Module 9: Creating Triggers
- Module 10: Creating Compound, DDL, and Event Database Triggers
- Module 11: Design Considerations for PL/SQL Code
- Module 12: Using PL/SQL compiler
- Module 13: Managing Dependencies
- Familiarity with data processing concepts and technique
- Familiarity with programming languages
- Oracle Database 12c: Introduction for Experienced SQL Users
Suggested Prerequisites:
- Familiarity with data processing concepts and techniques
- Familiarity with programming languages
This course is not associated with any Certification.