Oracle SQL / PL

Computeraid is the largest supplier independent computer training and consultancy company in South Wales, training around 20,000 people days annually. Computeraid is supplier-independent so does not sell hardware or software. As well as training thousands of staff from hundreds of smaller companies Computeraid also works with many of the largest organisations in the region. References from all sources are excellent. We offer a range of commercial training options, funded courses and subsidised consultancy. With training centres in Swansea, Cardiff, Neath and Carmarthen we are within easy reach of businesses throughout South Wales.

Company History

Computeraid was founded in 1988 and celebrated its 10th anniversary year by being awarded the Western Mail "Welsh Small Business of the Year" award. Our qualified and dedicated tutors have provided training solutions for thousands of businesses over the last twenty years.

Computeraid is an Investors in People organisation.

Course Objectives

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

Course Contents

• 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

Course Details

This is a two-day course running from 9:30 am - 4:30 pm.
Courses run in Cardiff.

Prerequisites

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.

What Next?

Oracle SQL
This course is designed for anyone who needs to access and work with an Oracle Database.