Checkout | Help

Training Home | Programming | Oracle PL/SQL Programming

Learning Oracle PL/SQL Tutorial DVD - Video Training

Take your skills to the next level. This Learning Oracle PL/SQL Tutorial Video is the ultimate in comprehensive instruction for the discerning professional.

These training classes use broadcast quality audio and video to deliver concise and informative training right to your desktop. The course is presented via an intuitive, easy-to-use interface, allowing you to learn at your own pace.

These Learning Oracle PL/SQL Tutorials break even the most complex subjects down into easy to follow segments, following along is simple. Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of training.

Share |

Self Paced, Affordable Training Videos - Tutorials Taught by Professionals

Learn Oracle PL/SQL from a professional trainer from your own desk.
Suitable for beginners to advanced users. ideal for users who learn faster when shown.
Visual training method, offering users increased retention and accelerated learning.
Breaks even the most complex applications down into simplistic steps.

For evaluation purposes the links below offer a free insight into the quality of these Learning Oracle PL/SQL tutorials.

Adobe CS5 Discounted Bundle

Interested in Adobe CS5 Products? You may wish to take advantage of our Discounted Training Bundle

OVER 68 hours of Adobe Training Videos ( 955 Lessons ) - ONLY $524.95. You save over $174.00

Need to learn more than one Adobe Product? Why not save over $174 and have all the training you need in one convenient package with our Adobe CS5 Suite Discounted Bundle.

Customer Testimonials

Just a quick note to let you know how much I enjoy learning from Larry Jordan. I was about to give up trying to learn video editing when I accidentally discovered Larry Jordan and FCP. Now I'm energized again and having fun!! I really enjoy the time I spend on your site. Keep up the good work.
dale e.

00. Free Videos From This Course

01. Introduction

0101 What Is PL/SQL
0102 Course Expectations

02. An Overview Of PL/SQL

0201 The Difference Between SQL And PL/SQL
0202 Where To Access Oracle - Part 1
0203 Where To Access Oracle - Part 2
0204 Block Structure
0205 Functions Procedures Packages
0206 Data Types
0207 Complex Objects
0208 Variables Constants Parameters - Part 1
0209 Variables Constants Parameters - Part 2
0210 Flow Control
0211 Errors Exceptions
0212 Commenting Code

03. Data Types In Detail

0301 Strings
0302 Numbers
0303 Date And Time
0304 Booleans Lobs

04. Complex Data Structures

0401 Records
0402 Associative Array
0403 Nested Tables
0404 Varrays
0405 Arrays Of Records

05. Programming PL/SQL

0501 SQLplus
0502 SQL Developer - Part 1
0503 SQL Developer - Part 2

06. A First Program

0601 Hello World
0602 Create Assign Use Variables
0603 Create Procedure
0604 Autonomous Transactions

07. Flow Control

0701 If Statements
0702 Case Statements
0703 Loops - Part 1
0704 Loops - Part 2

08. Functions

0801 Functions - Part 1
0802 Functions - Part 2
0803 Built in Functions

09. Exception Handling

0901 What Are Exceptions - Part 1
0902 Predefined Exceptions
0903 Raising Exceptions
0904 Suggestions For Exception Handling
0905 User Defined Exceptions

10. SQL In PL/SQL

1001 Inserting In PL/SQL
1002 Updates And Deletes In PL/SQL
1003 Selecting Data In PL/SQL
1004 Cursors
1005 Cursor For Loops
1006 Bulk Operations

11. Packages

1101 Package Specifications
1102 Package Bodies
1103 Public And Private Globals - Part 1
1104 Public And Private Globals - Part 2
1105 Package Initialization
1106 Forward Declarations
1107 Package Cursors
1108 Utl File
1109 Overloading

12. Triggers

1201 DML Triggers
1202 Compound Triggers
1203 Instead Of Triggers
1204 Database Triggers

13. PL/SQL Objects

1301 Object Types
1302 Constructors
1303 Members
1304 Equality
1305 Inheritance

14. Dynamic SQL

1401 Dynamic SQL
1402 DBMS SQL - Part 1
1403 DBMS SQL - Part 2
1404 DBMS SQL - Part 3
1405 DBMS SQL - Part 4
1406 NDS - Part 1
1407 NDS - Part 2

15. About The Author

1501 About Me

Oracle PL/SQL Training Video Info

Title Information.

In this training course by Lewis Cunningham on Oracle PL/SQL Programming, you will learn how to utilize the procedural language extension for SQL in the Oracle relational database. Lewis Cunningham is one of an elite group of Oracle ACE Directors, and a certified PL/SQL developer. With over 15 years experience modelling, developing and architecting Oracle databases, you are learning from one of the best in the industry.

Starting with the basic outline of what PL/SQL is, you will set the ground work for your knowledge expansion by learning about data types, flow control, errors, and more. You will explore strings, numbers, booleans, and arrays. From there, Lewis jumps into creating programs, using if statements, loops functions, how to handle exceptions, using packages, and even objects. This computer based training tutorial really is an in-depth look at programming with PL/SQL like no other out there!

By the conclusion of this video training tutorial, you will be fully versed in the use of the Oracle PL/SQL for getting the most out of your Oracle databases. Extensive working files are included so you can work alongside the author as he trains you in the use PL/SQL. Close »

Instructor : Lewis Cunningham

All Training Courses by this author

Publisher:

InfiniteSkills - SKU: 01659

Duration:

7.5 hours - 74 lessons

Date Released:

2011-10-20

Platform:

Windows PC or Mac

Format :

Download or DVD-ROM

Price:

$99.95

£63.99

€74.99

Select your delivery option

Related Learning Oracle PL/SQL Training Videos :

Multi User Version Available

An affordable way to train multiple users
This course is also available in multi-user format which is ideal for corporate users, schools and universities. The multi-user training loads directly onto your own server and delivers training to multiple users over your own network. It's easy to install and can be integrated into existing learning systems or used as a stand alone solution. Additional information...

Cost Per 10 User Licence:
	$500.00		£320.1		€375.15

Unlimited Learning for Schools & Government

Ideal for Schools, Universities and Government bodies, that are interested in training an unlimited number of users in a wide range of different applications. A cost-effective learning platform that delivers content over your own network. Simple to install and configure, it can be integrated into an existing LCMS or used as a standalone learning platform to deliver on demand training classes anywhere within your organization.
More Information

100% Money Back Guarantee

Complete Customer Satifaction is our goal.
All InfiniteSkills Training DVDs come with a 100% money back guarantee. If your not happy with your Training DVD just contact our sales department within 30 days of purchase for a refund.

Join our Newsletter and Save

By joining our newsletter you will be notified of special offers and limited promotions. We don't sell, rent or otherwise disclose your details to any 3rd party. Sign up today and take advantage.

Just Released Training Titles

Web Programming With Python
Learning Adobe Photoshop Lightroom 4
Learning CSS3
Learning MySQL 5
Learning Oracle 11g

View All Our Free Content on the iPad

Got An iPad, Why Not View All Our Free Movies? Keep up to date with all our new and current releases, right from your iPad, just download our free App directly from Apple and you're set to go. Content will be added automatically as new titles are released. It's easy to use, it's Portable and it's FREE

Customer Comments

Just wanted to say that I love the new HD tutorials. I think you guys are really kicking it up a notch with that. And also, I love the new Creative Inspiration tutorials. I hope this is going to be a whole series with all kinds of different professionals. Anyhoo, just wanted to say that I am a really happy customer and love the new features and tutorials.
benjamin w.

Infinite Skills Inc
T: 858-866-9147.
Email :