Performing Subqueries & Correlated Subqueries
Teradata 14
| Beginner
- 7 Videos | 50m 33s
- Earns a Badge
A subquery is simply a query contained within another query. Discover how to use ANSI SQL and Teradata extensions to perform subqueries and correlated subqueries in Teradata.
WHAT YOU WILL LEARN
-
describe subqueries, scalar subqueries, and correlated subqueries, and how they are used in Teradata to retrieve results
perform basic subqueries in a SELECT statement to return results from Teradata
perform subqueries in the search condition of a WHERE clause
perform scalar subqueries to return results from Teradata -
perform correlated subqueries to return results from Teradata
create and use derived tables in Teradata
use the SELECT statement to perform queries, including performing joins and subqueries
IN THIS COURSE
-
1.Overview of the Types of Subqueries8m 19sUP NEXT
-
2.Performing Subqueries in a SELECT Statement5m 23s
-
3.Performing Subqueries in Search Conditions5m 38s
-
4.Performing Scalar Subqueries5m 58s
-
5.Performing Correlated Subqueries7m 26s
-
6.Using Derived Tables7m 30s
-
7.Exercise: Using the SELECT Statement8m 49s
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.
