Online Correlated Subqueries eLearning
Correlated Subqueries Training Provider? - Tell us about your Training!
From 123-CBT Computer Based Training
Oracle SQL Specifics Retrieving and Formatting Data

... a single query. Users will also learn how subqueries and correlated subqueries can help to solve data retrieval problems. Finally, participants will learn how to retrieve data based on a hierarchical relationship between rows.
L earn To:
Define relational database concepts and object relational database concepts.
Use the Oracle SELECT statement.
Implement functions,
more...
Oracle SQL Specifics Retrieving and Formatting Data
Oracle SQL and SQL Plus Advanced SELECT Statements

...e multiple-row and multiple-column subqueries.
Write correlated subqueries.
Write queries using number DECODE and character functions.
Write hierarchical queries and format hierarchical reports.
Write compound queries by using set operators and control the order of the output of the compound queries.
C ontent Emphasis
Skills-Based
A udience
Application
more...
From Serebra Learning Corporation
Subqueries and Hierarchical Queries in Oracle Database 10g
To demonstrate how to use subqueries and hierarchical queries in Oracle 10g Database administrators, application developers, and database operators
more...
Oracle SQL Specifics: Retrieving and Formatting Data
This course is the first in a two-part series on Oracle SQL Specifics that will teach participants how to use commands functions and operators supported by Oracle as extensions to standard SQL. Students will be introduced to the Oracle implementation of the relational database management system (RDBMS) and the object-relational database management system (ORDBMS). Users will learn how SQL
more...
