Course content
7 modules · 42 lessons · 5 h 39 min of reading. Each module shows the exam domains it prepares for.
01Reading raw blockchain data6 lessons · 48 minExam domain 01
Prepares for: 01 On-chain data models (UTXO & account) (22%)
02UTXO and account models6 lessons · 47 minExam domain 01
Prepares for: 01 On-chain data models (UTXO & account) (22%)
03Building transaction graphs6 lessons · 47 minExam domain 02
Prepares for: 02 Transaction graph analysis (17%)
04Clustering heuristics and their limits6 lessons · 47 minExam domain 03
Prepares for: 03 Clustering & entity heuristics (17%)
- 4.1What clustering is and why it matters8 min
- 4.2The common-input ownership heuristic8 min
- 4.3Change detection heuristics8 min
- 4.4Account-model heuristics8 min
- 4.5Attribution and labeling7 min
- 4.6Evaluating cluster quality8 min
05Token, NFT and smart contract flows6 lessons · 49 minExam domain 04
Prepares for: 04 Smart contract & token flow analysis (17%)
- 5.1Reading token transfers8 min
- 5.2NFTs and multi-token standards8 min
- 5.3Decoding smart contract interactions8 min
- 5.4DEX swaps and liquidity flows8 min
- 5.5Lending, bridges and protocol accounting8 min
- 5.6Analyzing exploits and hacks9 min
06Querying chains with SQL6 lessons · 52 minExam domain 05
Prepares for: 05 Analytics tooling & SQL (15%)
- 6.1The analytics data stack8 min
- 6.2SQL foundations for blockchain tables8 min
- 6.3Joins, window functions and CTEs for flows9 min
- 6.4Querying UTXO data9 min
- 6.5Querying EVM logs and traces9 min
- 6.6Performance, cost and reproducibility9 min
07Analytical reporting6 lessons · 49 minExam domain 06
Prepares for: 06 Reporting & visualization (12%)