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
Functions A review of stored procedures and functions. Also a description of all q key words (dev, wavg, type etc.).
q Startup Options A short description of all the q start up options.
IPC A basic introduction to q inter-process communication. Opening sockets. Synch/asynch messaging.
Attributes A look at the various list attributes in kdb+ and how and when they should be used.
Importing Data A detailed look at importing data from CSV files and various other formats e.g. mdf files.
Table Arithmetic Applying simple arithmetic operations to tables and dictionaries.
ODBC A look at kdb+ in relation to ODBC
Day 2
Advanced Web Interface An 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.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.
Over Each Prior Next A few examples on over, each, prior, prev & next and where they are helpful.
Joins Simple joins between tables and/or dictionaries.
Day 3
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.
Advanced Language Interfaces An in-depth break down of the c* interface files.
Importing Foreign Libraries Loading external libraries into q.
Tables on Disk A breakdown of how kdb+ stores data on disk.
Memory Management A detailed explanation of how q manages its memory stack.
Logging & Checkpointing OLTP databases. Creating transactional databases.