📈
MetricsDAO
  • The DAO for Web3 Analytics
  • MetricsDAO Ecosystem
    • Labor Markets Docs
    • Metrics App Docs
    • Metrics App Walkthrough
    • xMETRIC
    • xMETRIC Masters
  • NETWORKS
    • Quickstart: Make a Network
    • Networks 101
    • Network List
  • Operations
    • Constitution
    • Team Structure
      • Governor and Genesis Councils
      • Treasury
    • Tooling and Processes
    • Code of Conduct
    • Partners
    • Brand Assets
    • Directory
  • Education
    • Education Overview
    • MetricsDAO Courses
    • 🧑‍🏫Web3 Analytics 101: Async Course
    • 🧑‍🏫Web3 Analytics 101: Live Course
      • Segment 0 - Live Course
    • 📚Workshops
      • 2022-10-12 Open-Source Data Analytics via Dune Spellbook (Prerequisites)
      • 2022-04-21+ Interactive Data Visualization with Python
      • 2022-03-30+ Subgrounds Workshop Series
      • 2022-03-11 Data Curation with dbt
      • 2022-02-10 Exploring Terra Data with Flipside Crypto
      • 2022-01-27 Dune Analytics and NFTs
  • Analyst Resources
    • Analytics Challenge FAQ
    • Tips for an Impactful Analytics Dashboard
      • Dos
        • 1. Do: Decide on the broad type of dashboard
        • 2. Do: Get clear on your audience(s)
        • 3. Do: Define and deliver on your purpose
        • 4. Do: Communicate your Big Idea
        • 5. Do: Establish a logical structure
        • 6. Do: Define key metrics
        • 7. Do: Maximize the signal-to-noise ratio
        • 8. Do: Use best practices for visuals
        • 9. Do: Ask for feedback
      • Don'ts
        • 10. Don’t: Disregard your audience’s knowledge
        • 11. Don’t: Go too technical in the methodology
        • 12. Don’t: Overwhelm with charts
        • 13. Don’t: Overwhelm with text
        • 14. Don’t: Submit without proofreading
      • Extras
      • Closing Thoughts
      • Resources
    • Evaluation Criteria
    • Analyst Resources
  • Reviewer Resources
    • Reviewer Basics
    • Providing Effective Feedback
  • Extras
    • Experiments
    • Useful Links
Powered by GitBook
On this page
  • A New Future
  • What will you learn by reviewing Segment Zero?
  • How will you learn in Segment Zero?
  • SQL
  • Blockchain Concepts
  • Congratulations!
  • Resources

Was this helpful?

  1. Education
  2. Web3 Analytics 101: Live Course

Segment 0 - Live Course

Optional pre-work and resources to help you build a foundation of knowledge before diving into the sessions.

PreviousWeb3 Analytics 101: Live CourseNextWorkshops

Last updated 2 years ago

Was this helpful?

A New Future

What stands between your current life and a future one in which you are free to work from anywhere in the world; your insights and analysis are driving real change and understanding in the blockchain economy; and your list of on-chain badges makes you the in-demand OG of the 2025 cycle of innovation?

I ask this question because as seemingly improbable as that future sounds, it is possible if you are willing to start this journey, starting with Segment Zero!

What will you learn by reviewing Segment Zero?

  • Essential knowledge of relational databases and Structured Query Language (SQL). SQL will be the fundamental tool you'll use to interact with blockchain data across popular analytics platforms such as Dune Analytics, Flipside and MetricsDAO.

  • The fundamental concepts/terminology of blockchain technology, such as block number, addresses, block hash, etc.

How will you learn in Segment Zero?

This is a purely self-paced lesson. However, you can drop in to the Discord channel to ask questions and interact with your fellow classmates and (instructor?)

Okay, excited and ready to get started? Let's go!

SQL

There are a couple of ways to learn. I find that I can read a lot faster than I can listen, so back when I had to learn SQL quickly some years ago, I picked up. The title contains a small lie. They really mean 10 minutes a day, but you can read cover-to-cover in about 4 hours.

If you learn best through exercises, has a complete set from beginner to advanced on sample tables to get you started.

Blockchain Concepts

Congratulations!

You have made it through that crucial first step. You have actually learned quite a lot, and you’re ready for the rest of the classes!

Resources

You'll only need to watch of the Blockchain & Solidity Smart Contract course. The lesson's run time is 1:50:00. The instructor uses excellent web tools to help you understand why blockchain is such a potent technology, and he will cover a lot of the basic terminologies you'll see in the analytics databases. For the learner who would prefer to read, . The recommended readings are the first four lessons of Intro to Web3, but you are encouraged to read more if you have the time.

- for all general conversation related to this course!

- more about all of MetricsDAO's course offerings

- an open voice chat channel for students and instructors to use during office hours and at any time.

🧑‍🏫
#course-chat
Sam's Teach Yourself SQL in 10 Minutes
Mode
Lesson 1 Blockchain Basics
here’s a good beginner resource
MetricsDAO Discord
#education-chat
#education-info
#Education Voice