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
- PL/SQL architecture and block composition
- Data types, variables, and constants
- Variable declaration and assignment
Control Flow and Decision-Making
- IF, CASE, and nested conditional logic
- LOOP, WHILE, and FOR loop constructs
- EXIT and CONTINUE flow control statements
Cursors and Transaction Management
- Implicit versus explicit cursors
- Cursor FOR loops and associated attributes
- Transaction control via COMMIT, ROLLBACK, and SAVEPOINT
Managing Exceptions
- Exception types and WHEN clause usage
- Implementation of RAISE_APPLICATION_ERROR
- Defining custom exceptions and handlers
Procedures and Functions
- Authoring procedures and functions
- IN, OUT, and IN OUT parameter modes
- Invoking stored procedures from both SQL and PL/SQL contexts
Packages and Triggers
- Package creation and administration
- Distinguishing package specification from the body
- Row-level and statement-level trigger implementation
Security and Validation
- Managing execution privileges through grants and revokes
- Debugging PL/SQL code using SQL Developer
- Unit testing for stored procedures and packages
Recap and Future Pathways
Requirements
- A solid grasp of relational database concepts
- Fundamental knowledge of SQL
- Basic familiarity with procedural programming principles
Target Audience
- Database developers
- Backend programmers and data engineers
- Technical support and DevOps specialists 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
