30% OFF Marked Prices & FREE Shipping!   -   ENDS 5PM FRIDAY!   -   Use Discount Code 303

Oracle PL/SQL Tutorial

A professionally created, self-study video training course
Includes 8 hours of easy to follow Oracle PL/SQL video tutorials presented by an industry expert.
The training is delivered to your desktop allowing you to learn at a time that suits you and at your own pace.
You can start learning online right away. Sample Oracle PL/SQL tutorial videos by clicking a blue link below:
  • Tutor: Lewis Cunningham
  • Duration: 8 hours
  • Video lessons: 74
  • Product code: 01659
  • In stock: YES
  • Available on: Digital Download
  • Work files included: YES
  • Works on: MS Windows PC & Mac
  • Later course available: Yes, Oracle 12c tutorial
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...
What Our Customers Are Saying

"With all the training Manuals I've purchased, I must say that this is the best instructional on this piece of software i've come across. I feel that I will now be able to tap into that power with this excellent tutorial."Ian Ramsden, Fusion Systems;
COMPLETE COURSE CONTENTS
We hope you enjoyed the free lessons. To view the complete contents, including all lessons below & above, please purchase the course via Download.
Paid Content
Section

Get all lessons with purchase
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
Purchase Info - 30% OFF MARKED PRICE!
This course is available via digital download and is priced as below:
PRICE
CURRENCY
   
 
Item(s):
Once purchased, you will receive 74 Oracle PL/SQL training videos (listed left), lasting a total of 8 hours and the working files.

Worldwide
Shipping
Delivery Details
Download Course downloadable when payment processed (within one hour average)
WE AIM TO PLEASE
All DVD courses have a 100% money back guarantee. If you are not happy with your course contact us within 30 days of purchase for a refund.
View our full product guarantee
|
Need to Train Multiple Users?
This Oracle PL/SQL course is available in multi-user format ideal for corporate users, schools and universities.

The course loads directly onto your server and delivered to multiple users over your network.

An unlimited number of users can access the training with a pre-determined number viewing the tuition at any one time.

Training Multiple Users

Load onto your server
Deliver on your network or existing learning management system


USING THE SAME EXCELLENT CONTENT AS SINGLE USER COURSES
For companies and educational establishments wanting multi user access to training resources, we offer this Oracle PL/SQL course to do just that.
Now you can integrate training or technical support within your own computer network, or allow employees or students to gain access to training and support from home or any other location that they can gain access to your organizations network.

EASILY VIEWED OVER A NETWORK
The courses can be played over a LAN using a standard browser such as Microsoft Internet Explorer, Safari or Firefox.
The movies are viewed using Adobe Flash (same method as YouTube) and are slightly compressed in order to not clog the network.
All advanced and the "for dummies" courses are available via this multi user solution and can be copied directly to a hard disk for faster access and the access page may be customized, if needed, using a html editor.

ADDITIONAL USERS AND TITLES CAN BE ADDED
More than one title can exist on your server and the supplied player will automatically show titles that are available.
Simply purchase more user licences (supplied as files) and drop them into the folder. This will automatically increase the number of users allowed onto the system. All purchases are backed up by excellent after-sales support team and easy to follow instruction manual.
You can order multi user online or speak to our knowledgeable sales team.
Multi users are sold in 10 user licenses. For each 10 user licenses, you can have up to 10 people viewing that training at any one time.
Closely Related Courses
We recommend the Oracle 11g Tutorial
See our complete range of Oracle tutorials
Prove Your Capabilities
Once a course is completed you can download a free certificate.

This certifies that you have started from the beginners level, have now viewed all instruction. The certificate advises you now possess essential skills and an in-depth knowledge of Oracle PL/SQL. Show your boss or potential employer!
Weekly Special
Promoted Course
View sample videos from the new
AutoCAD 2016
A recent customer speaks out...
"Thank you so much, this tutorial is incredible! I have never learned how to use a software package so fast and in such a fun way before, presenter Andy has a style and sense of humour that is bang on. thank you!"Tadgh Creed, Texas