Oracle Database 12c R2 SQL: Using Subqueries to Solve Queries Overview/Description Expected Duration Lesson Objectives Course Number Expertise Level Overview/Description Subqueries are very useful when you need to select rows from a table with a condition that depends on the data in the table itself. Explore the types, syntax, and guidelines for using subqueries in Oracle.
Expected Duration (hours)
1.4
Lesson Objectives Oracle Database 12c R2 SQL: Using Subqueries to Solve QueriesÂ
use a subquery to solve a problem in a SQL statement
using group functions and the HAVING clause in a subquery
use the IN, ANY, and ALL operators in multiple-row subqueries in a SQL statement
"use a multiple-column subquery to return more than one column to the outer query in a SQL statement "
use the EXISTS and NOT EXISTS operators
use the WITH clause
use correlated UPDATE subqueries
use correlated DELETE subqueries
use the WITH CHECK OPTION
demonstrate the use of NULL values in a subquery and use the NOT IN operator in a SQL statement
manipulate data using subqueries
Course Number: it_dfosfd_14_enus
Expertise Level
Beginner