This Oracle Database: Program with PL/SQL training starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language. Through hands-on instruction from expert Oracle instructors, you’ll learn to develop stored procedures, functions, packages and more.
1. Introduction
2. Working with Oracle Cloud Exadata Express Cloud Service
3. Introduction to PL/SQL
4. Declare PL/SQL Variables
5. Write Anonymous PL/SQL Blocks
6. SQL Statements in a PL/SQL block
7. Control Structures
8. Composite Data Types
9. Explicit Cursors
10. Exception Handling
11. Stored Procedures
12. Stored Functions
13. Debugging Subprograms
14. Packages
15. Deploying Packages
16. Implement Oracle-Supplied Packages in Application Development
17. Dynamic SQL
18. Design Considerations for PL/SQL Code
19. Triggers
20. Creating Compound, DDL, and Event Database Triggers
21. PL/SQL Compiler
22. Manage Dependencies