Certificate in Oracle PL/SQL Development

Development Tool will be based upon Oracle SQL Developer and Oracle Database 12c

View Programme Brochure

DURATION:
2 Months
ID:
ERP-04
PRICE
LKR 35,000.00

INSTRUCTORS:

Nimesha Mutunayake
BSc Hons Computer Science (Sp.) | OCS

Categories

programmes

PL/SQL is used in the Oracle Database, and the Oracle Database is a fixture of enterprise systems world-wide, it will outlive you. High-performance batch processing has to happen close to the data, so PL/SQL will continue to rule in this area.

PL/SQL is a procedural language designed specifically to embrace SQL statements within its syntax. PL/SQL program units are compiled by the Oracle Database server and stored inside the database. And at run-time, both PL/SQL and SQL run within the same server process, bringing optimal efficiency. PL/SQL automatically inherits the robustness, security, and portability of the Oracle Database.

An application that uses Oracle Database is worthless unless only correct and complete data is persisted. The time-honored way to ensure this is to expose the database only via an interface that hides the implementation details – the tables and the SQL statements that operate on these. This approach is generally called the thick database paradigm, because PL/SQL subprograms inside the database issue the SQL statements from code that implements the surrounding business logic; and because the data can be changed and viewed only through a PL/SQL interface.

The value of a skill depends on the relationship between the number of people with the skill and the number of jobs requiring that skill. For PL/SQL, the amount of work is constant, but the number of people with PL/SQL skills is declining.
By 2020, the salary of PL/SQL programmers will have gone up as the scarcity sets in. By 2024, PL/SQL programming will have become a highly-paid specialty, and the salary increase will tempt new developers into the field.

This training programme delivers the fundamentals of SQL and PL/SQL along using Oracle Database technology. You will explore the concepts of relational databases. Demonstrations and hands-on practice will reinforce the fundamental concepts that you will learn in this course. You will be using Oracle SQL Developer to develop these program units. SQL*Plus is available as optional tools.

Objectives
At the end of the program the participants will learn to:

  • Write queries against single and multiple tables, manipulate data in tables and create database objects.
  • Use single row functions to customize output.
  • Invoke conversion functions and conditional expressions.
  • Use group functions to report aggregated data.
  • Create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.
  • Develop anonymous PL/SQL blocks, stored procedures and functions.
  • Declare identifiers and trap exceptions.
  • Use DML statements to manage data.
  • Use DDL statements to manage database objects.
  • Declare PL/SQL variables.
  • Conditionally control code flow (loops, control structures).
  • Describe stored procedures and functions.
  • Handle Pl/SQL transactions.

Requirements for Award of Certificates

  • Attendance – All 2 Months.
  • A score of 50 or above at the final exam.

Medium

  • English

logo

TOP