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
Foundations of PL/SQL
- 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 iteration constructs
- EXIT and CONTINUE flow control statements
Cursors and Transaction Management
- Implicit and explicit cursor usage
- Cursor FOR loops and cursor attributes
- Transaction control via COMMIT, ROLLBACK, and SAVEPOINT
Exception Management
- Exception types and WHEN clause implementation
- Utilizing RAISE_APPLICATION_ERROR
- Defining custom exceptions and handlers
Procedures and Functions
- Creating and defining procedures and functions
- Managing IN, OUT, and IN OUT parameters
- Invoking stored procedures from SQL and PL/SQL
Packages and Triggers
- Creating and administering packages
- Distinguishing between package specifications and bodies
- Implementing row-level and statement-level triggers
Security and Quality Assurance
- Managing execution privileges via grants and revokes
- Debugging PL/SQL code using SQL Developer
- Unit testing stored procedures and packages
Summary and Future Directions
Requirements
- Understanding 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 staff 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
