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 Fundamentals
- Overview of PL/SQL architecture and block structure
- Exploration of data types, variables, and constants
- Techniques for declaring and assigning variables
Control Flow and Decision Logic
- Application of IF, CASE, and nested conditional statements
- Implementation of LOOP, WHILE, and FOR constructs
- Utilization of EXIT and CONTINUE statements
Cursors and Transactions
- Distinction between implicit and explicit cursors
- Use of Cursor FOR loops and associated attributes
- Managing transactions using COMMIT, ROLLBACK, and SAVEPOINT
Exception Handling
- Identification of exception types and use of WHEN clauses
- Implementation of RAISE_APPLICATION_ERROR
- Creation of custom exceptions and handlers
Procedures and Functions
- Development of procedures and functions
- Management of IN, OUT, and IN OUT parameters
- Invocation of stored procedures from both SQL and PL/SQL
Packages and Triggers
- Creation and administration of packages
- Differentiation between package specification and body
- Implementation of row-level and statement-level triggers
Security and Testing
- Granting and revoking execution privileges
- Debugging PL/SQL code using SQL Developer
- Performing unit tests on stored procedures and packages
Summary and Next Steps
Requirements
- Understanding of relational database concepts
- Foundational knowledge of SQL
- Familiarity with the basics of procedural programming
Audience
- Database developers
- Backend programmers and data engineers
- Technical support and DevOps specialists working with Oracle ecosystems
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
