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 Core Concepts
- Understanding PL/SQL architecture and block composition
- Exploring data types, variables, and constants
- Variable declaration and assignment techniques
Control Flow and Logic
- Implementing IF, CASE, and nested conditional statements
- Utilizing LOOP, WHILE, and FOR constructs
- Applying EXIT and CONTINUE statements
Cursors and Transaction Management
- Working with implicit and explicit cursors
- Cursor FOR loops and associated attributes
- Managing transactions via COMMIT, ROLLBACK, and SAVEPOINT
Exception Management
- Exception types and the use of WHEN clauses
- Implementing RAISE_APPLICATION_ERROR
- Defining custom exceptions and handlers
Procedures and Functions
- Creation of custom procedures and functions
- Managing IN, OUT, and IN OUT parameters
- Invoking stored procedures from both SQL and PL/SQL contexts
Packages and Triggers
- Building and maintaining packages
- Distinguishing between package specifications and bodies
- Developing row-level and statement-level triggers
Security and Quality Assurance
- Granting and revoking execution permissions
- Debugging PL/SQL code using SQL Developer
- Performing unit tests on stored procedures and packages
Conclusion and Future Directions
Requirements
- A solid grasp of relational database concepts
- Fundamental proficiency in SQL
- Basic understanding of procedural programming principles
Intended Audience
- Database developers
- Backend programmers and data engineers
- Technical support specialists and DevOps professionals 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
