QforMortals

From Kx Wiki
Jump to: navigation, search

Q for Mortals

A Tutorial in Programming kdb+

Jeffry A. Borror

  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. Infinity and NaN
    6. Character Data
    7. Temporal Data
    8. Null Values
  3. Lists
    1. Overview
    2. Introduction to Lists
    3. Simple Lists
    4. Empty and Singleton Lists
    5. Indexing
    6. Lists as Maps
    7. Nesting
    8. Indexing at Depth
    9. List Indexing
    10. Elided Indices
    11. 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 Mathematical Primitives: mod, signum, reciprocal, floor, ceiling and abs
    9. Operations on Temporal Values
    10. Operations on Infinities and Nulls
  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. Tables
    3. Empty Tables
    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. Aggregation
    8. Sorting
    9. Renaming and Rearranging Columns
    10. Joins
    11. Parameterized Queries
    12. Functional Forms of select and update
  10. Execution Control
    1. Overview
    2. Control Flow
    3. Debugging
    4. Scripts
  11. I/O
    1. Overview
    2. Data Files
    3. Text Files
    4. Binary Files
    5. Parsing File Records
    6. Saving and Loading Contexts
    7. Interprocess Communication
  12. Workspace Organization
    1. Overview
    2. Workspace Organization
  13. Commands
    1. Directory (\d)
    2. Change O/S Directory (\cd)
    3. Variables (\v)
    4. Functions (\f)
    5. Load (\l)
    6. Port (\p)
    7. Timer (\t)
    8. Time (\t)
    9. Workspace (\w)
    10. Operating System (\text)
    11. Interrupt (Ctrl-C)
    12. Terminate (\)
    13. Exit q (\\)
    14. Precision (\P)
  14. Built-in Functions
    1. Overview
    2. String Functions
    3. Mathematical Functions
    4. Aggregate Functions
    5. Uniform Functions
    6. Miscellaneous Functions
  15. References

Next: Overview

©2006 Kx Systems, Inc. and Continuux LLC. All rights reserved.

Personal tools
Namespaces
Variants
Actions
Navigation
Toolbox