SkillBuilders Welcome  |  Log in
All Oracle Tutorials

Learn How To Use Oracle Subqueries

Oracle Consultants Available

SQL is a language that allows you to perform queries to answer a wide range of questions about your data.  Subqueries provide powerful solutions to support a host of complex queries.

In this free online training video Geoff teaches you how Oracle Database supports a wide range of subquery capabilities including:
* Simple Subqueries
* Correlated Subqueries
* Top-N Queries
*  Subqueries in the WHERE clause, subqueries in the FROM clause, subqueries in the SELECT clause . . . subqueries everywhere!

We will also discuss subquery “gotchas” and how to avoid them, subquery best practices, subqueries vs joins, and how and why to use Subquery Factoring.

Your instructor, Geoff Wiland, has more than 25 years of hands-on experience in the I.T. industry.  His last 10 years have been spent working with Oracle. 

Be sure to view our calendar of instructor-led online Oracle classes

Duration: 34 minutes

Dec 12 - SkillBuilders Oracle 11g PL/SQL Programming Workshop

Date: Nov 4, 2011

View video now - Free Online Registration required