Teradata 14

Teradata 14 SQL

About the exam

Covers the Features and Functionality of the Teradata Database 13.0, 13.10, and 14.0 (including SLES 11)

This exam will certify that candidate has core knowledge and skills about Teradata Structured Query Language (SQL) using both ANSI standard conventions and Teradata extensions to the language.

  • EXAM DETAILS
  • EXAM OBJECTIVES
  • EXAM PREP
RECOMMENDED EXPERIENCE

Minimum of 12 months experience working with Teradata technology is recommended.

PREREQUISITES

Teradata 14 Basics Exam (TE0-141) is a prerequisite for this exam. To upgrade from Teradata 12, a Teradata 12 Technical Specialist Certification is required.

DURATION

This exam allows 1.75 hours for answering exam questions. The Test Delivery Provider may add time to your total appointment to provide the opportunity to get seated, read the Non-Disclosure Agreement (NDA), complete the tutorial (if applicable), and participate in a survey post-exam.

CREDENTIALS

A certification is not awarded for passing the SQL exam. The SQL exam is a requirement of the Certified Technical Specialist Certification. 

COST

The cost of Teradata exams varies by exam, location, and currency. Please visit home.pearsonvue.com/teradata to find the price of an exam. Teradata Employees can visit the TCPP Connections Group to obtain an employee voucher. You must be behind the Teradata firewall to access this page.

For more details regarding specific exam objectives, download this PDF.

BASIC TERADATA EXTENSIONS

Describe usage of HELP, SHOW, and EXPLAIN commands and their expected outputs. List the differences between ANSI and Teradata modes in the areas of transaction protocol, defaults, conversions, and table creation. Describe usage of built-in Teradata key words (e.g., CURRENT_DATE).

DATA DEFINITION LANGUAGE (DDL) (NON-TEMPORAL)

Given a CREATE TABLE statement without a primary index declared, identify the column that Teradata will select as the primary index. Describe the attributes and constraints for a column in a table. Given a scenario, identify considerations using a CREATE TABLE AS definition. Given a scenario, identify the type of table that should be used (global temporary, volatile, and permanent).

DATA MANIPULATION LANGUAGE (DML) (NON-TEMPORAL)

Identify a correctly written INSERT statement, UPDATE statement, DELETE statement, SELECT statement, and MERGE INTO statement.

VIEWS AND MACROS (NON-TEMPORAL)

Identify uses of simple and parameterized macros. Identify the benefits of using views and macros. Identify the restrictions of creating views and macros. Describe the impact of using an access lock in a view or macro.

LOGICAL AND CONDITIONAL EXPRESSIONS

Identify the correct use of comparison operators in logical expressions. Evaluate expressions involving NULLs. Identify the correct use of multiple logical expressions in a conditional expression using AND, OR, NOT. Identify the correct use of the IN, NOT IN logical predicate.

DATA CONVERSIONS AND COMPUTATIONS

Given a scenario, identify the ramifications of implicit and explicit conversions from one data type to another. Given a scenario using CAST, identify the proper result. Identify the characteristics of ANSI CAST and Teradata extensions for data conversion.

CASE EXPRESSIONS

Given a scenario, identify the result of the CASE expression. Given a scenario, identify the use of different forms (searched and valued) of the CASE expression. Given a scenario, identify the use of specialized functions (COALESCE, NULLIF) of the CASE expression.

SUBQUERIES AND CORRELATED SUBQUERIES

Given a scenario, identify the SQL statement for a correlated subquery to qualify a subset of data. Given a scenario, identify the SQL statement for a noncorrelated subquery to qualify a subset of data. Given a scenario, identify the SQL statement for a correlated scalar subquery to qualify a subset of data. Given a scenario, identify the SQL statement for a noncorrelated scalar subquery to qualify a subset of data. Identify the characteristics of a scalar subquery.

JOINS (NON-TEMPORAL)

Given a scenario, determine the type of join to code to get the desired result set. Identify proper and improper use of aliasing in table joins. Given a scenario, identify the evaluation order of various join types. Given a scenario, identify the use of a derived table using single or multiple WITH form. Given a scenario, identify the use of a derived table using the FROM clause form. Given a scenario, identify the use of a derived table using a recursive WITH form. Identify the characteristics of outer joins. 

ATTRIBUTE AND STRING FUNCTIONS

Identify the attribute functions and identify how they work within SQL. Identify the correct use of string manipulation functions and attributes. Identify formatting options for internationalization of various data types. Identify the correct use of new embedded services functions.

RECOMMENDED COURSES

The SQL exam also covers Temporal topics. You may wish to review additional courses that include this information.
•    Teradata SQL
•    Advanced Teradata SQL

The Teradata Certified Professional Program partners with the Teradata Education Network to provide Teradata courseware and curriculum that specifically relates to each certification level. You can view course descriptions and schedules, and enroll online. Several courses are offered as web-based training (WBT) courseware for your convenience.

Teradata Employees only: visit the Teradata internal TCPP Connections site for more information on recommended Teradata training. (You must be logged in to the Teradata network).
 

SAMPLE QUESTIONS

Sample questions provide an example of the format and types of questions on the actual Teradata Certification exams. The practice questions are not intended to duplicate items on the actual exams. Questions are rotated and will be slightly different each time.

The sample questions are offered online free of charge and are not “scored” or tracked. Practice at your own pace and as often as you want.

Access Teradata 14 Sample Questions

DOCUMENTATION AND DOWNLOADS

Documentation: Search and access Teradata installation, programming, operations and service guides, and reference manuals.

Software Downloads: are available through Teradata Developers Exchange to help you prepare through hands on application.

  • POLICIES

Exam Administration Policies

Before registering for the exam, familiarize yourself with retaking an exam, recertification of an exam, and the order required for the Teradata 14 Certification Track. 

View Policies

Security and Privacy Policies

We take your security and privacy very seriously. Learn more about how we’re actively ensuring TCPP integrity and what Teradata considers to be a violation.

View Policies

  • Exam Administration Policies
  • Security and Privacy Policies

REGISTRATION INFORMATION

Register for the Teradata 14 SQL Exam

To get registered for the Teradata Database Associate Exam, visit home.pearsonvue.com/teradata and select exam TEO-142.
For a list of regional phone numbers visit home.pearsonvue.com/teradata/contact/.

bypass this exam

Already Certified in Teradata 12?

Teradata 12 Technical Specialist, Database Administrator, Solution Developer, Enterprise Architect and Master certification holders can bypass the Basics, SQL, and Physical Design and Implementation Exam to take the Teradata 14 Bridge from Teradata 12 Exam (TE0-14B). Certifications are not awarded for an exam that is bypassed.