Learn How To Use Oracle Subqueries
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
Date: Nov 4, 2011
NOTE: Some corporate firewalls will not allow videos hosted by YouTube.