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 organisation
- Data types, variables, and constants
- Variable declaration and assignment
Control Flow and Decision Making
- IF, CASE, and nested conditional logic
- LOOP, WHILE, and FOR constructs
- EXIT and CONTINUE directives
Cursors and Transaction Management
- Implicit versus explicit cursors
- Cursor FOR loops and associated attributes
- Transaction control via COMMIT, ROLLBACK, and SAVEPOINT
Exception Handling
- Categorisation of exceptions and WHEN clauses
- Implementation of RAISE_APPLICATION_ERROR
- Defining custom exceptions and handlers
Procedures and Functions
- Development of procedures and functions
- Handling IN, OUT, and IN OUT parameters
- Invoking stored procedures from both SQL and PL/SQL
Packages and Triggers
- Creating and maintaining packages
- Distinguishing between package specification and body
- Row-level and statement-level triggers
Security and Testing
- Managing execution privileges through granting and revoking
- Debugging PL/SQL using SQL Developer
- Unit testing for stored procedures and packages
Recap and Further Development
Requirements
- A solid grasp of relational database concepts
- Foundational knowledge of SQL
- Exposure to procedural programming fundamentals
Audience Profile
- Database developers
- Backend programmers and data engineers
- Technical support and DevOps professionals working within 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
