Kdb+ Tutorials

The kdb+ tutorials below represent a tiny part of our fully online kdb+ training course. which contains many hours of videos, associated exercises and solutions.

Essential

Bookmark the two links below, you'll need a way to lookup functions:

• Kdb Keyword Reference - by functional area
• code.kx.com

Beginner Guides

• What is a kdb Database - a column-oriented database specialised for timeseries analysis
• Getting Started with Kdb  - Video Tutorial for those wanting to learn Kdb/q
• Setting up a Kdb Development Environment - installation, linux/windows tools.
• Debugging in Kdb - breakpoints, suspending on client errors, debug outputting.
• Inter-Process Communication  - client/server, (a)synchronous, message handlers.

References

• Kdb Printable Cheat Sheet - One page reference listing data types, q-sql, joins...
• kdb Math Functions - sin, tan, cos, max, min...
• kdb .z Functions - Getting current date / time etc.
• kdb .Q Functions
• kdb String Functions - Concatenating, changing case, like comparisons.
• kdb IO Functions - kdb Functions that allow writing and reading files
• kdb system commands - Commands available using system "foo bar"
• kdb Database Errors - Exceptions thrown by the q language

Advanced

• Qsql Joins - ij inner join, lj left join, uj union join
• Memory Management  - buddy memory system, reference counting, version differences
• Kdb Tick Data Store  - Tickerplants, RDB's, HDB's.
• Parallel Processing  - peach and .Q.fc
• q Programming Style Guidelines - coding standards for effective maintainability
• Table Attributes - `s# sorted, `p# parted, `u# unique, `g# grouped.
• QUnit - unit testing framework for kdb.
• Bitcoin Trading System - using kdb+ tick for market data storage.
  1. Building our tick hdb - Loading csv data into our historical database

API

• Java API  - querying, subscribing, feedhandler.
• Compile C DLL  - in windows and then load into kdb.
• C API  - querying, subscribing, feedhandler.
• Using Kdb from Python. 

Blog Tutorials

• Kdb qSQL vs standard SQL queries
• RSI Relative Strength Index in Kdb
• Running q language code within the java runtime 
• Exponential Moving Average EMA in Kdb
• Probability of a 12 when you roll two Dice
• kdb+ Twitter Feed Handler 
• Timing a kdb Query
• Optimizing a kdb Query
• Kdb Visualization Tools

Misc.

• Persisting End Users Data - An elegant system for persisting user data.
• q Quirks - compared to standard SQL and string handling.
• Who uses kdb+? - What companies and banks use kdb+ for tick data etc.
• History of Kdb - kdb k4 q kdb what's the difference and who is Arthur?
• Interesting external Kdb links.
• UK Kdb Developers have longer attention spans
• Q for Mortals (amazon).

kdb+™ is a registered trademark of Kx Systems, Inc.