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

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

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

BOOK Querying MySQL: Make your MySQL Database Analytics Accessible with SQL Operations, Data extraction, and Custom Queries
CHANNEL Oracle RAC
Likes 40 Likes 40  
COURSE Oracle Database 12c R2 SQL: Displaying Data from Multiple Tables
Likes 32 Likes 32  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
Likes 165 Likes 165  
COURSE Oracle Database 12c R2 SQL: Using Single-Row Functions to Customize Output
Likes 33 Likes 33  
COURSE Oracle Database 12c R2 SQL: Using Basic SELECT statements
Likes 72 Likes 72