SubQuery Hero Course

[didiermis]

In order to develop the solution for #324, it's necessary to finish the following modules from the SubQuery Hero Course:

• Introduction

• Module 1: Getting started
  Introduction
  Reference
  Pre-Requisites
  NPM Package Manager
  SubQuery CLI
  Docker
  Exercise 1: Hello World
  Overview of Steps Involved
  Detailed Steps

• Module 2: SubQuery Basics
  Lesson 1: The Manifest File
  Lesson 2: The Schema File
  Lesson 3: The Mappings File - Block Handler
  Lesson 4: The Mappings File - Event Handler
  Lesson 5: The Mappings File - Call Handler
  Exercise - Account Balances
  Pre-Requisites
  Overview of Steps Involved
  Detailed Steps

• Module 3: Relationships
  Lesson 1: One to Many Entities
  Exercise - Balances Transfers (One-to-Many)
  Pre-Requisites
  Overview of Steps Involved
  Detailed Steps
  References

  Lesson 2: Many to Many Entities
  Exercise - Council Proposals (Many-to-Many)
  Pre-Requisites
  Overview of Steps Involved
  Detailed Steps
  Bonus
  References

  Lesson 3: Reverse Lookups
  Exercise - Account Transfer (With Reverse Lookup)
  Pre-Requisites
  Overview of Steps Involved
  Detailed Steps
  References

• Module 4: Aggregation
  Lesson 1: Aggregation Basics
  Exercises
  Pre-Requisites
  Exercise 1: Index Staking Rewards
  Overview of Steps Involved
  Detailed Steps

  Exercise 2: Aggregate Staking Rewards
  Pre-Requisites
  Detailed Steps

  Exercise 3: Viewing Both Aggregated and Individual Staking Rewards
  Pre-Requisites
  Detailed Steps

  Exercise 4: Reward vs Rewarded
  Pre-Requisites
  Detailed Steps
  References

• Module 5: Projects & Explorer
  Lesson 1 - Deploying a project
  References

  Lesson 2 - What are SubQuery Slots and How to Use Them?
  References

  Lesson 3 - Exploring Projects
  Exercise
  Pre-Requisites
  Deploying your Project
  Overview of Steps
  Detailed Steps
  References

• Module 6: Tips & Tricks
  Block v Events v Calls
  Using a Dictionary
  Event & Extrinsic Names
  Polkadot Documentation
  Polkadot Explorer
  The Polkadot CLI API

  Type Safe Properties
  Logging
  Debugging
  Changing the Batch Block Size
  Changing the Starting Block
  Bonus Tutorial

Review the following packages:

• @subql/cli
• @subql/node
• @subql/query
• @subql/common
• @subql/common-substrate
• @subql/types
• @subql/validator

DB

• Consult the Postgres documentation
• Apollo Server

Review the examples projects:

• SubQuery Explorer