Oracle Database: Program with PL/SQL

This Oracle Database: Program with PL/SQL training starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language.


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

Through hands-on instruction from expert Oracle instructors, you’ll learn to develop stored procedures, functions, packages and more.

This course is a combination of Oracle Database: PL/SQL Fundamentals and Oracle Database: Develop PL/SQL Program Units courses.

Learn To:
– Conditionally control code flow (loops, control structures).
– Create stored procedures and functions
– Use PL/SQL packages to group and contain related constructs.
– Create triggers to solve business challenges.
– Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.
– Create custom packages for applications.

– Write Dynamic SQL code for applications.

Benefits to You:
Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.
Use Oracle SQL Developer

You will use Oracle SQL Developer to develop these program units. SQL*Plus is introduced in this course as optional tools.

Target audience:

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

Technical Consultant

Required Prerequisites:
– Oracle Database: Introduction to SQL
– Oracle Database: SQL Workshop II Ed 2

– Oracle Database: SQL Workshop I Ed 2

Suggested Prerequisites:

– Previous programming experience

Test: OCP

See more detailed description here.


Places left:
No participant limit
3385,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.