Kdb+ Tutorials � Kdb+ Tutorials

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.

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

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