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 Foundations
- PL/SQL architecture and block composition
- Data types, variables, and constants
- Variable declaration and assignment techniques
Control Flow and Logic Implementation
- IF, CASE, and nested conditional structures
- LOOP, WHILE, and FOR iterative constructs
- Use of EXIT and CONTINUE statements
Cursors and Transaction Management
- Implicit and explicit cursor usage
- Cursor FOR loops and associated attributes
- Transaction control mechanisms: COMMIT, ROLLBACK, and SAVEPOINT
Exception Management
- Exception categories and WHEN clause application
- Implementing RAISE_APPLICATION_ERROR
- Defining custom exceptions and handlers
Procedures and Functions
- Development of procedures and functions
- Utilizing IN, OUT, and IN OUT parameters
- Invoking stored procedures from SQL and PL/SQL contexts
Packages and Triggers
- Package creation and administration
- Distinguishing between package specification and body
- Row-level and statement-level trigger implementation
Security and Testing Protocols
- Managing execution privileges through grants and revocations
- Debugging PL/SQL using SQL Developer
- Conducting unit tests on stored procedures and packages
Conclusion and Future Directions
Requirements
- A solid grasp of relational database concepts
- Fundamental knowledge of SQL
- Working familiarity with procedural programming basics
Target Audience
- Database developers
- Backend programmers and data engineers
- Technical support and DevOps professionals 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
