Get in Touch
 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.
Investment

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)

Upcoming Courses

Related Categories