Stackling

Backend

Databases and APIs: SQL, Postgres, HTTP, auth, caching and operations.

2 tracks · 136 lessons

Start this pathSee all paths

What you'll be able to do

  • Query a database with joins and aggregates, and design tables that hold up.
  • Read a query plan, add the right index and run migrations safely.
  • Design an API with auth, caching and resilience, then keep it running.

  1. SQL & Postgres

    Queries, joins, indexes, query plans, transactions, safe migrations and choosing a database.

    100 lessons

    1. Querying10 lessons
    2. Joins & aggregates8 lessons
    3. Modeling & constraints7 lessons
    4. Query toolkit8 lessons
    5. Indexes8 lessons
    6. Reading query plans8 lessons
    7. App-side query patterns6 lessons
    8. Transactions & concurrency9 lessons
    9. Production Postgres7 lessons
    10. Migration patterns6 lessons
    11. Diagnosing Postgres6 lessons
    12. Interview questions7 lessons
    13. Choosing a database10 lessons

  2. Backend & APIs

    HTTP, API design, auth, caching, resilience, async work, operations and system design.

    36 lessons

    1. HTTP & REST4 lessons
    2. API design4 lessons
    3. Authentication4 lessons
    4. Caching4 lessons
    5. Resilience4 lessons
    6. Async work4 lessons
    7. Data access4 lessons
    8. Operations4 lessons
    9. System design4 lessons

Five minutes today is a first step.

Start this path