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 Basics
- Understanding PL/SQL architecture and block organization
- Exploring data types, variables, and constants
- Processes for declaring and assigning variables
Flow Control and Decision Making
- Implementing IF, CASE, and nested conditional logic
- Utilizing LOOP, WHILE, and FOR structures
- Applying EXIT and CONTINUE directives
Cursor Management and Transaction Control
- Distinguishing between implicit and explicit cursors
- Working with Cursor FOR loops and cursor attributes
- Managing transactions via COMMIT, ROLLBACK, and SAVEPOINT
Managing Exceptions
- Identifying exception types and applying WHEN clauses
- Employing RAISE_APPLICATION_ERROR
- Implementing custom exceptions and handlers
Developing Procedures and Functions
- Constructing procedures and functions
- Handling IN, OUT, and IN OUT parameters
- Invoking stored procedures from both SQL and PL/SQL contexts
Package Design and Triggers
- Building and maintaining packages
- Differentiating between package specification and body
- Creating row-level and statement-level triggers
Security Protocols and Testing
- Managing execution privileges through granting and revoking
- Debugging PL/SQL using SQL Developer
- Performing unit tests on stored procedures and packages
Conclusion and Path Forward
Requirements
- A solid grasp of relational database principles
- Foundational proficiency in SQL
- Knowledge of procedural programming basics
Target Audience
- Database developers
- Backend engineers and data specialists
- Technical support and DevOps professionals working in Oracle ecosystems
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
