kdb+ Advanced

Kdb+ Advanced is ideal for developers with an existing grounding in kdb+. This training course will give you a deeper understanding of how kdb+ works and how you can use some of its more powerful features. kdb+ Advanced concentrates on tuning and getting maximum performance out of kdb+ applications. Over the three days you will cover amongst other topics a review of stored procedures and functions, a detailed look at importing data from CSV files and various other formats, ODBC, an in-depth look at the kdb+ web interface and associated functions and advanced language interfaces.

Day 1
FunctionsA review of stored procedures and functions. Also a description of all q key words (dev, wavg, type etc.).
q Startup OptionsA short description of all the q start up options.
IPCA basic introduction to q inter-process communication. Opening sockets. Synch/asynch messaging.
AttributesA look at the various list attributes in kdb+ and how and when they should be used.
Importing DataA detailed look at importing data from CSV files and various other formats e.g. mdf files.
Table ArithmeticApplying simple arithmetic operations to tables and dictionaries.
ODBCA look at kdb+ in relation to ODBC
Day 2
Advanced Web InterfaceAn in-depth look at the kdb+ web interface and associated functions. Creating and applying custom web look and feel for your database.
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.
Over Each Prior NextA few examples on over, each, prior, prev & next and where they are helpful.
JoinsSimple joins between tables and/or dictionaries.
Day 3
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.
Advanced Language InterfacesAn in-depth break down of the c* interface files.
Importing Foreign LibrariesLoading external libraries into q.
Tables on DiskA breakdown of how kdb+ stores data on disk.
Memory ManagementA detailed explanation of how q manages its memory stack.
Logging & CheckpointingOLTP databases. Creating transactional databases.