Classes, times, and topics

There will be lectures on Tuesday and Thursday every week from 11 AM to 12 PM EST (For now, subject to poll in discord), and focus groups on Monday, Wednesday, and Friday at the same time (again hours may vary as weeks go on).

https://ournetwork.mirror.xyz/gP16wLY-9BA1E_ZuOSv1EUAgYGfK9mELNza8cfgMWPQ - all class recordings!

Attendance is expected, but recordings will be sent out in case of time conflicts.

• Lectures are for learning high-level new material and SQL/Ethereum concepts.
• Focus Groups are like office hours in university but will have prompts/protocol delegates around as well.
• We'll have other events such as protocol presentations as well in the first two weeks.

The lesson plan is below, we may adjust this if the pace is too fast/difficult for everyone.

Week one: Learning to become an Etherscan detective, and understanding the data/token landscape!

• Lecture 1: Looking at basic call and event data on Ethereum. (Andrew)
  • navigation on Dune, and how to do basic SELECT and WHERE queries on data tables.
• Lecture 2: Understanding ERC20 and ERC721 standards. (Kofi)
  • how to do aggregate, group by, and CTE queries/subqueries
  • using Dune Decode and ABIs

Week two: Making sense of smart contracts, specifically learning to work with composable data!

• Lecture 3: Working with data from multiple events (JD)
  • How to do basic joins and unions
  • Using tables prices.usd to get to more informed data tracking.
• Lecture 4: Working with many tokens and DeFi exchanges (Danning)
  • More advanced joins, and windows/partitions.
  • Introduce dex.trades.

Week three: Putting it all together, to become an open-source query Dune Wizard!

• Lecture 5: Creating complex but reusable queries. (Rantum)
  • How to create User Generated Views and Materialized views
  • Working with nft.trades and NFTs more generally
• Lecture 6: All about Visualizations ****(Boxer)

Week four:* Dashboards and Storytelling, really connect with the community behind the data!

• Lecture 7: All about using parameters for really custom and flexible dashboards. (Michael)
• Lecture 8: Telling stories with your charts, formatting well (Boxer)

<aside> ⚠️ *The fifth and last week of the course is Thanksgiving week, but we will spend it reviewing all students' work and hosting daily office hours. Fourth-week bounties will be delayed to the end of the fifth week, so students have more time to work on their dashboards and write-ups.

</aside>

Helpful Resources:

I'll compile a list of query resources below:

Web3 Query Quick Start Guide

Table Mapping Guide

Dune Utility Queries

Reading Resources

Student Bounties