Beginner Blockchain Analytics (SQL)

Master Dune, Flipside, and advanced SQL to query blockchain data like professional analysts.

BlockchainBeginner4.81,420 students4 weeks

Checking enrollment…

Overview

A beginner-friendly path into Web3 data analytics. Start with blockchain explorers and on-chain fundamentals, build SQL skills on live datasets, analyze DeFi and DEX activity, and finish with dashboards that turn queries into clear insights.

What you'll learn

Blockchain explorers (Etherscan)
SQL for on-chain data
Dune Analytics
Joins, aggregations & CTEs
DEX & Uniswap analysis
Dashboard storytelling

Curriculum

1. Introduction to Web3 Data Analytics

Understanding Blockchain Data: what it is and why it matters to decentralized systemsSession

Why On-chain Data Matters: DeFi monitoring, wallet tracking, fraud detectionSession

Overview of Blockchain Data Tools: Etherscan, Dune Analytics, and their rolesSession

Exploring Blockchain Explorers: navigate Etherscan and Blockchain.com for transactions, token flows, and contractsSession

Project: Write a comprehensive Etherscan guide to analyse wallet transactions, explore smart contracts, and track token transfersProject

2. SQL for Web3 Data Analytics

SQL Foundations in Web3: SELECT, WHERE, ORDER BY with blockchain examplesSession

Joins and Aggregations: combine wallet, transaction, and token data; COUNT, SUM, AVGSession

Subqueries and CTEs: nested queries for top traders, protocol usage, and complex analyticsSession

Practice: Query wallet balances and transaction historyPractice

Practice: Identify active users on a DeFi protocolPractice

Practice: Aggregate token swap volumes over timePractice

3. Working with Blockchain Data

Advanced On-chain Tools: write SQL on live blockchain datasets with Dune AnalyticsSession

Understanding Blockchain Data Tables: schema of blocks, logs, events, and tracesSession

Analyzing Smart Contracts & DEXs: Uniswap liquidity, volume, swaps, and top pairsSession

Project: Build a SQL dashboard for Uniswap covering daily/weekly/monthly volume, liquidity pools, and unique usersProject

4. Building Insightful Dashboards

Token Performance Dashboard: price, holder distribution, and transaction trends (Dune or Tableau)Session

Data Visualization Best Practices: charts, layout, and filters that tell a clear storySession

Capstone: Design a full dashboard for a token or protocol covering price trends, wallet interaction, gas fees, retention/growth, and actionable insightsCapstone

Requirements

• No prior SQL required
• Basic computer literacy