• Online, Self-Paced
Course Description

Discover how to write SQL queries by using set operators.

Learning Objectives

Oracle Database 12c R2 SQL: Using the Set Operators

  • describe the types of set operators and their associated guidelines
  • recognize how the Oracle Server manages set operators
  • use UNION and UNION ALL operators to return all rows in a SQL statement
  • use the INTERSECT operator to return all rows that are common to multiple queries in a SQL statement
  • use the MINUS operator to return all distinct rows selected by the first query in a SQL statement
  • demonstrate how the expressions in the SELECT lists of queries must match in number in a SQL statement
  • use the ORDER BY clause in set operations in a SQL statement
  • use set operators to combine the results of multiple queries

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