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
-
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 of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.