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 Fundamentals
- PL/SQL architecture and block organization
- Data types, variables, and constants
- Declaration and assignment of variables
Control Flow and Decision Logic
- IF, CASE, and nested conditional structures
- LOOP, WHILE, and FOR loop constructs
- Use of EXIT and CONTINUE statements
Cursors and Transactions
- Implicit versus explicit cursors
- Cursor FOR loops and associated attributes
- Transaction management via COMMIT, ROLLBACK, and SAVEPOINT
Exception Handling
- Categorization of exceptions and WHEN clause usage
- Implementation of RAISE_APPLICATION_ERROR
- Definition of custom exceptions and handlers
Procedures and Functions
- Development of procedures and functions
- Management of IN, OUT, and IN OUT parameters
- Invocation of stored procedures from SQL and PL/SQL
Packages and Triggers
- Creation and management of packages
- Distinguishing between package specifications and bodies
- Implementation of row-level and statement-level triggers
Security and Testing
- Granting and revoking execution privileges
- Debugging PL/SQL code using SQL Developer
- Unit testing of stored procedures and packages
Summary and Next Steps
Requirements
- A solid grasp of relational database concepts
- Foundational knowledge of SQL
- Acquaintance with procedural programming basics
Target Audience
- Database developers
- Backend programmers and data engineers
- Technical support and DevOps personnel operating 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
