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

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