• Online, Self-Paced
Course 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.

Learning 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

 

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Systems Administration