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.

Difficulty
Rating
5days
Duration
3385,00 
+ VAT
Dates:
Location:
Register before 26.05.2018
Spoken language: Finnish

We are sorry, but the course is already full, please try with another date or location.

Agenda

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
Developer
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.

Agenda

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