Kdb+ Fundamentals

Kdb+ Fundamentals is an introductory kdb+ course perfect for learning about kd+ and the principles of vector programming. This three day training course is ideal for those with limited or zero experience with kdb+. By the end of this kdb+ training course  you  will be fully able to use kdb+ to manage data from multiple data sources and interact with both in memory and on disk kdb+ installations.

Day 1
The Basics An introduction to q. Starting sessions, defining variables, performing basic logic and arithmetic operations.
Data Types Detailed overview of all q data types and appropriate usage.
Lists Fundamental data structure of kdb+ upon which all advanced structures are based.
Functions In-built and user-defined functions.
Dictionaries & Associations Map type structures used for storing static, lookup or rule type information.
Execution Control Conditional statements, loops, protected evaluation and debugging.
Basic Adverbs Providing useful iterative and looping behaviour.
Day 2
Tables An introduction to q. Starting sessions, defining variables, performing basic logic and arithmetic operations.
Keyed Tables More sophisticated class of table.
qSQL An introduction to SQL like syntax in q.
Advanced Table Access q centric methods for table access, analysis and manipulation.
Basic Table Joins In-built functions for combining tables.
Day 3
Amend/Apply The q operators ‘.’ and ‘@’ in relation to manipulating data in place.
Basic Web Interface A short look at the kdb+ web interface.
Importing/Exporting Data A detailed look at importing data from CSV files and various other formats.
Basic On-Disk kdb+ Basic overview for persisting and querying tables on disk.
IPC A basic introduction to inter-process communication. Opening connections, synch/asynch messaging between q instances.
ODBC ODBC as tool to connect between kdb+ and other database technologies.
Language Interfaces Interfacing with Java, C#, C/C++ etc.