[Plus Plus Pty Ltd]

Plus Plus Pty Ltd

PL/SQL - 2 days

Objectives

This course covers the essentials of Oracle's PL/SQL programming language.

Expected outcomes

Upon successful completion of this course you will be able to:

Audience

This course is aimed at those who want to learn the basics of Oracle's PL/SQL language.

Prerequisites

SQL knowledge to the level of our Introduction to SQL is required.

No programming experience is necessary, although the Introduction to Programming course would be beneficial to those with no programming background.

Outline

Concepts

What is PL/SQL? How does it relate to SQL? What database do I need?
A brief history
Getting ready to use PL/SQL
Other environments using PL/SQL

The basics

An introduction to the example
Basic code structure
Using SQL with PL/SQL
Declaring variables
Datatypes: numeric, character, boolean, date
Arithmetic operators
String operations
Flow control
Looping (LOOP, WHILE, FOR)
Cursors and Cursor FOR loops

Moving on

User defined data types
Handling abnormal errors: Raising and catching Exceptions
Array handling
Procedures
Functions
Triggers

Also available

Introduction to Programming (1 day)
Introduction to SQL (1 day)


[ home ] [ training ] [ consulting ] [ development ] [ contact ]

Copyright © 2007 Plus Plus Pty Ltd
Last modified: 21 November 2007
[Christian]