Querying trade, position, risk, and reference data with confidence — a practical, interview-ready reference that takes you from a single SELECT to reconciliation engines, P&L roll-ups, and the query patterns that separate a competent analyst from an indispensable one.
What's Inside
Every example is built on one deliberately realistic trading data model — security master, trades, positions, books, desks, counterparties, prices, FX rates, and daily P&L — so the queries read like the questions you'll actually be asked on the desk.
Part I · Foundations
Part II · Combining & Summarizing Data
Part III · Analytical SQL
Part IV · The Capital Markets Toolkit
Part V · Quality, Performance & the Interview
Who This Is For
Translate a trading-desk question into a correct, defensible query — and get believed.
Speak the language of trades, positions, and P&L fluently in live conversations.
Reason about grain, joins, and reconciliation the way production systems do.
Pull, pivot, and validate exposure and volume for institutional reporting.
Surface breaks and data-quality issues before stakeholders ever see them.
Walk into a SQL screen and recognize the pattern behind every question.
Pair this guide with the complete SQL Mastery Guide and get both books at one discounted price — the capital-markets field guide plus the full end-to-end SQL reference.
Ready When You Are
Instant PDF download after purchase. One-time payment, yours to keep.