TRANSACTION PROCESSING AND LOCK MANAGEMENT - 10%
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.
DATA INTEGRATION STRATEGIES - 12%
Data integration strategies including MLOADX, optimal load strategies, and data integration into temporal and columnar tables.
ADVANCED SQL CONCEPTS - 33%
Advanced SQL concepts including syntax, usage, and characteristics of macros, stored procedures, permanent tables, table level attributes, CREATE TABLE AS, Referential Integrity, indexes, views, triggers, temporary tables, regular expressions, functions, usage and characteristics of column level attributes, data types, constraints, joins, subqueries, syntax usage and characteristics of ALTER TABLE, SELECT, INSERT, UPDATE, DELETE, and MERGE statements.