Oracle Database: Program with PL/SQL

aktina
COURSE REGISTRATION
Oracle Database: Program with PL/SQL
Introduction

This course starts with an introduction to PL/SQL and proceeds to list the benefits of this powerful programming language. Through hands-on instruction from expert instructors, you’ll develop stored procedures, functions, packages and more.

Audience
  • Forms Developer
  • Portal Developer
  • Database Administrators
  • Developer
  • Technical Consultant
  • System Analysts
  • Application Developers
  • PL/SQL Developer
At Course Completion

You will learn To:

  • Conditionally control code flow (loops, control structures).
  • Use PL/SQL packages to group and contain related constructs.
  • Generate triggers to solve business challenges.
  • Create anonymous PL/SQL blocks, as well as stored procedures and functions.
  • Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.
  • Create anonymous PL/SQL blocks, functions and procedures.
  • Declare PL/SQL variables.
  • Create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.
  • Debug functions and procedures using the SQL Developer Debugger.
  • Use Dynamic SQL & understand design considerations when coding using PL/SQL.
  • Understand and influence the PL/SQL compiler and manage dependencies.
  • Manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions.
Prerequisites
  • Oracle Database: Introduction to SQL (combination of Oracle Database: SQL Fundamentals I and Oracle Database: SQL Fundamentals II listed)
  • Oracle Database: SQL Fundamentals I
  • Oracle Database: SQL Fundamentals II
Professional Exam(s):
Exam 1Z0-144: Oracle Database – Program with PL/SQL
Certification(s):
OCA – Oracle Certified Associate: PL/SQL Developer

Course Features

  • Lectures 21
  • Quizzes 0
  • Duration 50 hours
  • Skill level All levels
  • Language English
  • Students 0
  • Assessments Yes
City
Nicosia
Dates and Times
Duration (Hours)
40
Location
20 Loukis Akritas street 2064 Strovolos
(behind Kykko secondary schools)
City
Limassol
Dates and Times
Duration (Hours)
40
Location
22 Griva Digeni Avenue, 3106 Agios Nikolaos
(near Coop branch and Agios Nikolaos church)

For participants eligible for subsidy by the Human Resource Development Authority:
Participation * Course ManualExam
CourseOracle Press1Z0-144
Amount€550,00€70,00€212,00
VAT * €233,70€13,30
-
* denotes a course subsidised by the Human Resource Development Authority. VAT is applied on the amount before subsidy.

This course is also offered at a high discount as part of a bundle of 2 certification courses – click here 

For participants not eligible for subsidy by the Human Resource Development Authority:
Participation Course ManualExam
CourseOracle Press1Z0-144
Amount€875,00€70,00€212,00
VAT €166,25€13,30-

This course is also offered at a high discount as part of a bundle of 2 certification courses – click here

Take advantage of our special offer by taking this course as part of a bundle of 2 courses leading to the OCA – Oracle Certified Associate: PL/SQL Developer certification:

For participants eligible for subsidy by the Human Resource Development Authority:
Participation * Course ManualsExams
Courses PL/SQL & SQL Fund.Oracle Press - 2 books1Z0-144 & 1Z0-061
Amount€950,00€130,00€321,00
VAT * €438,90€24,70
-
* denotes a course subsidised by the Human Resource Development Authority. VAT is applied on the amount before subsidy.
For participants not eligible for subsidy by the Human Resource Development Authority:
ParticipationCourse ManualsExams
Courses PL/SQL & SQL Fund.Oracle Press - 2 books1Z0-144 & 1Z0-061
Amount€1,300,00€130,00€321,00
VAT€247,90€24,70
-

 

 

COURSE REGISTRATION

You May Like