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

Oracle SQL 12c    |    Beginner
  • 11 videos | 1h 22m 46s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 39 users Rating 4.6 of 39 users (39)
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • 7m 27s
    In this video, you will learn how to use a subquery to solve a problem in a SQL statement. FREE ACCESS
  • 8m 6s
    In this video, you will learn how to use group functions and the HAVING clause in a subquery. FREE ACCESS
  • Locked
    3.  Multiple-Row Subqueries
    9m 27s
    In this video, learn how to use the IN, ANY, and ALL operators in multiple-row subqueries in a SQL statement. FREE ACCESS
  • Locked
    4.  Multiple-Column Subqueries
    4m 29s
    In this video, learn how to use a multiple-column subquery to return more than one column to the outer query in a SQL statement. FREE ACCESS
  • Locked
    5.  EXISTS and NOT EXISTS Operators
    9m 47s
    In this video, find out how to use the EXISTS and NOT EXISTS operators. FREE ACCESS
  • Locked
    6.  WITH Clause
    8m 48s
    In this video, learn how to use the WITH clause correctly. FREE ACCESS
  • Locked
    7.  Correlated UPDATE
    8m 50s
    Learn how to use UPDATE subqueries that are correlated. FREE ACCESS
  • Locked
    8.  Correlated DELETE
    6m 28s
    In this video, you will use subqueries that are correlated with DELETE statements. FREE ACCESS
  • Locked
    9.  WITH CHECK OPTION
    5m 13s
    In this video, you will use the WITH CHECK OPTION. FREE ACCESS
  • Locked
    10.  NULL Values in a Subquery
    6m 58s
    In this video, you will learn how to use NULL values in a subquery and use the NOT IN operator in a SQL statement. FREE ACCESS
  • Locked
    11.  Exercise: Manipulate Data Using Subqueries
    7m 14s
    In this video, find out how to use subqueries to manipulate data. 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

Course Oracle Database 12c R2 SQL: Using Basic SELECT statements
Rating 4.7 of 88 users Rating 4.7 of 88 users (88)
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: Data Manipulation Language & Transaction Control Language
Rating 4.6 of 76 users Rating 4.6 of 76 users (76)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Oracle Database 12c R2 SQL: Restricting & Sorting Data
Rating 4.5 of 37 users Rating 4.5 of 37 users (37)
Course Oracle Database 12c R2 SQL: Manipulating Data Using Advanced Queries
Rating 4.4 of 33 users Rating 4.4 of 33 users (33)
Course Oracle Database 12c R2 SQL: Creating Other Schema Objects
Rating 4.4 of 48 users Rating 4.4 of 48 users (48)