****Follow Andrew and Jackie on Twitter to stay up to date on this course and other web3 data education initiatives!
Trying to learn more than just the basics of SQL on Ethereum? Queried a few basic function or event tables, but don’t know how to continue your analysis from there? Or just not sure of what tables to leverage to bring your work to the next level?
Then this two week program is for you! 🙂 We wrote 12 queries (one a day) from December 12th to December 23rd, which you can find in the “answers” toggle for each question below.
<aside> 📈 By subscribing to this newsletter, you’ll find daily query summaries and write-ups (plus other data tips/dives).
We’re partnering with Uniswap for this one! Here is a quick overview of Uniswap v2, and the main concepts we’re going to cover:
You can still use spark SQL if you want, but DuneSQL will be much faster. If you’re learning to use our DuneSQL engine, you can reference:
the day 0 wizard guide (below)
their great documentation to get started or find useful functions
the book below for a more descriptive walkthrough of Dune SQL (beginners starting on page 187, advanced starting at 201). We’ll have a Dune-specific beg/adv guide soon after the course!