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 Foundations
- PL/SQL architecture and block organization
- Data types, variable declarations, and constants
- Variable assignment techniques
Control Flow and Logic
- IF, CASE, and nested conditional statements
- LOOP, WHILE, and FOR loop structures
- Use of EXIT and CONTINUE directives
Cursors and Transaction Management
- Implicit versus explicit cursors
- Cursor FOR loops and associated attributes
- Transaction control commands: 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
- Development of procedures and functions
- Parameter modes: IN, OUT, and IN OUT
- Invoking stored procedures from SQL and PL/SQL contexts
Packages and Triggers
- Creation and maintenance of packages
- Distinguishing between package specifications and bodies
- Row-level and statement-level trigger implementation
Security and Testing Protocols
- Managing execution privileges via granting and revoking
- Debugging PL/SQL code using SQL Developer
- Unit testing for stored procedures and packages
Conclusion and Future Steps
Requirements
- Foundational understanding of relational database principles
- Proficiency in basic SQL concepts
- Acquaintance with procedural programming basics
Target Audience
- Database developers
- Backend programmers and data engineers
- Technical support staff and DevOps professionals operating in Oracle environments
Testimonials (3)
he explained very well, and gave guidance on the exercises.
Stoyan - OPEN COURSE
Course - Oracle Database 19c PL and Advanced SQL
I liked the hands-on experience and the opportunity to work on actual coding activities
Kristine - Isuzu Philippines Corporation
Course - ORACLE PL/SQL Fundamentals
The PL/SQL session basics. I used PL/SQL but never got the basics of it and this course helped me a lot understand PL/SQL queries.
