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.