Kdb+ Advanced for DBA

Kdb+ Advanced for DBA is three days of focused training on the structure of kdb+ databases and associated maintenance tasks for designing data models to intra-day updates on existing tables. Over the duration of the course you will cover amongst other topics; the role of the q.k and q.q files with a detailed explanation of each function, q shortcuts, a review of the S options in kdb+, OLTP databases and creating transactional databases.

Day 1
EnumerationA detailed discussion on enumeration, when to enumerate and its consequences.
q Startup OptionsA short description of all the q startup options.
SchemasDetailed overview on how to extend tables and created keyed tables.
Keyed TablesAn introduction to SQL-like kdb+ queries.
AttributesA look at the various list attributes in kdb+ and how and when they should be used.
q.k/q.qA look at the roles of the q.k and q.q. files with a detailed explanation of each function.
q Shortcuts (-x!)A discussion on each of the –x! functions, what they do and where they are used.
Day 2
Simple QueriesAn introduction to SQL-like kdb+ query syntax.
JoinsSimple joins between tables or dictionaries.
Table ArithmeticApplying simple arithmetic operations to tables and dictionaries.
Optimising QueriesHow to improve the performance and throughput of kdb+ databases.
SlavesThe S option in kdb+, where to use it and its limitations.
Functional/Dynamic QueriesCreating a dynamic query. Parsing the text format of a query into functional form.
Day 3
ODBCA look at kdb+ in relation to ODBC
Tables on DiskA breakdown of how kdb+ stores data on disk.
Logging & CheckpointingOLTP databases. Creating transactional databases.
Authentication/SecurityA look at the kdb+ security model including an example integration with Active Directory.
Building GatewaysAn example of how to build an efficient gateway in q.
Mserve.qAn example on creating multiple request queries in kdb+.