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 statementusing group functions and the HAVING clause in a subqueryuse 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 operatorsuse the WITH clause
use correlated UPDATE subqueriesuse correlated DELETE subqueriesuse the WITH CHECK OPTIONdemonstrate the use of NULL values in a subquery and use the NOT IN operator in a SQL statementmanipulate 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 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
PEOPLE WHO VIEWED THIS ALSO VIEWED THESE
Course SQL Concepts & Queries