MANAGE AND OPTIMIZE DATA SOLUTIONS - 16%
Focuses on indexes, partitioning, database design, system default characteristics and impacts, processing executed in an Explain plan, steps to integrate new data features, access layers and QueryGrid as part of a data access strategy.
DATA INTEGRATION STRATEGIES - 13%
Focuses on TPT LOAD, EXPORT, UPDATE and STREAM operators, error habndline on a TPT job, TPT operators, optimal load strategies and access modules as part of a data access strategy.
TRANSACTION PROCESSING AND LOCK MANAGEMENT - 8%
Focuses on advanced locking types and implications, differences between a transaction, request and statement and the impact of session characteristics on request via a scenario.
SOLUTION OPTIMIZATION - 13%
Focuses on tuning processes and options to improve an existing application, advanced tuning options, designing and tuning an application, options and characteristics of an optimized application, resolving data quality issues and use cases for output from data profiling.
SQL CONCEPTS - 39%
Focuses on macros, stored procedures, tables, advanced data types, column level attributes, basic data types, constraints, referential integrity, indexes, row partitioning, views, expression functions, window aggregates, JSON functions, common clauses, operators, period data type functions, correlated subqueries, nulls with joins, scalar functions and subqueries, etc.
VANTAGE INTEGRATION AND INTEROPERABILITY – 11%
Focuses on moving data to and from object storage, third-party data storage, building and operationalizing a predictive model pipeline, event-driven architecture, native cloud services and OpenSource integration.