Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 21 hours
Course Outline
PL/SQL Essentials
- PL/SQL architecture and block organization
- Data types, variables, and constant definitions
- Variable declaration and assignment techniques
Control Flow and Logic
- Implementation of IF, CASE, and nested conditional logic
- Utilization of LOOP, WHILE, and FOR structures
- Application of EXIT and CONTINUE directives
Cursors and Transaction Management
- Management of implicit and explicit cursors
- Cursor FOR loops and associated attributes
- Transaction control via COMMIT, ROLLBACK, and SAVEPOINT
Exception Handling Strategies
- Exception types and the use of WHEN clauses
- Implementing RAISE_APPLICATION_ERROR
- Definition of custom exceptions and handlers
Procedures and Functions
- Development of stored procedures and functions
- Handling IN, OUT, and IN OUT parameters
- Invocation of stored procedures from both SQL and PL/SQL contexts
Packages and Triggers
- Creation and administration of packages
- Distinguishing between package specification and body
- Implementation of row-level and statement-level triggers
Security and Testing Protocols
- Administration of execution privileges (granting and revoking)
- PL/SQL debugging using SQL Developer
- Unit testing of stored procedures and packages
Conclusion and Future Directions
Requirements
- Grasp of relational database principles
- Foundational understanding of SQL
- Knowledge of procedural programming basics
Intended Audience
- Database developers
- Backend engineers and data specialists
- Technical support and DevOps teams managing Oracle environments
Testimonials (2)
To understand and better comprehensive with routine SQL
Faizal KAHAR - Soitec Microelectronics Singapore Pte Ltd
Course - Oracle Database 19c PL and Advanced SQL
I liked the hands-on experience and the opportunity to work on actual coding activities
