Working with Subqueries

Oracle 12c    |    Beginner
  • 11 videos | 38m 24s
  • Earns a Badge
Likes 212 Likes 212
It's not uncommon to need more than one query to get to the data results you require. Learn about using subqueries to solve problems in Oracle Database 12c.

WHAT YOU WILL LEARN

  • use a subquery to solve a problem in a SQL statement
    describe the rules, guidelines, and types of subqueries used in a SQL statement
    use a single-row subquery to return one row in a SQL statement
    display data from a main query using a group function in a subquery to return a single row in a SQL statement
    use a subquery in the HAVING clause of a SQL statement
    identify common errors that occur when an incorrect number of rows is returned by a single-row subquery in a SQL statement
  • describe multiple-row subqueries in a SQL statement
    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
    describe NULL values in a subquery and use the NOT IN operator in a SQL statement
    combine two queries by making use of a subquery  in a SQL statement

IN THIS COURSE

  • Locked
    1.  Using Subquery to Solve a Problem
    2m 45s
    In this video, you will use a subquery to solve a problem in a SQL statement. FREE ACCESS
  • Locked
    2.  Guidelines for Subqueries
    1m 46s
    After completing this video, you will be able to describe the rules, guidelines, and types of subqueries used in SQL statements. FREE ACCESS
  • Locked
    3.  Executing Single-row Subqueries
    3m 50s
    In this video, you will use a single-row subquery to return one row from a SQL statement. FREE ACCESS
  • Locked
    4.  Using Group Functions in Subqueries
    3m 28s
    In this video, you will learn how to display data from a main query using a group function in a subquery to return a single row in a SQL statement. FREE ACCESS
  • Locked
    5.  Using the HAVING clause with Subqueries
    2m 49s
    In this video, find out how to use a subquery in the HAVING clause of an SQL statement. FREE ACCESS
  • Locked
    6.  Troubleshooting Inner Query
    4m 10s
    In this video, you will learn how to identify common errors that occur when an incorrect number of rows is returned by a subquery in a SQL statement. FREE ACCESS
  • Locked
    7.  Multiple-row Subqueries
    4m 5s
    Upon completion of this video, you will be able to describe multiple-row subqueries in SQL statements. FREE ACCESS
  • Locked
    8.  ANY and ALL Operators in Multiple-row Subqueries
    3m 47s
    In this video, you will learn how to use the IN, ANY, and ALL operators in multiple-row subqueries in a SQL statement. FREE ACCESS
  • Locked
    9.  Multiple-column Subqueries
    3m 18s
    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
    10.  Null Values in Subquery
    2m 56s
    After completing this video, you will be able to describe NULL values in a subquery and use the NOT IN operator in a SQL statement. FREE ACCESS
  • Locked
    11.  Exercise: Use subqueries
    5m 32s
    In this video, you will learn how to combine two queries by making use of a subquery in a SQL statement. 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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 617 Likes 617  
Likes 291 Likes 291  
Likes 57 Likes 57