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.
1. Introduction
2. Working with Oracle Database Exadata Express Cloud Service
3.Creating Stored Procedures
4. Creating Functions and Debugging Subprograms
5. Creating Packages
6. Working With Packages
7. Using Oracle-Supplied Packages in Application Development
8. Using Dynamic SQL
9. Creating Triggers
10. Creating Compound, DDL, and Event Database Triggers
11. Design Considerations for PL/SQL Code
12. Using PL/SQL compiler
13. Managing Dependencies