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
- Overview of PL/SQL architecture and block organization
- Understanding data types, variables, and constants
- Processes for declaring and assigning variables
Control Flow and Logical Decisions
- Implementation of IF, CASE, and nested conditional statements
- Use of LOOP, WHILE, and FOR loop constructs
- Application of EXIT and CONTINUE directives
Cursors and Transaction Management
- Distinguishing between implicit and explicit cursors
- Working with Cursor FOR loops and associated attributes
- Managing transactions using COMMIT, ROLLBACK, and SAVEPOINT
Exception Management
- Identifying exception types and utilizing WHEN clauses
- Applying the RAISE_APPLICATION_ERROR command
- Defining custom exceptions and their corresponding handlers
Procedures and Functions
- Development of stored procedures and functions
- Managing IN, OUT, and IN OUT parameters
- Invoking stored procedures from both SQL and PL/SQL contexts
Packages and Triggers
- Creation and administration of packages
- Differences between package specifications and bodies
- Implementation of row-level and statement-level triggers
Security and Quality Assurance
- Granting and revoking execution permissions
- Debugging PL/SQL code using SQL Developer
- Performing unit tests on stored procedures and packages
Conclusion and Future Learning Paths
Requirements
- A solid grasp of relational database concepts
- Foundational knowledge of SQL
- Basic familiarity with procedural programming principles
Target Audience
- Database developers
- Backend programmers and data engineers
- Technical support specialists and DevOps personnel working 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
