Teradata Database

Developer Exam

About the exam

Covers the features and functionality of the Teradata Database through release 16.20.


A successful candidate has the knowledge and skills necessary to design and write optimized SQL that acquires, integrates and accesses data in Teradata environments. They have knowledge of database design concepts and indexing strategies for query and ETL development. Successful candidates can effectively use the Teradata database features, tools and utilities.

REGISTRATION INFORMATION

Register for the Certified Developer Exam

Developer Beta exam results will be available by March 31, 2019.

Registration for the Developer Exam opens on March 4, 2019.

Bypass this exam

Already Certified in Teradata 14?

Candidates who hold Teradata 14 Technical Specialist, Solutions DeveloperEnterprise Architect, Database Administrator, and Master certifications can bypass the Associate and Developer Exam and take the next track progression exam—Advanced Developer.

  • exam details
  • exam objectives
  • Exam Prep
RECOMMENDED EXPERIENCE 

It is recommended that candidates have approximately one (1) year of Teradata Database experience.

PREREQUISITES

Passing the Associate Exam is the prerequisite for the Developer Exam. All requirements must be met for a certification to be awarded.

CREDENTIALS

Successful completion of this exam will earn you a Teradata Database Certified Developer Certification with a Digital Badge once all certification requirements are met.

duration

To be determined.

RECERTIFICATION REQUIREMENTS

Developer certification expires in three years. Pass the same exam to maintain this certification or earn the Teradata Database Advanced Developer certification. Earning the Developer certification extends the Teradata Database Associate certification's expiration date.

COST

The cost of Teradata exams varies by exam, location and currency. Please visit Pearson Vue to find the price of an exam. Bulk discount vouchers for 10 or more exams can be purchased through Pearson Vue.

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

BASIC SQL CONCEPTS – 40%

Candidates should understand basic SQL concepts including syntax, characteristics of macros, stored procedures, permanent tables, table level attributes, CREATE TABLE AS, referential integrity, indexes, views, triggers, temporary tables, regular expressions, functions, characteristics of column level attributes, data types, constraints, joins, subqueries, syntax usage, characteristics of SELECT, INSERT, UPDATE, DELETE, and MERGE statements.

TRANSACTION PROCESSING AND LOCK MANAGEMENT – 10%

Candidates should understand Teradata's transaction processing and lock management including types of locking and lock levels, implications of using different transaction modes, differences between transaction, request, and statement, and impact of session characteristics on requests.

SOLUTION DEVELOPMENT PROCESS AND CONSIDERATIONS – 17%

Candidates should have a good understanding of Teradata's solution development process and considerations including types and purposes of indexes, partitioning strategies, logical and physical database design, roles, profiles, and privileges. 

SOLUTION OPTIMIZATION – 16%

Candidates should understand solution optimization including the tuning process including improving an existing application, designing and populating effective performance testing environments, using DBQL data, and identifying performance tuning considerations.

ACCESS LAYER AND DATA DELIVERY STRATEGIES – 3%

Candidates should understand access layer and data delivery strategies.

DATA INTEGRATION STRATEGIES – 14%

Candidates should understand data integration strategies including TPT LOAD, EXPORT, UPDATE, and STREAM operators, optimal load strategies, and BTEQ and Teradata Studio Suite. 

preparing for your exam

  • The Teradata Certified Professional Program partners with the Teradata Education Network to provide Teradata courseware and curriculum that relates to each exam.
  •  
  • Please note that these courses are recommended and not required. Taking or passing a course does not guarantee passing of any TCPP certification exam.
  •  
  • Additional training may need to be taken in order to cover all of the objectives on the exam. You can view course descriptions and schedules, and enroll online.

      

TERADATA EMPLOYEES ONLY

Log on to the Teradata network and the TCPP Connections site for recommended training.

  • policies

Exam Administration Policies

Before your exam, review our policies on exam sequencing, recertification, retaking exams, banning, and reinstatement.

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