Starts August 19
Online
Track
DeFi Specialist
Study DeFi through protocol mechanics and onchain data. Use Dune and SQL to test hypotheses about DEXs, lending, and yield.
Mechanics Before Metrics
SQL and Dune
Protocol Risk
Independent Investigation
TrackStart with the working mechanics of exchange, liquidity, staking, lending, derivatives, and optimizers. Then move into data: query Dune with SQL, assemble protocol metrics, and check what users, transactions, and capital are actually doing.
- Trace the mechanics of DEXs, staking, lending, derivatives, LSDFi, and yield optimizers
- Understand pools, liquidity ranges, and impermanent loss
- Compare Aave, Compound, GMX, Hyperliquid, Pendle, Beefy, and other protocols
- Use SQL for transaction tables, aggregates, time series, and protocol metrics
- Read DEX trades, user activity, and capital flows from onchain data
- Build a Dune dashboard with queries, visualizations, and a defensible conclusion
- Evaluate a new DeFi project through documentation, DefiLlama, and your own queries
DeFi Specialist
Who this is for
New
Analysts and researchers who need to read DeFi through mechanics and onchain data
Pro
DeFi participants who want to test yield, liquidity, and risk with their own queries
Developers and product teams who need a working vocabulary for DEXs, lending, derivatives, and LSDFi
Beginning Dune analysts ready to learn SQL on blockchain tables
Investors and business-development teams who need a reproducible protocol review instead of a metric list
The manager already has your details
We’ll get back to you shortly.
Have questions?
We’ll reply within 15 minutes
Or contact
Curriculum
Move from DeFi mechanics to SQL, onchain data, and an independent Dune investigation.
01
DeFi Map
02
DEXs and Liquidity Types
03
Staking and Liquid Staking
04
Providing Liquidity
05
Statistics and Accounting
Show more
Learning Platform
Short lessons, practice, and final artifacts live on one platform. Wallet login does not require a separate password.
- Wallet LoginConnect MetaMask from any device and resume where you stopped. You do not need a separate password.
- Short LessonsLessons are split into small blocks. Complete one in a short session, then resume from the same point later.
- Practice ThroughoutAssignments apply the material right after a lesson. In larger programs, separate outputs build toward a final project or capstone.
- One WorkspaceLessons, quizzes, assignments, and course materials stay together. Technical tasks can use the editor and syntax highlighting.
CommunityEach block ends with an assignment. Keep the intermediate results and assemble the final piece step by step.
Reviews and Community
01
Practice Reviews
Mentors review code, models, product decisions, and research artifacts in a format that fits each program.
02
Expert AMAs
Developers, researchers, and founders answer questions and show how they make decisions in real projects.
03
Research Briefings
The Guide DAO team follows new papers, tools, protocols, and working practices and connects them to the curriculum.
What You Leave With
Finish the program with a verifiable result you can show to a team or use in your next project.
Final Project
Build the program's main result against clear criteria and take it to a state another person can verify.
Portfolio of Work
Keep intermediate artifacts, sources, and decisions so others can see how you worked and why you reached the result.
Next Step
Record the result's limits, open questions, and next actions for your own project, a team, or a new role.