Description: Teradata databases use indexes to store and access rows of data from tables. Indexes speed up the performance of data retrieval for users. Teradata offers various types of indexes which can be used based on the type of data and how it is accessed by the users. To control concurrency Teradata using different locking mechanisms. This course will discuss and show how to create the various primary and secondary indexes used by Teradata, as well as discuss the different locking mechanisms and the performance availability features, such as RAID, failover, cliques, and hot standby.
Target Audience: Individuals looking to understand the features functions, and benefits of a Teradata database
Duration: 02:49
Description: As with any RDBMS the database needs to be security and accessible. Teradata is no exception and requires workstation and mainframe access to be configured using the communication methods provided by Teradata. The database also needs to be secured to ensure only authorized users can access it. This is provided through user accounts, privileges, profiles, and roles. This course will describe the workstation and mainframe attachment communication methods. It will also discuss and show how to configure security, including authorization and authentication for a database.
Target Audience: individuals looking to understand the features functions, and benefits of a Teradata database
Duration: 02:25
Description: Teradata provides a relational database system for data storage that offers various tools and utilities for management, administration, and querying. It offers a high quality system using a parallel database architecture providing a 'share nothing' architecture. This course will provide information on the basics of Teradata including what a data warehouse is along with its architecture and design, an overview of a relational database system, and the hardware and software used by Teradata for the database architecture.
Target Audience: individuals looking to understand the features functions, and benefits of a Teradata database
Duration: 01:51