Course details

Oracle Database 12c R2 SQL: Using Subqueries to Solve Queries 

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