Kdb+ Tutorials

Our work with this database informed the design of Pulse
The internal application runtime used when teams move beyond analysis into production systems.

• Kdb Keyword Reference - by functional area
• QStudio IDE allows connecting to kdb+

Beginner Guides

• What is a kdb Database - a column-oriented database specialised for timeseries analysis
• 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?
• Setting up a Kdb Development Environment - installation, linux/windows tools.


• Getting Started with Kdb  - Video Tutorial for those wanting to learn Kdb/q
• Casting and Parsing in kdb+  - Video Tutorial #2
• kdb+ Data Types  - Video Tutorial #3
• kdb+ Lists  - Video Tutorial #4
• Tables  - Video Tutorial #5
• Keyed Tables  - Video Tutorial #6


• Debugging in Kdb - breakpoints, suspending on client errors, debug outputting.
• Inter-Process Communication  - client/server, (a)synchronous, message handlers.
• Creating Live kdb database charts 
• kdb+ Functions 

Advanced

• Qsql Joins - ij inner join, lj left join, uj union join
• Asof Time-series Joins   - aj wj
• Functional Queries - kdb's solution to dynamic sql queries
• 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
• Kdb database limits and errors - Kdb has its limits.
• Table Attributes - `s# sorted, `p# parted, `u# unique, `g# grouped.
• QUnit - unit testing framework for kdb.
• Strings, Symbols, Enumeration - What symbols are, When to use them. Enumerated symbol types.
• Bitcoin Trading System - using kdb+ tick for market data storage.
  1. Building our tick hdb - Loading csv data into our historical database
• Software Development (kdb+) Essentials
• Scaling kdb+  - From 5 to 5000 Users
• Kdb+ Interview Questions

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
• kdb ! Bang - Internal Functions

API

• Java API  - querying, subscribing, feedhandler.
• Compile C DLL  - in windows and then load into kdb.
• C API  - querying, subscribing, feedhandler.
• All Python kdb+ APIs. 
• Kola Kdb Python API. 

Blog Tutorials

• kdb+ Alternatives - An open standards future
• The Future of kdb+ - Will it expand outside finance?
• 10 Years of kdb+
• 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
• JQ Online q Language Runner

Misc.

• Persisting End Users Data - An elegant system for persisting user data.
• q Quirks - compared to standard SQL and string handling.
• Interesting external Kdb links.
• Bitcoin Tickerplant Video

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