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 28 hours
Course Outline
Introduction to PL/SQL
- An overview of the PL/SQL runtime environment.
- Examining the structure and various types of PL/SQL blocks.
- Declaring and applying variables.
- Control structures, including conditionals and loops.
Integrating SQL into PL/SQL
- Execution of DML commands.
- Use of DDL and dynamic SQL.
- Transaction control commands (TCL).
- Data retrieval using SELECT statements.
Procedures and Functions
- Creating and dropping procedures and functions.
- Techniques for parameterization.
- Passing parameters by value and by reference; comprehension of
NOCOPY.
Error and Exception Management
- Strategies for managing errors and exceptions within 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 structure: specifications and bodies.
- Initialization sections, global variables, and memory management.
- Encapsulation, overloading, and forward declaration concepts.
Triggers
- Creation of DML triggers.
- Implementation of INSTEAD OF triggers.
- Understanding system triggers.
- Exploring advanced trigger capabilities.
Practical Use of Built-in Packages
- Writing to files using
UTL_FILE. - Dispatching emails from PL/SQL.
Code Management and Compilation
- Methods for code encryption and obfuscation.
- Use of conditional compilation.
- Management of object dependencies.
- Interpreting compiler warnings.
Summary and Subsequent Steps
Requirements
- Fundamental knowledge of any programming language, whether structured or object-oriented.
- Proficiency in SQL basics and familiarity with the Oracle database environment.
Target Audience
- Software Developers.
- Database Administrators.
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
