QforMortals2/contents

From Kx Wiki
Jump to: navigation, search

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

Personal tools
Namespaces
Variants
Actions
Navigation
Toolbox