The Teradata Certification Physical Design and Implementation Guide is designed for those who are interested in becoming a Teradata Certified Technical Specialist or higher. Through simplified examples and explanations, this guide prepares the reader to take the. Through simplified examples and explanations, this guide prepares the reader to take the Teradata Physical Design and Implementation Exam.
Extended Logical and Physical Data Models
Primary and Secondary Indexes
Multi-Level Partitioned Primary Indexes (MLPPI)
Denormalization Techniques
Join Types and Strategies
Explain Terminology
Query Analysis using DBQL and Access Logging
Locking Modifiers and Transactions
Considerations for Implementing Statistics and Compression
Database Objects, Manipulation, and Management
The Teradata 14 Certification Study Guides are the only Teradata authorized study publications. Cerulium Corporation partners with Teradata and the Teradata Certified Professional Program to author the Teradata 14 Certification Study Guides.
Teradata Certified Technical Specialist
“A successful candidate has core knowledge and skills about Teradata Structured Query Language (SQL) using both ANSI standard conventions and Teradata extensions to the language as well as the core knowledge and skills necessary to design and implement a Teradata Database from a logical data model. The candidate understands the Teradata implementation of data distribution, space usage, data access and data manipulation processes. The candidate can implement a Teradata Database using a set of requirements.”*
Teradata Certification Physical Design and Implementation ExamTEO-143 is required for:
