TERADATA 14 CERTIFICATION EXAMS OBJECTIVES

TE0-141 Teradata 14 Basics

  • Data Warehouse Architectures
  • Physically distributed architectures, non-centralized data warehouses, Teradata Active Solutions, Enterprise data model
  • Relational Database Concepts
  • Relational database terminology, pros and cons of various database logical models
  • Teradata RDBMS Components and Architecture
  • Features and benefits of Teradata technology (AMPs, PEs, BYNET) and interfaces (ODBC, JDBC), MOSI, mTDP
  • Database Managed Storage
  • Primary index (PI, NUPI, NoPI), data distribution, partitioned tables (PPI, Columnar), space (perm, spool), storage optimization techniques
  • Data Access Methods
  • Primary and secondary indexes (UPI, NUPI, No PI, USI, NUSI), partitioned tables (PPI, Columnar), join indexes, full table scans, locking
  • Data and Performance Availability Features
  • Fallback, journals, node failover, cliques, hot standby, RAID1
  • Teradata Tools and Utilities
  • Load/Unload, query tools, Teradata Analyst Pack, dual systems (Unity Ecosystem Manager, Unity Director, Unity Data Mover), ARC
  • Workload Management
  • Response time, throughput, tactical, strategic, row vs.
  • Set processing, workload management tools (TASM, TDWM, Priority Scheduler)
  • Security and Privacy
  • LDAP, single sign-on, passwords, views, macros, UDFs, row level security

 

TE0-142 Teradata 14 SQL

  • Basic Teradata Extensions
  • Data Definition Language (DDL) (Non-Temporal)
  • Data Manipulation Language (DML) (Non-temporal)
  • Views and Macros (Non-temporal)
  • Logical and Conditional Expressions
  • Data Conversions and Computations
  • CASE Expressions
  • Subqueries and Correlated Subqueries
  • Joins (Non-temporal)
  • Attribute and String Functions
  • Set Operations
  • Analytical Functions
  • Time/Date/Timestamp/Intervals (ANSI vs. Teradata) (Non temporal)
  • Aggregations
  • SQL Optimization Concepts
  • Temporal Concepts

TE0-143 Teradata 14 Physical Design and Implementation 

  • Physical Database Design Overview
  • Extending the logical data model, denormalization, primary index choices, derived data, database hierarchy (databases and users)
  • Table Attributes
  • Set tables, Multi-set tables, Queue tables, temporary tables, ALTER TABLE, CREATE TABLE, table-level options
  • Column Attributes
  • Data types, Referential Integrity, UNICODE
  • Statistics
  • Multi-column statistics, SAMPLE statistics, SUMMARY statistics, MAXINTERVAL, ROLLUP, tables and views used for statistics collection
  • Primary Indexes
  • UPI, NUPI, NoPI
  • Table Partitioning
  • PPI, MLPPI, Character PPI, NO RANGE, Column
  • Partitioning, ALTER TABLE TO CURRENT
  • Compression
  • Multi-value Compression, Block Level Compression, Algorithmic Compression, temperature-based Block Level Compression, column partitioning (compress options)
  • Secondary Indexes
  • USI, NUSI
  • Other Index Types
  • STJI, AJI, Multi-table join indexes, other join indexes (compressed, non-compressed, covering)
  • Physical Database Operations
  • Query optimization (row access, aggregation), index utilization (partial value searches, data type conversions), table joins, skewed processing
  • Teradata Query Analysis
  • E.g., EXPLAIN, DBQL, nested views, Teradata Analyst Pack, Viewpoint
  • Temporal Design Considerations
  • E.g., temporal tables (VALIDTIME, TRANSACTIONTIME, BITEMPORAL), temporal views (SEQUENCED, NONSEQUENCED, CURRENT time)

TE0-14B Teradata 14 Bridge from Teradata 12*

  • The Teradata 14 Bridge from Teradata 12 Exam allows Teradata.
  • 12 certified candidates, in good standing, to move, or “bridge”, from the Teradata 12 Certification track to the Teradata 14 Certification track without starting the track from the beginning.
  • This exam covers content from the above mentioned baseline exams (TE0-141, TE0-142, TE0-143) with a focus on changes since the release of the Teradata 12 database including: Teradata Database 13.0, Teradata Database 13.1,Teradata Database 14.0 (including SLES 11)
  • Exam Objectives Include (see above for details):
  • Data Warehouse Architectures, Teradata RDBMS
  • Components and Architecture
  • Database Managed Storage, Data Access Methods
  • Teradata Tools and Utilities, Security and Privacy
  • Basic Teradata Extensions, Data Definition Language (DDL)
  • (Non-temporal), Data Manipulation Language (DML) (Non temporal)
  • Views and Macros (Non-temporal), Subqueries and
  • Correlated Subqueries, Joins (Non-temporal)
  • Attribute and String Functions,
  • Time/Date/Timestamp/Intervals (ANSI vs. TERADATA) (Non temporal),
  • Temporal Concepts
  • Physical Database Design Overview, Physical Database
  • Operations, Teradata Query Analysis
  • Table Attributes, Column Attributes
  • Statistics
  • Primary Indexes, Secondary Indexes
  • Table Partitioning
  • Compression
  • Temporal Design Considerations

*TE0-14B is eligibility based. Only candidates in good standing holding a Teradata 12 Technical Specialist Certification or more advanced certification levels are eligible to take this exam.

  

TE0-144 Teradata 14 Database Administration

This exam is currently being developed. The Objectives will be released at a later date.

 TE0-145 Teradata 14 Solutions Development

This exam is currently being developed. The Objectives will be released at a later date.

 TE0-146 Teradata 14 Enterprise Architecture

This exam is currently being developed. The Objectives will be released at a later date.

TE0-147 Teradata 14 Comprehensive Mastery

This exam is currently being developed. The Objectives will be released at a later date.