Oracle Database 12c R2 SQL: Using the Set Operators

Oracle SQL 12c    |    Beginner
  • 8 videos | 40m 5s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 40 users Rating 4.6 of 40 users (40)
Discover how to write SQL queries by using set operators.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • 7m 28s
    Upon completion of this video, you will be able to describe the types of set operators and their guidelines. FREE ACCESS
  • 3m 21s
    After completing this video, you will be able to recognize how the Oracle Server manages set operators. FREE ACCESS
  • Locked
    3.  UNION and UNION ALL Operators
    8m 15s
    Find out how to use the UNION and UNION ALL operators to return all rows in a SQL statement. FREE ACCESS
  • Locked
    4.  INTERSECT Operator
    2m 32s
    In this video, you will learn how to use the INTERSECT operator to return all rows that are common to multiple queries in a SQL statement. FREE ACCESS
  • Locked
    5.  MINUS Operator
    2m 14s
    During this video, you will learn how to use the MINUS operator to return all distinct rows selected by the first query in a SQL statement. FREE ACCESS
  • Locked
    6.  Matching SELECT Statements
    7m 17s
    In this video, you will learn how the expressions in the SELECT lists of queries must match in number in a SQL statement. FREE ACCESS
  • Locked
    7.  Using the ORDER BY Clause in Set Operations
    4m 10s
    Learn how to use the ORDER BY clause in set operations in SQL statements. FREE ACCESS
  • Locked
    8.  Exercise: Combine Multiple Queries
    4m 48s
    In this video, find out how to use set operators to combine the results of multiple queries. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Journey How to Transform Tables with SQL
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Course Oracle Database 12c R2 SQL: Restricting & Sorting Data
Rating 4.5 of 37 users Rating 4.5 of 37 users (37)
Channel Oracle RAC

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Oracle Database 12c R2 SQL: Using Basic SELECT statements
Rating 4.7 of 88 users Rating 4.7 of 88 users (88)
Course Oracle Database 12c R2 SQL: SQL*Plus
Rating 4.6 of 63 users Rating 4.6 of 63 users (63)
Course Oracle Database 12c R2 SQL: Creating Other Schema Objects
Rating 4.4 of 48 users Rating 4.4 of 48 users (48)