Performing Subqueries & Correlated Subqueries

Teradata 14    |    Beginner
  • 7 videos | 49m 3s
  • Earns a Badge
Likes 16 Likes 16
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

  • 8m 19s
    Upon 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 23s
    To find out how to perform basic subqueries in a SELECT statement in order to return results from Teradata, consult the Teradata documentation. FREE ACCESS
  • Locked
    3.  Performing Subqueries in Search Conditions
    5m 38s
    To find out how to perform subqueries in the search condition of a WHERE clause, consult a database administrator or reference manual. FREE ACCESS
  • Locked
    4.  Performing Scalar Subqueries
    5m 58s
    To find out how to return results from Teradata using scalar subqueries, consult Teradata documentation. FREE ACCESS
  • Locked
    5.  Performing Correlated Subqueries
    7m 26s
    In this video, you will learn how to perform correlated subqueries to return results from Teradata. FREE ACCESS
  • Locked
    6.  Using Derived Tables
    7m 30s
    In this video, you will learn how to create and use derived tables in Teradata. FREE ACCESS
  • Locked
    7.  Exercise: Using the SELECT Statement
    8m 49s
    In 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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 17 Likes 17  
Likes 29 Likes 29  
Likes 103 Likes 103