The Analyst’s Course
Quant SQL
The language quants actually use — pointed at live market data in your browser.
Lessons
- Why Investors Write SQL6 min read · Point-and-click screeners answer the questions their designers imagined.
- SELECT, WHERE, ORDER BY — Your First Real Queries8 min read · From prose to query in three clauses. Aliases, rounding, and the decimal convention — with the live
- GROUP BY — From Rows to Intelligence7 min read · Aggregates turn 30 stock rows into sector rotation reads.
- Factor Scores — Building a Composite Rank in SQL9 min read · Combine value, quality, momentum into one score. The factor-zoo context, the weights debate, and
- Screener Traps — How Every Quantitative Screen Lies8 min read · Survivorship, lookahead, and value traps: the three lies every screen tells, and the disciplines
- The Full Pipeline — SQL Finds, the Engines Veto, You Decide7 min read · The three-layer process: screen for candidates, vet with the accounting lenses, price with the
- Case File: The Screen That Would Have Caught 20227 min read · Design, in 2021, the cohort most exposed to a rate shock — using only tools in this track.
- The Weekly Workflow — Twenty Minutes, Every Week6 min read · The repeatable routine that compounds: three saved queries, one veto pass, one written line.
Sources
Fama & French (1992, 2015); Daniel & Moskowitz (2016); screener traps per standard practice
Learn content is for education only — not individualized financial advice, a recommendation, or a solicitation to buy or sell any security. Options involve substantial risk. Examples are simplified and historical patterns never guarantee future results.