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
- PL/SQL architecture and block structure
- Data types, variables, and constants
- Variable declaration and assignment
Control Flow and Decision Logic
- IF, CASE, and nested conditional statements
- LOOP, WHILE, and FOR loop constructs
- EXIT and CONTINUE control statements
Cursors and Transactions
- Implicit and explicit cursors
- Cursor FOR loops and associated attributes
- Transaction control: COMMIT, ROLLBACK, and SAVEPOINT
Exception Handling
- Exception types and WHEN clauses
- Implementation of RAISE_APPLICATION_ERROR
- Custom exceptions and exception handlers
Procedures and Functions
- Creation of procedures and functions
- IN, OUT, and IN OUT parameter modes
- Invocation of stored procedures from SQL and PL/SQL
Packages and Triggers
- Package creation and management
- Distinguishing between package specification and body
- Row-level and statement-level triggers
Security and Testing
- Granting and revoking execution privileges
- PL/SQL debugging using SQL Developer
- Unit testing for stored procedures and packages
Summary and Next Steps
Requirements
- Understanding of relational database concepts
- Foundational knowledge of SQL
- Familiarity with the fundamentals of procedural programming
Target Audience
- Database developers
- Backend programmers and data engineers
- Technical support and DevOps personnel working with 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
