Oracle PL/SQL Introduction

Focus on Training

Course

In London-City and Birmingham

£ 695 + VAT

The best Oracle courses

See all

See all

Description

  • Type

    Course

The Oracle PL/SQL course is designed to introduce Oracle DBAs, software development personnel and database support staff to the primary features and constructs of the PL/SQL Programming Language. Learning Objectives
To proivde the skills needed to write stand-alone programs using the main fetures of Oracle's Pl/SQL Programming LanguageWho will the Course Benefit?Oracle database administrators, software development personnel and database support staff who need to write PL/SQL scripts to enhance their productivity in manipulating data.

Facilities

Location

Start date

Birmingham ((select))
B3 2HJ

Start date

On request
London-City ((select))
EC3V 9LJ

Start date

On request

About this course

A working knowledge of SQL*Plus or SQL Developer and Oracle SQL is required along with practical experience in writing SQL statements. This can be obtained by attendance on the pre-requisite course. Some previous programming experience will also prove advantageous

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

  • Programming
  • Database training
  • PL/SQL
  • SQL
  • Database
  • Staff
  • Personnel

Course programme

The delegates will practise:

  • Writing and running PL/SQL programs from SQL*Plus or SQL Developer
  • Declaring and using variables and constants
  • Assigning and manipulating values
  • Using SQL statements within PL/SQL
  • Implementing conditional execution and loop constructs
  • Declaring and using cursors with and without parameters
  • Updating data with cursors
  • Trapping and handling errors and exceptions in code
  • Implementing nested and labelled loops and blocks
  • Raising exceptions
  • Handling PL/SQL records and tables
  • Using PL/SQL table built-in functions

See related categories

Oracle PL/SQL Introduction

£ 695 + VAT

The best Oracle courses

See all

See all