Oracle PL/SQL

Course

In Bristol, London, Edinburgh and 3 other venues

£ 725 VAT inc.

Description

  • Class hours

    14h

  • Duration

    2 Days

Description

By the end of the course, the delegate will be able to write programs which use some or all of the primary PL/SQL programming constructs.
Suitable for: This 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.

Facilities

Location

Starts

Birmingham (West Midlands)
See map
C/O Netcom Training Solutions, 6th Floor, Quay Side Tower, Broad Street, Birmingham B1 2hf, B5 4UA

Starts

On request
Bristol (Avon)
See map
C/O Computerworld, Apex House, Westerleigh Business Park, Turner Drive, Yate, BS37 5YX

Starts

On request
Edinburgh (Midlothian/Edinburghshire)
See map
16 St Mary'S Street, EH1 1SU

Starts

On request
Leeds (West Midlands)
See map
Halsbury House, Chancellor Court, 21 The Calls, LS2 7EH

Starts

On request
London
See map
6 Long Lane, Barbican, EC1A 9HF

Starts

On request
Manchester (Greater Manchester)
See map
C/O Yses, St James Court, 30 Brown Street, M2 1DH

Starts

On request
See all (6)

To take into account

A working knowledge of Oracle's SQL*Plus or SQL Developer products and practical experience in writing SQL statements.  This can be gained by attendance on the Pre-Requisite course.  Some previous programming experience will also prove advantageous.

Questions & Answers

Ask a question and other users will answer you

Who do you want to respond to your question/enquiry?

We will only publish your name and question

Subjects

  • PL/SQL
  • To provide the skills needed to write stand-alone programs using the main features of Oracle's PL/SQL Programming Language
  • Writing and running PL/SQL programs from SQL*Plus or SQL Developer

Course programme

Delegates:

This 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.

Objectives:


By the end of the course, the delegate will be able to write programs which use some or all of the primary PL/SQL programming constructs.

Together with the PL/SQL Stored Program Units course, this course is suitable for delegates intending to sit the Oracle examination #1Z0-147: Program with PL/SQL .

Note:

Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience.

Topics Covered:
  • Program Blocks
  • Variables and Constants
  • Data Types
  • Using SQL Statements within PL/SQL Programs
  • Generating SQL*Plus and SQL Developer Output
  • IF THEN ELSIF ELSE Statements
  • CASE Expressions
  • Basic Loops
  • The WHILE and FOR Loops
  • Nested and Labelled Loops
  • Using Cursors
  • Parameterised Cursors
  • Handling Named and UnNamed Exceptions
  • Generating User Defined Exceptions
  • Nested and Labelled Block Structures
  • Scope of Variables
  • PL/SQL Records
  • PL/SQL Tables of Records
  • Handling PL/SQL Tables
Requirements:

A working knowledge of Oracle's SQL*Plus or SQL Developer products and practical experience in writing SQL statements. This can be gained by attendance on the Pre-Requisite course. Some previous programming experience will also prove advantageous.

Oracle PL/SQL

£ 725 VAT inc.