Easy to follow Oracle SQL and PL / SQL Tutorial Videos and online training courses. These professionally created videos offer the user an accelerated way to master this application from the comfort of their own desktop. In addition to the Oracle SQL and PL / SQL tutorials we also list over 600 additional titles amounting to over 4000 hours, get unlimited access to all these courses for just $30 per month.

Oracle SQL and PL / SQL Tutorial Video - Try for FREE

Unlimited Professional Video Training on over 600+ applications and programming languages for only $30.

The fastest and most cost effective way to learn!
Forget boring books! No need for expensive classroom training.

Easy to follow tutorial videos that play right from your own computer. Login from home or office -- the choice is yours. All tutorials are taught by world-leading experts, giving you unlimited access to over 600 different subjects for an amazing low price!
Benefits of Online Learning
  • Unlimited viewing. No Hidden Costs
  • Downloadable working files.
  • Instant Access
  • Expert instructors.
  • Use at home / work or both.
  • Works on PC or Mac.
  • Telephone Tech support.
  • Cancel at any time.
  • 600+ courses for 1 low fee.
  • New titles added monthly.
  • 100% Guaranteed

Your are currently in Demo Mode
You are in Demo mode which only allows access to the first 3 chapters of this Oracle SQL and PL / SQL training course and all the other titles listed on this site, this is to help you evaluate the quality of the training before joining.

If you decide to join, you will instantly have totally UNLIMITED ACCESS to over 600 professionally created video tutorials, you will be able to access the content from any location, no restrictions are placed on the amount of content you can watch, and you can also cancel at any time you wish.
Over 4000 hours of training for just $30.00.


Get Instant Access to this Training Title and over 600 other video tutorials for just $30
Once a member you will have instant unrestricted access to this and every other title listed on this site. That’s an Amazing 6000+ hours worth of high quality video training for just $30.00 a month.

Try a Free demo, Click on any of the links below
Topics covered on this tutorial video include:
Welcome
The Relational Database Model
Oracle SQL and PL/SQL Tools
The Architecture of Oracle
  • The Oracle Database and Oracle Instance pt. 1
  • The Oracle Database and Oracle Instance pt. 2
  • Control Files, Logging, Archiving and Recoverability
Creating Database Objects
  • Oracle Simple Datatypes pt. 1
  • Oracle Simple Datatypes pt. 2
  • Oracle Complex and Object Datatypes
  • Types of Tables
  • Methods of Table Creation
  • Create Table Syntax
  • Example Table Creations pt. 1
  • Example Table Creations pt. 2
  • Altering and Dropping Tables pt. 1
  • Altering and Dropping Tables pt. 2
  • What are Constraints?
  • Creating, Changing and Dropping Constraints
  • Types of Indexes pt. 1
  • Types of Indexes pt. 2
  • Creating, Altering and Dropping Indexes
  • Sequence Counters
  • Synonyms
  • Views pt. 1
  • Views pt. 2
  • Metadata Views and Error Messages
Users and Security
  • Schemas, Users, Privileges and Roles pt. 1
  • Schemas, Users, Privileges and Roles pt. 2
  • Schemas, Users, Privileges and Roles pt. 3
  • Types of Users
  • Creating Users pt. 1
  • Creating Users pt. 2
  • Altering and Dropping Users
  • Security
  • System Privileges
  • Object Privileges
  • Granting and Revoking Privileges pt. 1
  • Granting and Revoking Privileges pt. 2
  • Grouping Privileges Using Roles pt. 1
  • Grouping Privileges Using Roles pt. 2
  • Setting Roles
Retrieving Data from the Database
  • The SELECT Statement pt. 1
  • The SELECT Statement pt. 2
  • The SELECT Statement pt. 3
  • Types of SELECT Statement pt. 1
  • Types of SELECT Statement pt. 2
  • The DUAL Table pt. 1
  • The DUAL Table pt. 2
  • What is a NULL?
  • Pseudo-Columns pt. 1
  • Pseudo-Columns pt. 2
  • More About SQL Plus Formatting pt. 1
  • More About SQL Plus Formatting pt. 2
  • More About SQL Plus Formatting pt. 3
Oracle Built In Functions
  • Types of Functions pt. 1
  • Types of Functions pt. 2
  • String Functions pt. 1
  • String Functions pt. 2
  • String Functions pt. 3
  • Number Functions
  • Date Functions pt. 1
  • Date Functions pt. 2
  • Other Functions pt. 1
  • Other Functions pt. 2
  • Datatype Conversion Functions pt. 1
  • Datatype Conversion Functions pt. 2
  • Custom Functions Using PL/SQL
Filtering SELECT Statements
  • The WHERE Clause
  • Conditional Comparisons
  • Using the WHERE Clause
  • Using Logical Operators pt. 1
  • Using Logical Operators pt. 2
  • Using Conditional Comparisons pt. 1
  • Using Conditional Comparisons pt. 2
Sorting SELECT Statements
  • The ORDER BY Clause
  • Sorting Methods
Joining Multiple Tables
  • What is a Join?
  • Two Join Syntax Formats
  • Types of Joins pt. 1
  • Types of Joins pt. 2
  • Types of Joins pt. 3
  • Cross Join or Cartesian Product
  • Natural or Inner Join pt. 1
  • Natural or Inner Join pt. 1
  • Natural or Inner Join pt. 1
  • Outer Join pt. 1
  • Outer Join pt. 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 pt. 1
  • Types of Grouping Functions pt. 2
  • Special Behavior pt. 1
  • Special Behavior pt. 2
  • Summary Functions
  • Statistical Functions
  • Other Functions
  • Filtering GROUP BY with the HAVING Clause
  • Extending the GROUP BY Clause pt. 1
  • Extending the GROUP BY Clause pt. 2
Subqueries and Other Advanced Queries
  • What is a Subquery?
  • Types of Subqueries
  • Comparison Conditions Revisited pt. 1
  • Comparison Conditions Revisited pt. 2
  • Comparison Conditions Revisited pt. 3
  • Regular vs. Correlated Subqueries
  • Nested Subqueries and Replacing Joins
  • Where can Subqueries be Used?
  • Hierarchical Queries
  • Set Operators and Composite Queries
Oracle’s Data Manipulation Language (DML)
  • What is DML?
  • Adding Data with INSERT
  • Multiple Table INSERT pt. 1
  • Multiple Table INSERT pt. 2
  • Changing Data with UPDATE pt. 1
  • Changing Data with UPDATE pt. 2
  • Remove Data with DELETE or TRUNCATE pt. 1
  • Remove Data with DELETE or TRUNCATE pt. 2
  • Merging Tables with MERGE pt. 1
  • Merging Tables with MERGE pt. 2
  • Transactional Control
  • Locking and Visibility of Data Changes
  • COMMIT vs ROLLBACK
PL/SQL (Programming Language SQL)
  • What is PL/SQL?
  • Modular Structure
  • Anonymous Procedures
  • Named Procedures
  • Functions
  • Packages
  • Triggers pt. 1
  • Triggers pt. 2
  • Variables and Types in PL/SQL pt. 1
  • Variables and Types in PL/SQL pt. 2
  • Objects and Object Datatypes
  • More About Objects pt. 1
  • More About Objects pt. 2
  • Programming Control Structures
  • Simple Database Access in PL/SQL
  • Cursors and Implicit Cursors pt. 1
  • Cursors and Implicit Cursors pt. 2
  • Explicit Cursors pt. 1
  • Explicit Cursors pt. 2
  • Dynamic SQL
  • Provided (DBMS_) Packages

Oracle SQL and PL / SQL Video Tutorial

Title Oracle SQL and PL / SQL Training Tutorial
Duration 12 hours
Number of Videos 165
Only $30 a month
Unlimited Access to over 600 Titles (6000+ hours )
No Minimum Term - No Contract
Instant Access - No Restrictions
Join Now

Own this Training Course on CD

Oracle SQL and PL / SQL Training CD
Would you like to own this Oracle SQL and PL / SQL Training title on CD?
You may purchase it from our online store. Because we don't have to use the same level of compression on the CDs as we do with the online, the audio and video playback is of a higher quality. For a single low payment you can buy this
Oracle SQL and PL / SQL tutorial on CD.

Multi User Accounts - Cost Effective Training

Multi User Accounts
For Educational Establishments and Corporate Customers we have the idea way to train multi users simultaneously. Just like the single user account the Multi User option gives unlimited access to all listed courses. The cost of training multiple users is significantly reduced.

Free Certification - Prove Your Skills

Free Certification
After you have completed a tutorial, a Certificate of Completion can be obtained to verify that you have taken a particular course. All certificates are FREE, but the training course must be completed before a certificate can be issued.

Related Tutorials

Customer Comments

'Your Products are the best example of computer-based training I've seen.'
Christine Maggio
Abacus Technology, Inc., NJ