Certified PL-SQL Developer

Course

Online

£ 3,274.19 VAT inc.

*Indicative price

Original amount in USD:

$ 4,129

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    Flexible

  • Start date

    Different dates available

This PL/SQL Developer certification for Oracle database assesses the candidate for a company’s needs for developing PL/SQL based applications in Oracle database. The
certification tests the candidates on various areas of PL/SQL development which includes syntax, semantics, exception handling and transaction control.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Job seekers looking to find employment in IT department of various companies, students generally wanting to improve their skill set and make their CV stronger and existing employees looking for a better role can prove their employers the value of their skills through this certification.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • PL/SQL
  • Database
  • SQL
  • Database training
  • Programming
  • Software
  • Configuration
  • Hardware
  • Defining
  • Cursor variables
  • Code Management
  • Advanced Datatypes

Teachers and trainers (1)

Name Name

Name Name

Teacher

Course programme

PL/SQL Introduction

  • Relational database, oracle and PL/SQL
  • PL/SQL need and benefits

Configuration

  • Hardware and software pre-requisites
  • Oracle environment configure and test

PL/SQL programming constructs

  • Lexical elements and basic data types
  • Constants, variables, operators and expressions
  • Conditional and loop construct
  • Overloading and recursion

Code Block

  • Procedure and functions
  • Packages, INSTEAD OF and triggers
  • Compilation errors
  • Exception handling and custom exception

Cursors

  • Declaration and defining
  • Implicit cursors
  • Cursor variables, using PL/SQL functions, record updates and shortcuts

Code Management

  • Packaging and placement of code and triggers in database
  • Code placement in application server
  • Naming standard basics, need and norms

Advanced Datatypes

  • Clob, blob and bfile
  • Custom data types
  • Varray and bulk collect
  • Commit and rollback
  • Autonomous transactions

Additional information

PL/SQL Developer professionals are in great demand and companies in India looking for oracle database application development are hiring them.

Certified PL-SQL Developer

£ 3,274.19 VAT inc.

*Indicative price

Original amount in USD:

$ 4,129