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.
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.
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.