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
-
7m 27s
-
8m 6s
-
9m 27s
-
4m 29s
-
9m 47s
-
8m 48s
-
8m 50s
-
6m 28s
-
5m 13s
-
6m 58s
-
7m 14s
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.