PL/SQL

Catalyst Learning
London, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course 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. Together with the PL/SQL Stored Program Units course, this course is suitable for delegates intending to sit the Oracle 9i PL/SQL Developer Certified Associate Examination #1Z0-147.

Together with the SQL course, this course is suitable for delegates intending to sit the Introduction to Oracle SQL and PL/SQL Examination #1Z0-001.


Topics Covered:

Program Blocks
Variables and Constants
Data Types
Using SQL Statements within PL/SQL Programs
Generating SQL*Plus and iSQLPlus 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 iSQL*Plus 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.
...''

Phone:0800 953 0387

School Address:

175 Tottenham Court Road
London, W1T 7NU
UK

Jobs & Resumes: London
Houses & Roommates: London

Linux Essentials (LPI)
Linux System Administration (LPI)
Linux Advanced System Administration (LPI)
Lotus
Nortel Networks
MCDST, MCSA, MCSE, MCDBA, MCAD, MCSD
Novell
Relational Databases
Introduction to SQL
ORACLE Overview
ORACLE Fundamentals
Oracle Program with PL/SQL
PL/SQL Web Applications
SQL Performance Tuning
Forms Web Deployment
DBA Fundamentals
Oracle Database 10g DBA using Enterprise Manager
10g Discoverer for Administrators
Oracle 10g Application Server Administration

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Try the search form on top of each page to find the latest course information, using course topic and location as keywords. Keep the course topic keyword short to get more results.