Other Database courses High Wycombe

...system architecture; terminology: instance/database, tablespace, tables, views, columns, nulls, referential integrity, Buffer Pools, alias, attributes...

...When to index; Clustering index; When not to index; Composite keys; Reorganising indexes; Creating indexes. Predicates, access paths, & I/O types Predicates...

...On successful completion of this course, attendees will be able to: describe all the major RACF changes since RACF 2.2, explain how these changes can significantly...

...On successful completion of this course, attendees will be able to: differentiate between 'good' stress and 'bad' stress, identify the signs of stress in yourself and in others...

...Stored Procedure definition options. Writing and Preparing External Stored Procedures External Stored Procedures; SQL procedures; language requirements...

...Virtual storage relief; Security enhancements; Temporal tables & period data versioning; pureXML enhancements. Performance Enhancements Reduced CPU usage...

...Application design factors; DB2 traces. DB2 Traces Activating traces; Trace types; Trace destination; Trace classes; IFCID types; Other trace options...

...of Journals describe the Replication Center explain the use of the Task Center describe the use the Event Analyzer explain the Indoubt Transaction Manager...

...DB2 EXPLAIN Use of EXPLAIN as a first step in performance tuning; Contents of PLAN_TABLE, DSN_STATEMNT_TABLE and DSN_FUNCTION_TABLE; EXPLAIN examples...

...DB2I and QMF overview Basic SQL format; submitting SQL using DB2I and SPUFI, QMF overview. Discuss the basics of SQL and the online environments from where it may be submitted...