Performing Subqueries & Correlated Subqueries

Teradata 14    |    Beginner
  • 7 videos | 49m 3s
  • Earns a Badge
Rating 4.4 of 7 users Rating 4.4 of 7 users (7)
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.

YOU MIGHT ALSO LIKE

Course Introduction to SQL Bootcamp: Session 4 Replay
Rating 4.5 of 151 users Rating 4.5 of 151 users (151)
Book Querying SQL Server: Run T-SQL Operations, Data Extraction, Data Manipulation, and Custom Queries to Deliver Simplified Analytics
Channel Data Analytics

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Working with Functions, Times, Dates, & Intervals
Rating 4.4 of 31 users Rating 4.4 of 31 users (31)
Course Subqueries & the EXISTS Predicate
Rating 4.7 of 53 users Rating 4.7 of 53 users (53)
Course Data Warehouse Essential: Concepts
Rating 4.4 of 283 users Rating 4.4 of 283 users (283)