TOD Oracle Database: Program with PL/SQL

Difficulty
Rating
2925,00 
+ VAT
Contact sales to ask for Sovelto Access price: +358 20 7776 670 or myyntipalvelu@sovelto.fi

Language: English

This Oracle Database: Program with PL/SQL self-study 90 days training period starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language. Through hands-on instruction from expert Oracle instructors, you’ll learn to develop stored procedures, functions, packages and more.

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.
What’s Oracle Training on Demand (TOD)? Learn more >>

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.

Course Bundle

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

See detailed course outline here.

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

Need more information about flexible Oracle learning options?

Choose a training that fits best your learning style and schedule. To hear more about virtual and self-paced training formats, please contact Personal Customer Service info@sovelto.fi or through chat-service.

 

Keywords: ,

 

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