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
- Processes for declaring and assigning variables
Control Flow and Decision Logic
- Implementation of IF, CASE, and nested conditions
- Utilization of LOOP, WHILE, and FOR constructs
- Application of EXIT and CONTINUE statements
Cursors and Transactions
- Differentiation between implicit and explicit cursors
- Use of Cursor FOR loops and associated attributes
- Transaction control through COMMIT, ROLLBACK, and SAVEPOINT
Exception Handling
- Understanding exception types and WHEN clauses
- Application 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 SQL and PL/SQL contexts
Packages and Triggers
- Creation and management of packages
- Distinguishing between package specification and body
- Implementation of row-level and statement-level triggers
Security and Testing
- Granting and revoking execution privileges
- Debugging PL/SQL using SQL Developer
- Unit testing for stored procedures and packages
Summary and Next Steps
Requirements
- Conceptual understanding of relational databases
- Fundamental knowledge of SQL
- Basic proficiency in procedural programming principles
Audience
- Database developers
- Backend programmers and data engineers
- Technical support and DevOps professionals operating 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
