kdb+ Advanced for Data Analysis

Kdb+ Advanced for Data Analysis is focused on profiling, debugging and enabling rapid strategy development using kdb+. Over the three days you will cover amongst other topics; applying simple arithmetic operations to tables and dictionaries, user defined functions, advanced qSQL queries and a detailed look at how to optimise queries for performance reasons.

Day 1
The BasicsAn introduction to q. Starting sessions, defining variables etc.
In-built FunctionsA review of stored procedures and functions. Also a description of all q key words (dev, wavg, type etc.).
Tables OverviewHow to define tables. Differences between keyed and unkeyed tables.
Select StatementsAn introduction to SQL-like kdb+ queries.
Table ArithmeticApplying simple arithmetic operations to tables and dictionaries.
Day 2
User-defined FunctionsSyntax and examples of creating functions and executing them.
JoinsSimple joins between tables and/or dictionaries.
AdverbsDescription of adverbs in the q language and examples of where they are useful.
Functional/Dynamic QueriesCreating a dynamic query. Parsing the text format of a query into functional form.
Day 3
Basic IPCA basic introduction to q inter-process communication. Opening sockets. Sending queries and executing remote functions.
Advanced Select StatementsAdvanced qSQL queries.
Optimisations and PerformanceDiscussion on optimising queries for performance reasons
ODBCA look at kdb+ in relation to ODBC.
Extracting Data/Language
A look at interfacing q with one or more of the standard computer languages (Java, C/C++, C#).