Font size:

Description:

This is a bundled training package. It contains training for each of the bundled items below:

Course Price
Teradata SQL: Functions, Data Conversions, and Working with Time $74.95
Teradata SQL: The SELECT Statement, Joins, and Subqueries $74.95
Teradata SQL: DDL, DML, and SQL Optimization $74.95

Bundle Price: $139.00
Total Savings: $85.85


Teradata SQL: Functions, Data Conversions, and Working with Time

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.
  • start the course
  • identify the different types of functions in Teradata and how expressions and SQL operators are used
  • use arithmetic functions and operators on data in Teradata
  • use attribute functions to return descriptive information about their operand in Teradata
  • use string functions to perform operations on strings of data in Teradata
  • use regular expression functions on data in Teradata
  • use the analytical functions in Teradata
  • use CASE expressions to evaluate a set of expressions in Teradata
  • use calendar functions to work with dates, months, and years in Teradata
  • use ANSI DateTime expressions to do computations with Time Zones and interval values in Teradata
  • use ANSI Interval expressions to perform calculations on Interval values in Teradata
  • use arithmetic operators, ANSI DateTime, and Interval Data Types in Teradata
  • use scalar operations with DateTime functions to work with dates and times in Teradata
  • use the different DateTime and Interval functions, ADD_MONTHS, OADD_MONTHS, AND MONTHS_BETWEEN in Teradata
  • use the different DateTime and Interval functions, LAST_DAY, NEXT_DAY, TRUNC, ROUND, EXTRACT in Teradata
  • identify the three ways data types are converted in Teradata
  • identify when implicit data conversion is performed and what the supported data types are
  • identify the syntax and rules for using CAST to perform data conversions in Teradata
  • use data type conversion functions to convert characters in Teradata with CAST
  • use data type conversion to convert numbers, times, and intervals in Teradata with CAST
  • identify and use the data type conversion functions to convert data in Teradata
  • describe the set operators, their syntax, and order precedence for use in Teradata
  • use the INTERSECT set operator in Teradata
  • use the MINUS and EXCEPT set operators in Teradata
  • use the UNION set operator in Teradata
  • use set operators in derived tables, subqueries, and SELECT...INSERT statements in Teradata
  • use functions, expressions, and operations in Teradata to work with data

Teradata SQL: The SELECT Statement, Joins, and Subqueries

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.
  • start the course
  • describe SQL and how it can be used in Teradata
  • launch and use the BTEQ command line tool and identify how it is used as a query management tool
  • describe the different clauses in a SELECT statement
  • perform basic SELECT statements in Teradata
  • use basic WHERE clause in a SELECT statement to perform conditional queries in Teradata
  • perform advanced WHERE clause searches in a SELECT statement to limit results in Teradata
  • use the ORDER BY clause in a SELECT statement to perform a query in Teradata
  • use the GROUP BY and HAVING clauses to perform grouping in query results in Teradata
  • use TOP, SAMPLE, and the SAMPLEID expression in a SELECT statement to limit results in Teradata
  • use MIN, MAX, COUNT, AVG, SUM aggregates in a SELECT statement in Teradata
  • use GROUPING SETS, ROLLUP, and CUBE to analyze data across a dimension in Teradata
  • use the WITH clause in a SELECT statement in Teradata
  • describe the different types of joins that can be performed in Teradata
  • perform natural joins in Teradata
  • perform theta joins in Teradata
  • perform inner joins in Teradata
  • perform outer joins in Teradata
  • perform self joins and cross joins in Teradata
  • perform multitable joins in Teradata
  • 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

Teradata SQL: DDL, DML, and SQL Optimization

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.
  • start the course
  • create and alter a database in Teradata
  • create and manage database users for Teradata
  • create a table in Teradata using the CREATE TABLE statement
  • create a table in Teradata using the CREATE TABLE statement which includes defining an index, column definitions, and table options
  • alter, manage, and drop tables in Teradata
  • create and alter indexes in Teradata
  • create and alter views in Teradata
  • create recursive views in Teradata
  • create macros in Teradata
  • create triggers in Teradata
  • create procedures in Teradata
  • alter, rename, and drop functions and stored procedures in Teradata
  • use the QUALIFY clause in Teradata
  • use NORMALIZED in a SELECT statement in Teradata
  • use the EXPAND ON clause in a SELECT statement in Teradata
  • use the INSERT statement to insert data into Teradata
  • use the UPDATE statement to update data in Teradata
  • use the DELETE statement to remove data from Teradata
  • use MERGE to merge data into a table in Teradata
  • identify how to optimize query design in Teradata
  • identify how to improve the performance of merge joins in Teradata
  • describe the basic temporal concepts in Teradata
  • create temporal tables in Teradata
  • load data into temporal tables in Teradata
  • perform DDL operations using their temporal form in Teradata
  • perform DML operations using their temporal form in Teradata
  • perform DDL and DML operations on regular and temporal tables in Teradata
Register Now
Teradata SQL e-learning bundle
  • Course ID:
    271530
  • Duration:
    n/a
  • Price:
    $139