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
-
1. Using Subqueries to Solve a Problem7m 27s
-
2. Single-Row Subqueries8m 6s
-
3. Multiple-Row Subqueries9m 27s
-
4. Multiple-Column Subqueries4m 29s
-
5. EXISTS and NOT EXISTS Operators9m 47s
-
6. WITH Clause8m 48s
-
7. Correlated UPDATE8m 50s
-
8. Correlated DELETE6m 28s
-
9. WITH CHECK OPTION5m 13s
-
10. NULL Values in a Subquery6m 58s
-
11. Exercise: Manipulate Data Using Subqueries7m 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.
