WizardCamp

Learn the skills to become a $120K+ blockchain analyst

80+ exercises on real Ethereum data, built by a former Binance and Morpho data lead.
Five certificates employers can verify.

What these roles pay

$126k

Data Analyst

$196k

Data Engineer

$203k

Data Scientist

Verified from 133 real job postings →

0:00 / 0:00
The Problem

Watching tutorials isn't learning

You can watch twenty hours of YouTube and still freeze at a blank SQL editor. Blockchain analytics is a doing skill. The only way in is reps on real data. That's the whole product.

WizardCamp blockchain question with the SQL editor and schema panel
How It Works

How it works

1

Read the question. The concept, the schema and the hint sit on one screen.

2

Write the query against real Ethereum mainnet data. Nothing to install.

3

Hit Run. Grading is instant, and it shows you which rows are wrong.

Two Modes

Two ways to learn blockchain analytics

Learn

  • Guided path from zero to advanced
  • SQL fundamentals through complex analytical patterns
  • Blockchain concepts paired with the SQL to query them
  • Instant feedback on every query you write
  • No setup, runs entirely in your browser

Practice

  • Pick any topic, any difficulty, drill away
  • Interview prep before a live coding round
  • Keep query skills sharp in the AI era
  • Unlimited questions, from beginner to brutal

Learn builds the skill. Practice keeps it.

Interview Ready

Prepare for crypto data analyst interviews

Crypto data teams test candidates with live SQL on real blockchain tables. Most people freeze because they learned SQL on synthetic CSVs. Practice mode gives you the reps to walk in confident.

Real interview patterns

Joins, window functions, CTEs, aggregations on billions of rows. The exact patterns interviewers ask for.

Blockchain-native problems

Token transfers, DEX swaps, gas analysis, protocol events. Not generic SQL on a movie database.

Unlimited drilling

Pick any topic, any difficulty. Get instant feedback on every query. Drill until it clicks.

What's Inside

12 modules, built around real crypto data

85

exercises

~25h

of content

12

modules

5

certificates

0

SQL Foundations

SELECT, filtering, aggregation, joins, and CASE WHEN

6 exercises2h
1

Ethereum Blockchain Fundamentals

Blocks, transactions, gas fees, wallet activity

10 exercises3h
2

Token Analytics

ERC-20 transfers, volumes, token mechanics, holder analysis

12 exercises4h
3

NFT Analytics

Sales, buyer behavior, wash trading detection

6 exercises2h

Plus 10 protocol-pack exercises across Uniswap and Aave.

Everything you learn here applies directly on the professional platforms: Dune, Allium, or your company's own warehouse. The syntax and the thinking travel with you.

WizardCamp learning path with exercises and progress tracking
Your Instructor

Built by someone who does this every day

Vincent Charles, Founder of Unchain Data

Vincent Charles

Founder, Unchain Data

BinanceMorphoPrev. Data & BI Lead at Binance and Morpho

$160B+

CEX strategy supported

$5B+

DeFi TVL analyzed

6+

Web3 protocols & funds advised

  • Built data and BI functions from zero at Binance and Morpho Labs
  • Advises Web3 founders, CTOs, and funds on data strategy, KPI design, and OKR frameworks
  • Works across DeFi, DAOs, infrastructure, and other Web3 projects
  • Methodology drawn from systems designed and run at scale at Tier-1 projects
Protocol Packs

Protocol Packs: analyze Uniswap and Aave data

Go deep on the protocols that matter. Dedicated packs teach you a protocol's architecture through its data. More packs shipping regularly.

Uniswap

Trace a swap through the pools, from router to pair contract to token transfer.

Aave

Follow a liquidation through the events, from health factor to debt repayment.

Included in every plan. More protocol packs shipping regularly.

Testimonials

What learners say

You cannot vibe-query your way to a real crypto metric. The query is the easy part. The hard part is understanding crypto data itself.
Ishita profile photo

Ishita

research analyst, onchain markets

@Ishita_30

WizardCamp is how I actually learned to write real onchain SQL, not tutorial SQL. Querying live Ethereum data from the first exercise made it click way faster than any course.
Aaryan profile photo

Aaryan

beta cohort

@0xaaaryan

Certificates

Prove it, shareably

Five certificates, one of them free.
Each is earned by solving every question in its track. Each is recorded server-side and lives at a public link hiring managers can verify.

DC-SAMPLE

SQL Foundations

Free

This confirms that Satoshi Nakamoto has been certified in SQL Foundations by Unchain Data

Module 0, 6 questions

Find Science BooksMost Expensive BooksOrders Per CustomerBig SpendersCustomer Order DetailsOrder Size Categories
Unchain Data

Vincent Charles

Vincent Charles, CEO

DC-SAMPLE

Ethereum Blockchain Foundations

Pro

This confirms that Ada Lovelace has been certified in Ethereum Blockchain Foundations by Unchain Data

Modules 1 to 5, 40 questions

Ethereum Blockchain FundamentalsToken AnalyticsNFT AnalyticsDeFi AnalyticsTraces and Internal Calls
Unchain Data

Vincent Charles

Vincent Charles, CEO

DC-SAMPLE

Advanced Ethereum Analyst

Pro

This confirms that Alan Turing has been certified in Advanced Ethereum Analyst by Unchain Data

All 12 modules, 85 questions

SQL FoundationsEthereum Blockchain FundamentalsToken AnalyticsNFT AnalyticsDeFi AnalyticsTraces and Internal CallsMEV and Order FlowCross-chain AnalyticsL2 AnalyticsReal World AssetsOraclesStablecoin Analytics
Unchain Data

Vincent Charles

Vincent Charles, CEO

DC-SAMPLE

Uniswap Analytics

Pro

This confirms that Grace Hopper has been certified in Uniswap Analytics by Unchain Data

Protocol pack, 6 questions

Average Swap Size by ChainBusiest Chain Each DayChain Market Share by VolumeUniswap Daily Swap CountUniswap V4 Volume by ChainDay-over-Day Volume Change
Unchain Data

Vincent Charles

Vincent Charles, CEO

DC-SAMPLE

Aave Lending

Pro

This confirms that Margaret Hamilton has been certified in Aave Lending by Unchain Data

Protocol pack, 4 questions

Aave Daily Supply VolumeAave Supply vs Borrow by TokenAave Unique Borrowers per TokenAave Utilization Rate
Unchain Data

Vincent Charles

Vincent Charles, CEO

Pricing

Simple, honest pricing

Start free with 9 exercises. Go Pro for full access to every module, protocol pack, and certificate.

MonthlyAnnualSave 20%
$12/month

Billed annually ($144/year)

  • Full Learn path: all 85 exercises across 12 modules
  • Practice mode: unlimited questions
  • Protocol Packs (Uniswap, Aave, and more)
  • 5 shareable certificates, SQL Foundations free
  • Instant grading and query feedback
  • New exercises added regularly
Go Pro

For context: the cheapest professional analytics plan out there is now $65/month, before you've written your first query.

Stop watching. Start querying.

Sponsor the Free Path

Protocols and chains: sponsor the free path

The exercises that stay free decide who becomes an onchain analyst next year.

Analysts who know your tables before they apply.

Exercises on your data, free, with a certificate for LinkedIn.

I co-develop the exercises with your team and keep them on the free path.

Next protocol or chain: yours?

FAQ

Frequently asked questions

No. The Learn path starts from zero. You will write your first real query inside the first module, on actual blockchain data. Instant feedback tells you exactly what went wrong.
Real Ethereum mainnet data: transactions, token transfers, DEX swaps, lending events, bridge deposits, MEV activity, and more. The data comes from indexed blockchain tables. Those are the same tables professional analysts use on Dune, Allium, and similar platforms.
Every exercise runs against real onchain data, not synthetic CSV samples. You are not learning generic SQL. You are learning the patterns and mental models that matter for blockchain analysis. How events encode state changes. How to reconstruct balances from transfer logs. How to identify MEV. That context is absent from generic SQL courses.
Protocol Packs are deep-dive modules built around a single DeFi protocol. Instead of abstract exercises, you trace a Uniswap swap through the pool contracts. Or you follow an Aave liquidation through its events. Launching with Uniswap and Aave, with more shipping regularly. Included in every plan.
The curriculum covers exactly what crypto data teams test in technical interviews: onchain SQL, protocol mechanics, and analytical thinking. The certificates are linked and verifiable, which gives you something concrete to put on a resume. Most candidates who struggle in crypto data interviews learned SQL on synthetic data. They have never seen a real transaction table.
Yes. You can cancel your subscription at any time. You keep full access until the end of your current billing period (month or year). Your progress is saved if you come back.