Oracle Database: Develop PL/SQL Program Units

Learn how to develop, execute, and manage PL/SQL stored program units such as procedures, functions, packages, and database triggers!


We are sorry, but currently we don't know when the course will be arranged next time.
Please contact sales: +358 20 7776 670 or

You also learn to manage PL/SQL subprograms and triggers. This course is designed for developers with basic PL/SQL and SQL language skills.

Learn To:
– Create, and execute stored procedures and functions.
– Design and use PL/SQL packages.
– Create overloaded package subprograms for more flexibility.
– Utilize Oracle-Supplied Packages in Application Development.
– Create triggers to solve business challenges.

– Build and execute SQL statements dynamically.

Benefits To You:
Students are introduced to the utilization of some of the Oracle-supplied packages. Additionally students learn to use Dynamic SQL, understand design considerations when coding using PL/SQL, understand and influence the PL/SQL compiler, and manage dependencies.

In this course, students learn and use Oracle SQL Developer as the main environment tool to develop these program units. SQL*Plus is introduced as optional tools. Demonstrations and hands-on practice reinforce the fundamental concepts.

Target audience:

Database Administrators
Forms Developers
PL/SQL Developer
Portal Developer
System Analysts

Technical Consultants

Required Prerequisites:
– Familiarity with data processing concepts and technique
– Familiarity with programming languages

– Oracle Database 12c: Introduction for Experienced SQL Users

Suggested Prerequisites:
– Familiarity with data processing concepts and techniques

– Familiarity with programming languages

Test: OCP

See more detailed description here.


Places left:
No participant limit
2031,00  + VAT

Responsible person

Eine Lahtisalo

Eine Lahtisalo

Eine is a Microsoft Office specialist, who has worked as a full-time trainer for over 15 years. She has been involved in planning numerous customized training projects and has operated as a responsible trainer in many Office-migration projects. As an enthusiastic learner herself, she has studied human resource management, business administration and project management alongside working.

Competence: Microsoft Certified Trainer (MCT), MOS Master-level, MCAS for Excel, Outlook, PowerPoint and Word, IPMA Level D – Certified Project Management Associate, ITIL Foundation 2011 Edition, Microsoft Office specialist.