09 November 2010

Teradata Basics Te0-121 - Refined objectives from Developer Forum

Hi all,

I was confused to see the objectives listed in the Teradata preperation site, But found that the objectives at the following link is a good place to kick start preparing for Teradata certifications.

The below is an extract from the following link
http://developer.teradata.com/database/training/introduction-to-the-teradata-database

Teradata Basics - TE0-121


Topics

  • The purpose of the Teradata Database
  • Definition of terms (such as Table, Column, Row, Domain, Primary Key and Foreign Key) associated with Relational Databases
  • Differences between the Data Warehouse and the different types of Data Marts
  • The five stages of Data Warehouse evolution
  • Architecture and components (such as Node, VPROC, PE, BYNET and AMP) of the Teradata Database and how the Teradata Database uses parallelism to achieve its high performance
  • The types of Database Objects (such as Database, User, Table, View and Macro) that may be defined in the Teradata Database
  • The purpose of the tools (such as BTEQ, SQL Assistant, FastLoad, Teradata Manager and Teradata Dynamic Workload Manager) available to support the Teradata Database
  • The purpose of Permanent Space, Temporary Space and Spool Space in the Teradata Database
  • How the Teradata Database uses the Primary Index of a table to distribute and store the rows of a table
  • How the Teradata Database uses the optional Secondary Index of a table to improve data access performance
  • Methods of data protection and types of fault tolerance built into the Teradata Database (such as Clique, Cluster, Fallback Table, Transient Journal and Permanent Journal)