INTERMEDIATE
Master on-chain data — EVM event logs, The Graph subgraphs, Dune Analytics SQL, modern indexing tools (Ponder, Envio, Goldsky), streaming pipelines, and building production-grade DeFi dashboards.
The EVM data model — transactions, receipts, logs, state — and the infrastructure to access it.
Build, deploy, and query subgraphs — The Graph's decentralized indexing network for blockchain data.
SQL-based blockchain analytics — DQL, Spellbook abstractions, and building production-grade dashboards.
Modern blockchain indexing tools — Ponder, Envio, Goldsky — plus streaming pipelines and data lake patterns.
DeFi metrics, MEV detection, whale monitoring, anomaly detection, and building real-time alerts.
Design a comprehensive data infrastructure for a production DeFi protocol.
