Teradata

Technologies: Teradata 14
As with any RDBMS, the database needs to be secured to ensure only authorized users can access it. Discover workstation and mainframe attachment communication methods and how to configure users, profiles, and roles.
Teradata offers various types of indexes which can be used based on the type of data and how it is accessed by the users. Discover how to create the secondary and join indexes used by Teradata.
Teradata offers a high quality system using a parallel database architecture providing a "share nothing" architecture. Explore a relational database system and the hardware and software used by Teradata for the database architecture.
As with any RDBMS, the database needs to be secured to ensure only authorized users can access it. Discover how to configure security, including logging on, views, macros, and UDFs.
Teradata provides a relational database system that offers various tools and utilities for management, administration, and querying. Explore the basics of Teradata including what a data warehouse is along with its architecture and design.
Teradata databases use indexes to store and access rows of data from tables. Discover how to create the various primary and partitioned indexes used by Teradata.
To control concurrency, Teradata uses different locking mechanisms. Discover the different locking mechanisms and performance availability features, such as RAID, failover, cliques, and hot standby.
As with any RDBMS the database needs to be secure and accessible. Teradata is no exception and requires workstation and mainframe access. Explore the workstation and mainframe attachment communication methods.
Teradata supports the use of SQLs data manipulation language (DML) to retrieve, insert, update, and delete data in a database. Explore DDL and DML operations in a database or temporal tables.
Teradata supports the use of SQLs data definition language (DDL) to create, modify, and remove objects in a database. Work with DDL to create and alter databases, tables, indexes, triggers, and more.
You can use functions, expressions, and operators to perform operations on data in Teradata. Learn how to perform data conversions and computations, and use SET operators.
Teradata supports the use of functions, expressions, and operators to perform operations on data. Explore attribute, string, and analytical functions, as well as times, dates, and intervals in Teradata.
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.
Introduce yourself to joins in Teradata! Discover how to use ANSI SQL and Teradata extensions to perform a number of different joins, including inner, outer, self, and cross joins.
Learn how to work with clauses, operators, expressions, and aggregates in Teradata using ANSI SQL and Teradata extensions.
Teradata supports the use of ANSI SQL to query data housed in a database system, and with ANSI SQL, it supports Teradata extensions. Discover how to use the SELECT statement to perform queries.