Working with Subqueries
Oracle 12c
| Beginner
- 11 videos | 38m 24s
- Earns a Badge
It's not uncommon to need more than one query to get to the data results you require. Learn about using subqueries to solve problems in Oracle Database 12c.
WHAT YOU WILL LEARN
-
Use a subquery to solve a problem in a sql statement
Describe the rules, guidelines, and types of subqueries used in a sql statement
Use a single-row subquery to return one row in a sql statement
Display data from a main query using a group function in a subquery to return a single row in a sql statement
Use a subquery in the having clause of a sql statement
Identify common errors that occur when an incorrect number of rows is returned by a single-row subquery in a sql statement -
Describe multiple-row subqueries in a sql statement
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
Describe null values in a subquery and use the not in operator in a sql statement
Combine two queries by making use of a subquery in a sql statement
IN THIS COURSE
-
1. Using Subquery to Solve a Problem2m 45sIn this video, you will use a subquery to solve a problem in a SQL statement. FREE ACCESS
-
2. Guidelines for Subqueries1m 46sAfter completing this video, you will be able to describe the rules, guidelines, and types of subqueries used in SQL statements. FREE ACCESS
-
3. Executing Single-row Subqueries3m 50sIn this video, you will use a single-row subquery to return one row from a SQL statement. FREE ACCESS
-
4. Using Group Functions in Subqueries3m 28sIn this video, you will learn how to display data from a main query using a group function in a subquery to return a single row in a SQL statement. FREE ACCESS
-
5. Using the HAVING clause with Subqueries2m 49sIn this video, find out how to use a subquery in the HAVING clause of an SQL statement. FREE ACCESS
-
6. Troubleshooting Inner Query4m 10sIn this video, you will learn how to identify common errors that occur when an incorrect number of rows is returned by a subquery in a SQL statement. FREE ACCESS
-
7. Multiple-row Subqueries4m 5sUpon completion of this video, you will be able to describe multiple-row subqueries in SQL statements. FREE ACCESS
-
8. ANY and ALL Operators in Multiple-row Subqueries3m 47sIn this video, you will learn how to use the IN, ANY, and ALL operators in multiple-row subqueries in a SQL statement. FREE ACCESS
-
9. Multiple-column Subqueries3m 18sIn this video, learn how to use a multiple-column subquery to return more than one column to the outer query in a SQL statement. FREE ACCESS
-
10. Null Values in Subquery2m 56sAfter completing this video, you will be able to describe NULL values in a subquery and use the NOT IN operator in a SQL statement. FREE ACCESS
-
11. Exercise: Use subqueries5m 32sIn this video, you will learn how to combine two queries by making use of a subquery in a SQL statement. FREE ACCESS
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.
