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

Oracle SQL Tutorial

A professionally created, self-study video training course
Includes 10 hours of easy to follow Oracle 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 SQL tutorial videos by clicking a blue link below:
  • Tutor: Steve Perry
  • Duration: 10 hours
  • Video lessons: 111
  • Product code: 01971
  • In stock: YES
  • Available on: Digital Download
  • Work files included: YES
  • Works on: MS Windows PC & Mac
  • Associated Course: Beginners SQL tutorial
Learn exactly how to use Oracle SQL as your number one productivity tool for development with the help of these Oracle SQL tutorial videos

Commencing with the absolute basics, expert database trainer Steve Perry uses step by step training videos that help explain and demonstrate everyting you need to know about this innovative graphical user interface.

Through almost every step of the training, Steve uses and refers to Oracle code files that are included with the DVD and download purchases. This makes it very easy for you to keep pace with his on-screen actions and verbal instruction.
Through over nine hours of professionally created video training, the course starts with the basic concepts that include the SQL select statement, how to retrieve data from a table, the steps involved in sorting results using column names and using mathematical expressions.
Once the fundamental concepts have been covered, Steve moves onto joining tables, how to summarize data and also restricting data.
You will also learn all about using subqueries, various data modeling techniques, common methods for manipulating data, using views and so much more

The complete training course comprising of 111 individual training lessons are listed towards the left of the page and you can start your Oracle SQL education right away. Click any of the blue links to sample free video tutorials and discover how effective this practical teaching guide is...
What Our Customers Are Saying

"We have purchased 11 of these training CDs to date. Their structure and content have improved our technical skills at our own pace. We've extracted ourselves from many a production problem by referring back to the relevant CD."Ian Walsh, Slide FX Ltd, Ireland
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
Restricting Data - The Basics
What Is A Primary Key?
Comparison Operators
Logical Operators
Dealing With Null Values
Sorting The Results Using Column Position
Assignment 3
Assignment 3 - Solution

Joining Tables - The Basics
What Is A Foreign Key?
Inner Joins With The Using Clause
Joins With The On Clause
Joins And The Order Of Processing
Assignment 4
Assignment 4 - Solution

Summarizing Data
Aggregate Functions
The Count Functions
The Min And Max Functions
The Avg And Sum Functions
Concatenating Data
Aggregates - Order Of Processing
Assignment 5
Assignment 5 - Solution

Joining Multiple Tables
Many-To-Many Relationships - Lesson 1
Many-To-Many Relationships - Lesson 2
Join Multiple Tables With The Using Clause
Join Multiple Tables With The On Clause
Eliminating Duplicate Rows From The Results
Sorting The Results Using Column Aliases
Assignment 6
Assignment 6 - Solution

Data Subsets
Using The Group By Clause
Using The Having Clause
Having With Compound Conditions
Assignment 7
Assignment 7 - Solution

Restricting Data - Advanced Concepts
Using The In Operator
Using The Between Operator
Using The Like Operator For Pattern Matching
Outer Joins
Assignment 8
Assignment 8 - Solution

Using Subqueries - The Basics
How Do Subqueries Work?
Subqueries With The In Operator
Subqueries Using A Comparison Operator
Subqueries VsJoins
Using A Subquery VsA Self-Join
Assignment 9
Assignment 9 - Solution

Data Modeling - The Basics
How Data Is Organized In A Relational Database
The Entity-Relationship Approach
Normalization Guidelines - Lesson 1
Normalization Guidelines - Lesson 2
Assignment 10
Assignment 10 - Solution

Creating Tables And Manipulating Data
Creating Tables - Lesson 1
Creating Tables - Lesson 2
Specifying Keys
The Check Constraint
Creating Indexes
Modifying And Removing Tables
More Constraints
Adding Data To A Table
Changing Data In A Table - Lesson 1
Changing Data In A Table - Lesson 2
Removing Data From A Table
Assignment 11
Assignment 11 - Solution

Single-Row Functions
String Functions - Lesson 1
String Functions - Lesson 2
Number Functions
Date Functions
Limiting Rows And The Dual Table
Assignment 12
Assignment 12 - Solution

Creating And Using Views
Creating And Using Views
Set Operators
Assignment 13
Assignment 13 - Solution

Database Management
Transaction Management
Concurrency Control
Security Considerations
Stored Procedures And Triggers
Database Integrity
Assignment 14
Assignment 14 - Solution

Legacy SQL Techniques
Implicit Joins
Subqueries With Modifiers
Subqueries Using The Exists Clause
Assignment 15
Assignment 15 - Solution

Conclusion
Difference Between Oracle And Other SQLs
SQL In A Programming Language
Embedded SQL
What Is Next?
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 111 Oracle SQL training videos (listed left), lasting a total of 10 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 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 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 PL/SQL 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 SQL. Show your boss or potential employer!
Weekly Special
Promoted Course
View sample videos from the new
AutoCAD 2016
A recent customer speaks out...
"I have been recently been using your Photoshop training to demonstrate techniques to my students. I've been trying to persuade them to purchase it themselves, as I believe it to be an excellent training tool, and the best instructional CD on this subject to date by far! Not only is it easy to follow and presented clearly, but it is also a bargain."Joe Doyle Vista Community College, Berkeley, CA