Oracle PL SQL

Duration: 
2 days
Codes: 
STA-OPI,PL,SQL

Overview

Not available. Please contact.

Audience

Who will the Course Benefit? Who 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.

Skills Gained

The delegate will learn and acquire skills as follows:

  • Writing and running PL/SQL programs from SQL*Plus or SQL Developer
  • Assigning and manipulating values
  • Using SQL statements within PL/SQL
  • Implementing conditional execution and loop constructs
  • 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

Using PL/SQL table built-in functions Course Objectives Course Objectives

To provide the skills needed to write stand-alone programs using the main features of Oracle's PL/SQL Programming Language.

Prerequisites

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.

Course Outline

Not available. Please contact.

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
Bristol Bristol2 1500 £1500 2019-09-19
Bristol Bristol2 1500 £1500 2019-09-19
Yorkshire Leeds2 1500 £1500 2019-09-26
Yorkshire Leeds2 1500 £1500 2019-09-26
London London2 1500 £1500 2019-10-03
Edinburgh Edinburgh2 1500 £1500 2019-10-03
Edinburgh Edinburgh2 1500 £1500 2019-10-03
London London2 1500 £1500 2019-10-03
Manchester Manchester2 1500 £1500 2019-10-10
Manchester Manchester2 1500 £1500 2019-10-10
Midlands Birmingham2 1500 £1500 2019-10-17
Midlands Birmingham2 1500 £1500 2019-10-17
London London2 1500 £1500 2019-10-31
London London2 1500 £1500 2019-10-31
London London2 1500 £1500 2019-11-11
London London2 1500 £1500 2019-11-11
Yorkshire Leeds2 1500 £1500 2019-11-14
Bristol Bristol2 1500 £1500 2019-11-14
Yorkshire Leeds2 1500 £1500 2019-11-14
Bristol Bristol2 1500 £1500 2019-11-14
London London2 1500 £1500 2019-11-28
Edinburgh Edinburgh2 1500 £1500 2019-11-28
Edinburgh Edinburgh2 1500 £1500 2019-11-28
London London2 1500 £1500 2019-11-28
Manchester Manchester2 1500 £1500 2019-12-05
Manchester Manchester2 1500 £1500 2019-12-05
Midlands Birmingham2 1500 £1500 2019-12-12
Midlands Birmingham2 1500 £1500 2019-12-12
London London2 1500 £1500 2020-01-09
London London2 1500 £1500 2020-01-09
Yorkshire Leeds2 1500 £1500 2020-01-16