Performing Subqueries & Correlated Subqueries
Teradata 14
| Beginner
- 7 videos | 49m 3s
- 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 resultsPerform basic subqueries in a select statement to return results from teradataPerform subqueries in the search condition of a where clausePerform scalar subqueries to return results from teradata
-
Perform correlated subqueries to return results from teradataCreate and use derived tables in teradataUse the select statement to perform queries, including performing joins and subqueries
IN THIS COURSE
-
8m 19sUpon completion of this video, you will be able to describe subqueries, scalar subqueries, and correlated subqueries, and how they are used in Teradata to retrieve results. FREE ACCESS
-
5m 23sTo find out how to perform basic subqueries in a SELECT statement in order to return results from Teradata, consult the Teradata documentation. FREE ACCESS
-
5m 38sTo find out how to perform subqueries in the search condition of a WHERE clause, consult a database administrator or reference manual. FREE ACCESS
-
5m 58sTo find out how to return results from Teradata using scalar subqueries, consult Teradata documentation. FREE ACCESS
-
7m 26sIn this video, you will learn how to perform correlated subqueries to return results from Teradata. FREE ACCESS
-
7m 30sIn this video, you will learn how to create and use derived tables in Teradata. FREE ACCESS
-
8m 49sIn this video, you will learn how to use the SELECT statement to perform queries, including performing joins and subqueries. 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.