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
- Overview of the PL/SQL execution environment
- Composition and classification of PL/SQL blocks
- Variable declaration and usage
- Control flow structures: conditionals and loops
Integrating SQL into PL/SQL
- Execution of DML commands
- Use of DDL and dynamic SQL
- Transaction control commands (TCL)
- Data retrieval via SELECT statements
Procedures and Functions
- Creating and dropping procedures and functions
- Parameterization methods
- Passing parameters by value and by reference; comprehending
NOCOPY
Error and Exception Management
- Strategies for managing errors and exceptions within PL/SQL
Cursor Administration
- Comprehending records and static cursors
- Parameterizing cursors
- Implementing cursors with
FOR UPDATE
Associative Arrays
- Declaration and application of associative arrays in PL/SQL
Packages
- Package architecture: specifications and bodies
- Initialization sections, global variables, and memory management
- Encapsulation, overloading, and forward declarations
Triggers
- Creation of DML triggers
- Implementation of INSTEAD OF triggers
- Comprehension of system triggers
- Exploration of advanced trigger capabilities
Practical Use of Built-in Packages
- File writing operations using
UTL_FILE - Email dispatch from PL/SQL
Code Management and Compilation
- Techniques for code encryption and obfuscation
- Application of conditional compilation
- Managing object dependencies
- Analysis of compiler warnings
Conclusion and Future Pathways
Requirements
- Fundamental proficiency in any programming language, whether structured or object-oriented.
- Adequate familiarity with SQL fundamentals and the Oracle database ecosystem.
Target Audience
- Developers
- Database Administrators
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 5800 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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