The Teradata Certification SQL Guide is designed for those who are interested becoming Teradata Certified Technical Specialists or higher. Through simplified examples and explanations, this guide prepares the reader to take the Teradata SQL Exam.
Identify the correct use of SQL comparison operators
HELP, SHOW, and EXPLAIN commands and their expected outputs
Explain how data type conversions work
Identify uses involving GROUP BY, HAVING, and DISTINCT
Proper usage of Joins, Scalar and Non-Scalar Subqueries and Correlated Subqueries
Correct usage of date intervals, and extractions
Describe the functionality of Ordered Analytic Functions (OLAP)
DML, DDL, and DCL SQL statements
Considerations for CREATE tables including PPI, MLPPI, Indexing, and Temporal
Describe the types and uses of Stored Procedure parameters and variables
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 Exam TEO-142 is required for:
