Performing Subqueries & Correlated Subqueries

Teradata 14    |    Beginner
  • 7 Videos | 50m 33s
  • Earns a Badge
Likes 13 Likes 13
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

  • Playable
    1. 
    Overview of the Types of Subqueries
    8m 19s
    UP NEXT
  • Playable
    2. 
    Performing Subqueries in a SELECT Statement
    5m 23s
  • Locked
    3. 
    Performing Subqueries in Search Conditions
    5m 38s
  • Locked
    4. 
    Performing Scalar Subqueries
    5m 58s
  • Locked
    5. 
    Performing Correlated Subqueries
    7m 26s
  • Locked
    6. 
    Using Derived Tables
    7m 30s
  • Locked
    7. 
    Exercise: Using the SELECT Statement
    8m 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.

YOU MIGHT ALSO LIKE

Likes 14 Likes 14  
Likes 31 Likes 31  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 9 Likes 9