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
Enumeration A detailed discussion on enumeration, when to enumerate and its consequences.
q Startup Options A short description of all the q startup options.
Schemas Detailed overview on how to extend tables and created keyed tables.
Keyed Tables An introduction to SQL-like kdb+ queries.
Attributes A look at the various list attributes in kdb+ and how and when they should be used.
q.k/q.q A 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 Queries An introduction to SQL-like kdb+ query syntax.
Joins Simple joins between tables or dictionaries.
Table Arithmetic Applying simple arithmetic operations to tables and dictionaries.
Optimising Queries How to improve the performance and throughput of kdb+ databases.
Slaves The S option in kdb+, where to use it and its limitations.
Functional/Dynamic Queries Creating a dynamic query. Parsing the text format of a query into functional form.
Day 3
ODBC A look at kdb+ in relation to ODBC
Tables on Disk A breakdown of how kdb+ stores data on disk.
Logging & Checkpointing OLTP databases. Creating transactional databases.
Authentication/Security A look at the kdb+ security model including an example integration with Active Directory.
Building Gateways An example of how to build an efficient gateway in q.
Mserve.q An example on creating multiple request queries in kdb+.