Oracle SQL and PL / SQL Tutorials

Details

Highly Effective Oracle SQL and PL / SQL tutorials on video CD, learn from your own desk at a pace that suits you. Low cost high quality training at an affordable price. Works on 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 course.
Close

Oracle SQL and PL / SQL Training CD / DVD Contents
Professionally created, comprehensive training that's easy to follow at an unbelivable price.

See the quality for yourself. Try a FREE Demo.

The blue links below are Free Oracle SQL and PL / SQL Tutorial Videos.

Try for FREE - NOW
To help you evaluate this training CD / DVD the first 3 chapters are available for free, click on any of the links below for a FREE DEMO.

Read before watching the free videos
The sound quality and frame rate of free online tutorials has been reduced to allow for faster streaming. The quality on CD / DVD is far higher.
Quicktime
*QuickTime is needed to view the videos. Some titles have been converted to play via Flash.
This tutorial can also be viewed using Flash:
Click To View in Flash
Welcome  Welcome Demo
 Useful Web Sites Demo
 What is Oracle Software? Demo
 The History of Databases Demo
 The History of Oracle Demo
 About this Course Demo
The Relational Database Model  The Relational Database Model Demo
 The Concerts Schema Demo
 Normalization pt. 1 Demo
 Normalization pt. 2 Demo
 Denormalization pt. 1 Demo
 Denormalization pt. 2 Demo
Oracle SQL and PL/SQL Tools  What are the Oracle SQL and PL/SQL Tools? Demo
 SQL Plus Demo
 Formatting Output Demo
 SQL Plus Worksheet Demo
 iSQL Plus Demo
 Oracle Enterprise Manager Demo
 Oracle Enterprise Manager pt. 2 Demo
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 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 Training CD Information

Title : Oracle SQL and PL / SQL
Tutor : Gavin Powell
Other tutorials and training by this author
Movies : 165 Lessons- Video run time: 12 Hours
Availability : Immediate Dispatch
Compatibility: Vista, 98, 2000, NT, XP, Mac OS, OSX
Released 2003-03-12
Work files Yes
Price US / Canadian Sales $99.95

306 In Stock

Add to Cart

Why use this method of video training ?
  • Learn Oracle SQL and PL / SQL from an accredited expert in days.
  • Ideal for beginners, easy to follow videos that offer visual clarity.
  • Master a full application for a fraction of the cost of classroom based training.
  • Unique teaching method that offers accelerated learning and high retention.
  • Used by many large companies, schools, universities,
  • Learn from your own desk at a speed that suits you
  • Cost effective tuition from leading experts
  • You control the pace, training can be stopped, rewound or fast forwarded as required.

Associated Titles:

Free Certificate. Prove your credentials
online people


We now offer all customers a free certificate to verify they have undertaken a Oracle SQL and PL / SQL course, the unique certification number allows third parties to check the authenticity of your certificate online. After your purchase you can download your Oracle SQL and PL / SQL certificate without delay.

Online University Access all our Training for only $30.00

Not sure which training CD titles to purchase ? Why not join our Online University and have unlimited access to all our titles for one low price ?

online people

over 4000 hours of high quality online training for only $30.00. Unlimited access

learn from your own desk -expert tutorials - affordable tuition.
No minimum sign up period.
Want to see how good our online university is? - Why not try a free Demo

For low monthly fee you have unlimited access to all the 300+ training titles in our range, that's over 35,000 tutorials covering 4000 hours+! Watch when ever you like, from any computer - NO LIMITS.

Join Today and learn quicker and cheaper than you ever thought possible.

Become a expert without having to read a book or attend expensive training courses.

Where else can you find step-by-step training for over 300 software applications delivered to your own desk, from a leading expert, for less then a Dollar a day ?

Want to see how good our online university is? - Why not try a free Demo, and if all that's not enough, we add new video tutorials each month for no extra charge!

Free Newsletter

If you would like to be notified as we release new video tutorials, run special offers, or promotions.
Sign up now. Your details are kept secure and never sold rented or used by any other 3rd parties.