TOD Oracle Database: PL/SQL Fundamentals

This self-study course introduces students to the PL/SQL programming language

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

Language: English

Or contact sales: +358 20 7776 670 or myyntipalvelu@sovelto.fi

The Oracle Database: PL/SQL Fundamentals Ed 2 course introduces students to the PL/SQL programming language.During 90 days of self-study period students learn to create PL/SQL blocks of application code.

What’s Oracle Training on Demand (TOD)? Learn more >>

Learn To:

  • Use various features of PL/SQL.
  • Write anonymous blocks of code in PL/SQL.
  • Use various PL/SQL conditional constructs and loops in program blocks.
  • Interface the PL/SQL code with the database.
  • Use stored procedures and functions in their program blocks.
  • Handle Exceptions in PL/SQL code.

Benefits To You

Students will benefit from this course as it enables programmers with the skill of using this programming language. Students will learn to create anonymous PL/SQL blocks, to create procedures, functions and triggers. Students will learn to use explicit cursors in their program blocks. Demonstrations and hands-on practice reinforce the fundamental concepts. Students use Oracle SQL Developer to develop these program units. SQL*Plus is introduced as optional tools.

Target audience

  • Database Administrators
  • System Analysts
  • Forms Developer
  • Technical Consultant
  • Portal Developer
  • PL/SQL Developer

Prerequisites

Suggested Prerequisite
  • Familiarity with data processing concepts and technique
  • Familiarity with programming languages
  • Familiarity with programming languages
  • Familiarity with data processing concepts and techniques
Required Prerequisite
  • Oracle Database 12c: Introduction for Experienced SQL Users

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.

 

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