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
- Architecture of PL/SQL and block organization
- Working with data types, variables, and constants
- Declaration and assignment of variables
Control Flow and Conditional Logic
- Implementation of IF, CASE, and nested conditions
- Utilizing LOOP, WHILE, and FOR structures
- Application of EXIT and CONTINUE directives
Cursors and Transaction Management
- Distinguishing between implicit and explicit cursors
- Cursor FOR loops and associated attributes
- Managing transactions via COMMIT, ROLLBACK, and SAVEPOINT
Exception Management
- Categorizing exceptions and using WHEN clauses
- Applying RAISE_APPLICATION_ERROR
- Defining custom exceptions and handling routines
Procedures and Functions
- Building procedures and functions
- Managing IN, OUT, and IN OUT parameters
- Invoking stored procedures from SQL and PL/SQL contexts
Packages and Triggers
- Development and administration of packages
- Differentiating package specifications from bodies
- Implementing row-level and statement-level triggers
Security and Testing Practices
- Granting and revoking execution rights
- Debugging PL/SQL code using SQL Developer
- Performing unit tests on stored procedures and packages
Wrap-up and Future Directions
Requirements
- Comprehension of relational database principles
- Foundational understanding of SQL
- Knowledge of basic procedural programming concepts
Target Audience
- Database developers
- Backend engineers and data specialists
- 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
