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
- Understanding PL/SQL architecture and block structure
- Exploring data types, variables, and constants
- Techniques for declaring and assigning variables
Control Flow and Decision Logic
- Implementing IF, CASE, and nested conditions
- Using LOOP, WHILE, and FOR constructs
- Applying EXIT and CONTINUE statements
Cursors and Transaction Management
- Working with implicit and explicit cursors
- Leveraging Cursor FOR loops and attributes
- Managing transactions with COMMIT, ROLLBACK, and SAVEPOINT
Exception Handling Strategies
- Identifying exception types and using WHEN clauses
- Raising errors via RAISE_APPLICATION_ERROR
- Implementing custom exceptions and handlers
Procedures and Functions
- Building custom procedures and functions
- Managing IN, OUT, and IN OUT parameters
- Invoking stored procedures from SQL and PL/SQL contexts
Packages and Triggers
- Creating and maintaining packages
- Distinguishing between package specification and body
- Configuring row-level and statement-level triggers
Security, Debugging, and Testing
- Granting and revoking execution privileges
- Debugging PL/SQL code using SQL Developer
- Conducting unit tests for stored procedures and packages
Summary and Future Pathways
Requirements
- A solid grasp of relational database concepts
- Fundamental knowledge of SQL
- Working familiarity with procedural programming principles
Target Audience
- Database developers
- Backend programmers and data engineers
- Technical support and DevOps professionals working in 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
