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 composition
- Data types, variables, and constants
- Variable declaration and assignment
Control Flow and Decision Logic
- IF, CASE, and nested conditional statements
- LOOP, WHILE, and FOR constructs
- EXIT and CONTINUE directives
Cursors and Transactions
- Implicit and explicit cursors
- Cursor FOR loops and associated attributes
- Transaction management: COMMIT, ROLLBACK, SAVEPOINT
Exception Handling
- Exception categories and WHEN clauses
- Application 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 SQL and PL/SQL
Packages and Triggers
- Creation and maintenance of packages
- Distinguishing between package specification and body
- Row-level and statement-level triggers
Security and Testing
- Managing execution privileges: granting and revoking
- Debugging PL/SQL with SQL Developer
- Unit testing for stored procedures and packages
Summary and Future Steps
Requirements
- A solid understanding of relational database concepts
- Fundamental knowledge of SQL
- Proficiency in procedural programming basics
Target Audience
- Database developers
- Backend programmers and data engineers
- Technical support and DevOps staff working within Oracle ecosystems
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.
