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.
- 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.