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.
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.
ACCESS LAYER AND DATA DELIVERY STRATEGIES – 3%
Candidates should understand access layer and data delivery strategies.