+91 88606 33966            edu_sales@siriam.in                   Job Opening : On-site Functional Trainer/Instructor | Supply Chain Management (SCM)
Oracle Database 19c: PL/SQL

Oracle Database 19c: PL/SQL


Course Description : 

The Oracle Database 19c: PL/SQL Workshop certification is a recognized qualification that validates an individual's expertise in using the Oracle Database, particularly in the use of Procedural Language/Structured Query Language (PL/SQL). It covers fundamental to complex concepts such as control structures, error handling, and working with large data sets. This certification is commonly used by industries as evidence of a professional's ability to efficiently manage, develop, and manipulate data in Oracle databases. It provides industries standard of higher credibility, improved productivity and maximized return of investments in Oracle technology. Note that to earn this certification, one must pass the related Oracle exam.

Course Prerequisites:

• Basic understanding of Oracle database concepts
• Knowledge of SQL and how to use SQL*Plus
• Familiarity with programming fundamentals
• Preliminary exposure to Oracle PL/SQL
• Basic experience in software development or database administration
• Familiarity with procedural programming language principles.


  • 1 Section
  • 21 Lessons
  • 0 Quizzes
  • 38h Duration
Expand All
21 Lessons0 Quizzes
  1. Introduction to PL/SQL
  2. Declaring PL/SQL Variables
  3. Writing Executable Statements
  4. Using SQL Statements Within a PL/SQL Block
  5. Writing Control Structures
  6. Working with Composite Data Types
  7. Using Explicit Cursors
  8. Handling Exceptions
  9. Introducing Stored Procedures and Functions
  10. Creating Procedures
  11. Creating Functions
  12. Debugging Subprograms
  13. Creating Packages
  14. Working with Packages
  15. Using Oracle-Supplied Packages in Application Development
  16. Using Dynamic SQL
  17. Creating Triggers
  18. Creating Compound, DDL, and Event Database Triggers
  19. Design Considerations for the PL/SQL Code
  20. Tuning the PL/SQL Compiler
  21. Managing Dependencies
0 out of 5

0 user ratings

Deleting Course Review

Are you sure? You can't restore this back
Scroll to top