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.
Course Outline
Introduction to PL/SQL
- Overview of the PL/SQL runtime environment
- Structure and classifications of PL/SQL blocks
- Declaration and utilization of variables
- Control flow structures: conditionals and loops
Integrating SQL within PL/SQL
- Execution of DML commands
- Application of DDL and dynamic SQL
- Transaction control commands (TCL)
- Data retrieval using SELECT statements
Procedures and Functions
- Creating and removing procedures and functions
- Parameterization methods
- Passing parameters by value and by reference; understanding
NOCOPY
Error and Exception Handling
- Strategies for managing errors and exceptions in PL/SQL
Cursor Management
- Understanding records and static cursors
- Parameterizing cursors
- Implementing cursors with
FOR UPDATE
Associative Arrays
- Declaring and utilizing associative arrays in PL/SQL
Packages
- Package architecture: specifications and bodies
- Initialization sections, global variables, and memory management
- Encapsulation, overloading, and forward declaration concepts
Triggers
- Developing DML triggers
- Implementing INSTEAD OF triggers
- Understanding system triggers
- Exploring advanced trigger capabilities
Practical Use of Built-in Packages
- File writing operations using
UTL_FILE - Dispatching emails from PL/SQL
Code Management and Compilation
- Techniques for code encryption and obfuscation
- Application of conditional compilation
- Managing object dependencies
- Interpreting compiler warnings
Summary and Next Steps
Requirements
- Foundational proficiency in any programming language, whether structured or object-oriented.
- Familiarity with SQL fundamentals and the Oracle database environment.
Target Audience
- Developers
- Database administrators
28 Hours
Testimonials (3)
he explained very well, and gave guidance on the exercises.
Stoyan - OPEN COURSE
Course - Oracle Database 19c PL and Advanced SQL
I liked the hands-on experience and the opportunity to work on actual coding activities
Kristine - Isuzu Philippines Corporation
Course - ORACLE PL/SQL Fundamentals
The PL/SQL session basics. I used PL/SQL but never got the basics of it and this course helped me a lot understand PL/SQL queries.
