Self Study, Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. Works on both PC and Mac.

These Oracle SQL PL / SQL tutorials are an indispensable reference for programmers that wish to have a much stronger understanding of Oracle. Expert Gavin Powell has constructed this course with one objective in mind, to allow you to gain a strong understanding of Oracle and create more efficient code. This training course starts with a introduction into PL / SQL programming and as the training progresses the subjects that are covered get more advanced. A basic understanding of SQL and databases is a prerequisite before embarking on this PL/SQL Training Course.

Associated Tutorials: Beginners FileMaker | Microsoft SQL Server 2005 | Microsoft Transact SQL | Microsoft .NET Framework | FileMaker 10 | Intermediate FileMaker 10

Oracle SQL and PL / SQL Tutorial CD / DVD

When you order this Oracle SQL and PL / SQL Video Tutorial CD You'll Receive...
Over 12 hours of high quality video-based training that walks you through the program in easy to follow stages.

A training video that focuses on real life examples and teaches you
real life skills. These tutorials are structured to increase not only your skills but also your earning potential.

With this Training Video you will...
Learn Oracle SQL and PL / SQL from a leading expert and quickly master the skills required to work in a commercial environment.

Learn how to simplify your workflow and increase your productivity using tips and techniques of the pros. Ideal training for Beginners and Advanced users alike

Customer Comments
" I just spent four years in university classes, and what I learned on one of your training disks would have taken a whole semester (and cost a lot more money)." Judy Craig, New Hampshire

Oracle SQL and PL / SQL Tutorial CD / DVD

Create the best self-paced learning environment right on your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

Topics Covered on this Training Course

This Training is 12 Hours in Duration and Covers 165 Lessons.
Welcome The Oracle Relational Database Model Oracle SQL and PL/SQL Tools
We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.
$99.95
The Architecture of Oracle
  • The Oracle Database and Oracle Instance 1
  • The Oracle Database and Oracle Instance 2
  • Control Files, Logging, Archiving and Recoverability
Creating Database Objects
  • Oracle Simple Datatypes 1
  • Oracle Simple Datatypes 2
  • Oracle Complex and Object Datatypes
  • Types of Tables
  • Methods of Table Creation
  • Create Table Syntax
  • Example Table Creations Tutorials 1
  • Example Table Creations 2
  • Altering and Dropping Tables 1
  • Altering and Dropping Tables 2
  • What are Constraints?
  • Creating, Changing and Dropping Constraints
  • Types of Indexes 1
  • Types of Indexes 2
  • Creating, Altering and Dropping Indexes
  • Sequence Counters
  • Synonyms
  • Views Tutorials 1
  • Views 2
  • Metadata Views and Error Messages
Users and Security
  • Schemas, Users, Privileges and Roles 1
  • Schemas, Users, Privileges and Roles 2
  • Schemas, Users, Privileges and Roles 3
  • Types of Users
  • Creating Users Tutorials 1
  • Creating Users 2
  • Altering and Dropping Users
  • Security
  • Oracle SQL PL System Privileges
  • Object Privileges
  • Granting and Revoking Privileges Tutorials 1
  • Granting and Revoking Privileges 2
  • Grouping Privileges Using Roles 1
  • Grouping Privileges Using Roles 2
  • Setting Roles
Retrieving Data from the Database
  • Oracle PL SQL SELECT Statement Tutorials 1
  • The SELECT Statement 2
  • The SELECT Statement 3
  • Types of SELECT Statement 1
  • Types of SELECT Statement 2
  • The DUAL Table 1
  • The DUAL Table 2
  • What is a NULL?
  • Pseudo-Columns 1
  • Pseudo-Columns 2
  • More About Oracle PL SQL Plus Formatting 1
  • More About SQL Plus Formatting 2
  • More About SQL Plus Formatting 3
Oracle Built In Functions
  • Types of Functions Tutorials 1
  • Types of Functions 2
  • String Functions 1
  • String Functions 2
  • String Functions 3
  • Number Functions
  • Oracle PL SQL Date Functions 1
  • Date Functions 2
  • Other Functions 1
  • Other Functions 2
  • Datatype Conversion Functions 1
  • Datatype Conversion Functions 2
  • Custom Functions Using PL/SQL
Filtering SELECT Statements
  • The WHERE Clause
  • Conditional Comparisons
  • Using the WHERE Clause
  • Using Logical Operators Tutorials 1
  • Using Logical Operators 2
  • Using Conditional Comparisons 1
  • Using Conditional Comparisons 2
Sorting SELECT Statements
  • The ORDER BY Clause
  • Sorting Methods Tutorials 1
  • Sorting Methods 2
  • Sorting Methods 3
Joining Multiple Tables
  • What is a Join?
  • Two Join Syntax Formats
  • Types of Joins Tutorials 1
  • Types of Joins 2
  • Types of Joins 3
  • Cross Join or Cartesian Product
  • SQL PL Natural or Inner Join 1
  • Change the Concerts Schema 1
  • Change the Concerts Schema 2
  • Oracle PL SQL Outer Join 1
  • Outer Join 2
  • Self Join
  • Equi-Joins, Anti-Joins and Range-Joins
  • Mutable and Complex Joins
Summarizing with GROUP BY
  • What does GROUP BY Do?
  • The GROUP BY Clause
  • Types of Grouping Functions 1
  • Types of Grouping Functions 2
  • Special Behavior 1
  • Special Behavior 2
  • Summary Functions
  • Statistical Functions
  • Other Functions
  • Filtering GROUP BY with the HAVING Clause
  • Extending the GROUP BY Clause Tutorials 1
  • Extending the GROUP BY Clause 2
Subqueries and Other Advanced Queries
  • What is a Subquery?
  • Types of Subqueries
  • Comparison Conditions Revisited 1
  • Comparison Conditions Revisited 2
  • Comparison Conditions Revisited 3
  • Regular vs. Correlated Subqueries
  • Nested Subqueries and Replacing Joins
  • Where Can PL SQL Subqueries be Used?
  • Hierarchical Queries
  • Set Operators and Composite Queries
Oracle Data Manipulation Language (DML)
  • What is DML?
  • Adding Data with INSERT
  • Multiple Table INSERT Tutorials 1
  • Multiple Table INSERT 2
  • Changing Data with UPDATE 1
  • Changing Data with UPDATE 2
  • Remove Data with DELETE or TRUNCATE Tutorials 1
  • Remove Data with DELETE or TRUNCATE 2
  • Merging Tables with MERGE 1
  • Merging Tables with MERGE 2
  • Transactional Control
  • Locking and Visibility of Data Changes
  • COMMIT vs ROLLBACK
PL SQL (Programming Language SQL)
  • What is PL/SQL?
  • Anonymous Procedures
  • Modular Structure
  • Named Procedures
  • Functions
  • Packages
  • Oracle PL SQL Triggers Tutorials 1
  • Triggers 2
  • Variables and Types in PL/SQL 1
  • Variables and Types in PL/SQL 2
  • Objects and Object Datatypes
  • More About Objects 1
  • More About Objects 2
  • Programming Control Structures
  • Simple Database Access in PL/SQL
  • Cursors and Implicit Cursors 1
  • Cursors and Implicit Cursors 2
  • Explicit Cursor Tutorials 1
  • Explicit Cursors 2
  • Dynamic SQL
  • Provided (DBMS_) Packages

Select Playback Format for the Free Demos:

Quicktime
Flash

Did You Know ?

We offer more than 700 video-based courses, and you can watch the first three chapters of every listed course for FREE with no obligation to buy.

About this Oracle SQL and PL / SQL Training CD

Title Oracle SQL and PL / SQL
Tutor Gavin Powell
Other tutorials by Gavin Powell
Videos 165 Lessons- Video run time: 12 hours
Compatibility Vista, XP, Windows 7, Mac OSX
Released 2003
Work files Yes
Availability Immediate Dispatch
Price US / Canadian Sales Only $99.95
Closed Captions Closed Captions are not Enabled on this title
90 in stock
Purchase Orders from Schools, Colleges, Government and Military Accepted

Mutli User Training Options

This training video is also available in Multi-user format, ideal for Schools, Universities, or Corporate users where training multiple delegates is the most cost effective way of training.

10 Multi User $500

Not Sure Which Titles to Buy? Unlimited Access to all -$30

Need to learn more than one topic? Get Unlimited Access to all the courses listed on this site for just $30!
Unlimited Access to over 70,000+ Training Videos

Not sure which training CD titles to purchase? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.
No contract .
No minimum period.
No commitment on your part.

Within minutes you'll have instant, unlimited access to over 700 courses covering over 6000+ hours of training, all from the comfort of your own desk.

Need to learn from more than one location? Not a problem, you're free to access the training from anywhere you wish. It's highly cost effective learning with no limits. We also offer Multi User accounts for companies and schools who need to train multiple users.
Online Learning with No Limits

Why Is This Training Format So Effective?

  • Learn Oracle SQL and PL / SQL from an accredited expert in days.

Want to hear what our customers say about our products?

Related Training Videos

Oracle PL/SQL | Microsoft SQL Server Admin Tutorials | Microsoft SQL Server Programming| Online Oracle SQL and PL / SQL Training Courses

Prove your Knowledge - Free Certificate

Prove Your Credentials!
Free Certificate.