learnkdb
DocsQuestionsMock Interview⚡ Rapid Quiz
Sign inBook an interview

Getting Started

  • Getting Started with kdb+/q

Core Concepts

  • Types
  • q Terminology
  • Operations on Lists (Iterators & Amend)
  • Dictionaries
  • In Memory Tables
  • Functions
  • Attributes
  • Iterators
  • Interprocess Communication (IPC)
  • Memory Management & Memory Mapping
  • Persisting Tables

Data Analysis

  • qSQL
  • Joins
    Each-Left Join
    Join (,) and Union Join (uj)
    Join-Each (,')
    Left-Join (lj), Inner-Join (ij), Plus-Join (pj)
    Window Join (wj)
    Asof
    As-of Join (aj)Practice Questions (2)

System Features

  • File Parsing
  • Serialization
Back to Joins

Joins

As-of Join (aj)

Skip to 2 practice questions

Practice questions on joining prevailing values — like a quote price at the time of a trade — with aj.

Practice Questions

Test your understanding with 2 hands-on questions

01Join Prevailing Quotes to Trades with aj02Optimise the Performance of an As-of Join
JL

Ready to test yourself?

Book a 60-minute mock kdb+/q interview with Jeremy Lucid, with feedback on what to work on next.

Book an interview
PreviousAsofNextFile Parsing
learnkdb

Free, step-by-step kdb+/q learning material, from core data structures to qSQL, joins and IPC.

Content

  • Documentation
  • Practice Questions
  • Rapid Quiz

Mock interviews

  • Book an interview
  • Contact & terms
  • Privacy
  • Jeremy Lucid on LinkedIn

Account

  • Sign in
  • Dashboard

© 2026 learnkdb.com. All rights reserved.

kdb+ and q are trademarks of Kx Systems, Inc.