PRODUCT INFO

Product Guarantee

Testimonials

MAIN LINKS

Multi User Training CDs

	This Week's Special Offer NEW TITLE DISCOUNT!
Adobe Photoshop Elements 10 Tutorial

Quicktime is required for the movies, click here to download if needed.
Please Note: The online FREE lessons have been compressed for faster downloads. Purchased CD ROMs/DVDs load almost instantly and have higher sound and video quality. Please allow a few seconds for the FREE online tutorials to load. If you have any difficulties downloading these FREE online tutorials. Please do not hesitate to contact us for download help.

- See right for full details on these Beginners Oracle PL/SQL Tutorial Videos

- See far right to purchase this Beginners Oracle PL/SQL Training CD/DVD

Beginners Oracle PL/SQL Tutorial

SPECIAL OFFER: 20% DISCOUNT & FREE SHIPPING!

Professionally created, self-study video training.

About this Tutorial

show details

Gain a sound knowledge of this widely used programming language and get the most out of your Oracle databases with the help of these beginners Oracle PL/SQL tutorial videos. Commencing from the basics, certified PL/SQL developer Lewis Cunningham uses easy-to-follow, step-by-step video training movies that help explain and demonstrate the key concepts of programming with PL/SQL. Through almost eight hours of professionally created video training, the tuition includes Data Types explained, learning Data Structure, programming PL/SQL, lessons on Functions, Dynamic SQL and so much more. The complete training course contents are laid out below and you can start learning right away, click any of the blue linked lessons to sample the FREE Oracle PL/SQL video tutorials and discover just how effective this teaching method is...

hide details

Learn this Software - See below for FREE TUTORIALS

Each Course on 1 or 2 CDs or Download
For Mac and PC

FREE Shipping on ALL Orders

Beginners Oracle PL/SQL Tutorial Info

Tutor: Lewis Cunningham
Duration: 7.5 hrs / 74 video lessons
Cost for UK: £79.95 £63.95 + VAT
Cost for EU: €84.95 €67.95 + VAT
Cost for US & Canada: $124.95 $99.94 *no further discounts can be applied
Product Code: 01659
DELIVERY DETAILS Downloads: Training downloadable when payment processed (by next working day) CDs: Please allow 2-3 days for UK, Europe US & Canada, 3-5 days rest of world IN STOCK - All CDs Shipped Carriage FREE -
Compatibility: MS Windows 7, Vista, XP, 2000, 98, NT, Mac OS X, OS 9

DON'T TAKE OUR WORD FOR IT, SEE OUR CUSTOMER TESTIMONIALS

Benefits of this Software Training

Tuition by expert tutors.

Narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter.

Learning is fast as the trainers provide a beginners guide using simplistic terms and minimal jargon.

Personal Tutoring - Step-by-step video training from your own desktop. Delivered via DVD/CD training or online tuition.

The tutor transfers knowledge to you quickly and effectively.

All the concepts of each application are explained clearly and precisely.

Every course works on PC and Mac.

Alternative to a boring book or manual and expensive training courses, seminars, workshops & classes.

Jump to and from lessons - learn at your own pace.

The visual and practical nature shortens the learning curve compared to standard training manuals and for dummies books.
Customer Testimonials

CD CONTENTS & FREE VIDEO TUTORIALS

Click on any linked lesson below for a FREE demo
Purchased CD tutorials load almost instantly and have higher sound & video quality. For tutorial support see left

FREE Sample Videos from this Course

Strings

Numbers

Hello World

NDS - Lesson 1

We hope you enjoyed the FREE lessons. To view the complete contents, including ALL the lessons below & above, please purchase the course via CD or Download

Introduction
What Is PL/SQL
Course Expectations

An Overview Of PL/SQL
The Difference Between SQL And PL/SQL
Where To Access Oracle - Lesson 1
Where To Access Oracle - Lesson 2
Block Structure
Functions Procedures Packages
Data Types
Complex Objects
Variables Constants Parameters - Lesson 1
Variables Constants Parameters - Lesson 2
Flow Control
Errors Exceptions
Commenting Code

Data Types In Detail
Strings
Numbers
Date And Time
Booleans Lobs

Complex Data Structures
Records
Associative Array
Nested Tables
Varrays
Arrays Of Records

Programming PL/SQL
SQLplus
SQL Developer - Lesson 1
SQL Developer - Lesson 2

A First Program
Hello World
Create Assign Use Variables
Create Procedure
Autonomous Transactions

Flow Control
If Statements
Case Statements
Loops - Lesson 1
Loops - Lesson 2

Functions
Functions - Lesson 1
Functions - Lesson 2
Built in Functions

Exception Handling
What Are Exceptions - Lesson 1
Predefined Exceptions
Raising Exceptions
Suggestions For Exception Handling
User Defined Exceptions

SQL In PL/SQL
Inserting In PL/SQL
Updates And Deletes In PL/SQL
Selecting Data In PL/SQL
Cursors
Cursor For Loops
Bulk Operations

Packages
Package Specifications
Package Bodies
Public And Private Globals - Lesson 1
Public And Private Globals - Lesson 2
Package Initialization
Forward Declarations
Package Cursors
Utl File
Overloading

Triggers
DML Triggers
Compound Triggers
Instead Of Triggers
Database Triggers

PL/SQL Objects
Object Types
Constructors
Members
Equality
Inheritance

Dynamic SQL
Dynamic SQL
DBMS SQL - Lesson 1
DBMS SQL - Lesson 2
DBMS SQL - Lesson 3
DBMS SQL - Lesson 4
NDS - Lesson 1
NDS - Lesson 2

About The Oracle PL/SQL Trainer
About The Oracle PL/SQL Tutor


[ Home \| Video Training CDs/DVD \| Site Map \| Resources \| Specialist Categories \| Specialist Categories 2 \| Specialist Categories 3 ]
UK & Europe Marrutt Software Training Bellbrook Industrial Estate Uckfield, East Sussex, TN22 1QL United Kingdom UK Tel: +44 (0) 1825 764057 UK Fax: +44 (0) 1825 768841	US & Canada Marrutt Software Training 244 5th Ave # 1877 New York, NY 10001 United States US Tel: 646-736-7932 US Fax: 646-895-7649