Contents 1 Q for Mortals 2.0 1.1 A Tutorial in Programming kdb+ 1.1.1 Jeffry A. Borror 1.2 Table of Contents

Q for Mortals 2.0

A Tutorial in Programming kdb+

Jeffry A. Borror

Table of Contents

1. Overview
   1. The Evolution of q
   2. Philosophy
   3. Mathematical Functions Refresher
   4. Getting Started
   5. Sample Q Program
2. Atoms
   1. Overview
   2. Integer Data
   3. Floating Point Data
   4. Binary Data
   5. Character Data
   6. Temporal Data
   7. Infinities and NaN
   8. Null Values
3. Lists
   1. Overview
   2. Introduction to Lists
   3. Simple Lists
   4. Empty and Singleton Lists
   5. Indexing
   6. Joining Lists
   7. Lists as Maps
   8. Nesting
   9. Indexing at Depth
   10. List Indexing
   11. Elided Indices
   12. Rectangular Lists and Matrices
4. Primitive Operations
   1. Introduction to Functions
   2. Operator Precedence
   3. Match (~)
   4. Relational Operators
   5. Basic Arithmetic: +, -, *, %
   6. Max (|) and Min (&)
   7. Exponential Primitives: sqrt, exp, log, xexp, xlog
   8. More Primitives: mod, signum, reciprocal, floor, ceiling and abs
   9. Operations on Temporal Values
   10. Operations on Infinities and Nulls
   11. Alias (Advanced)
5. Functions
   1. Overview
   2. Function Specification
   3. Local and Global Variables
   4. Amend (:)
   5. Projection
   6. Lists and Functions as Maps
   7. Creating Strings from Data
   8. Adverbs
   9. Verb Forms of Indexing and Evaluation
   10. Functional Forms of Amend
6. Casting and Enumerations
   1. Types and Cast
   2. Creating Typed Empty Lists
   3. Enumerations
7. Dictionaries
   1. Overview
   2. Dictionary Basics
   3. Operations on Dictionaries
   4. Column Dictionaries
   5. Flipping a Dictionary
8. Tables
   1. Overview
   2. Table Definition
   3. Empty Tables and Schema
   4. Basic select
   5. Primary Keys and Keyed Tables
   6. Foreign Keys and Virtual Columns
   7. Working with Tables and Keyed Tables
   8. Complex Column Data
   9. Attributes
9. Queries: q-sql
   1. Overview
   2. Insert
   3. The select and exec Templates
   4. The update Template
   5. upsert
   6. delete
   7. Grouping and Aggregation
   8. Sorting
   9. Renaming and Rearranging Columns
   10. Joins
   11. Parameterized Queries
   12. Views
   13. Functional Forms
   14. Examples
10. Execution Control
    1. Overview
    2. Control Flow
    3. Debugging
    4. Scripts
11. I/O
    1. Overview
    2. Data Files
    3. Save and Load on Tables
    4. Text Files
    5. Binary Files
    6. Parsing File Records
    7. Saving and Loading Contexts
    8. Interprocess Communication
12. Workspace Organization
    1. Overview
    2. Contexts
13. Commands and System Variables
    1. Command Format (\d)
    2. System Variables
    3. Command Line Parameters
14. Built-in Functions
    1. Overview
    2. String Functions
    3. Mathematical Functions
    4. Aggregate Functions
    5. Uniform Functions
    6. Miscellaneous Functions
15. Error Messages
    1. Runtime Errors
    2. Parse Errors
    3. System Errors
    4. License Errors
16. References

---

Next: Overview

Table of Contents