Description: Teradata supports the use of SQLs data definition language to create and manage objects within the database. It also supports the use of SQLs data manipulation language to query and perform operations on the data. Teradata supports the use of temporal tables as well and contains temporal forms of DDL and DML for use within a temporal database. This course will demonstrate and describe performing DDL and DML operations within a database and temporal database.
Target Audience: Individuals looking to learn SQL basics to query Teradata databases
Duration: 02:51
Description: Teradata supports the use of functions, expressions, and operators to perform operations on data. It generally takes an argument or expression and performs an action for an output. This course will demonstrate the different types of functions used in Teradata, including attribute, string, and analytical functions. It will also demonstrate how to perform data conversions and computations, use SET operations, and work with times, dates, timestamps, and intervals.
Target Audience: Individuals looking to learn SQL basics to query Teradata databases
Duration: 02:31
Description: Teradata supports the use of ANSI SQL to query data housed within the database system. Along with ANSI SQL, it also supports Teradata extensions that can be used. This course will demonstrate how to use the SELECT statement to perform queries, along with performing joins, subqueries, and correlated subqueries.
Target Audience: individuals looking to learn SQL basics to query Teradata databases
Duration: 03:25