Free course

Supabase Course

Build with Supabase using PostgreSQL, local migrations, generated APIs, Auth, Row Level Security, Storage, Realtime, Edge Functions, and tested recovery.

5 modules · 20 lessons · No signup

Prerequisites: PostgreSQL, TypeScript, Node.js and Web Authentication

Download this course as PDF or EPUB

Read it offline, on your Kindle, or print it. Join my free newsletter and you get this course plus every other book and course I published.

Download PDFDownload EPUB
~~~

Your progress

of lessons completed.

Course completed.

What you'll learn

Build and release a Supabase application with reviewed migrations, ownership-aware RLS, private files, secure realtime updates, and a recovery plan.

Course contents

  1. Supabase foundations

    PostgreSQL, projects, local development, APIs, keys, and trust boundaries.

    1. ✓ Understand the Supabase platform
    2. ✓ Create a local Supabase project
    3. ✓ Separate public and secret keys
    4. ✓ Check your understanding: supabase foundations

  2. Database and migrations

    Schemas, constraints, local migrations, generated types, connections, pooling, and release safety.

    1. ✓ Design the PostgreSQL schema
    2. ✓ Version schema changes
    3. ✓ Choose direct or pooled connections
    4. ✓ Check your understanding: database and migrations

  3. Auth and Row Level Security

    Sessions, ownership, RLS policies, policy composition, server boundaries, and denied-path tests.

    1. ✓ Authenticate users
    2. ✓ Write owner-based RLS policies
    3. ✓ Test the denied paths
    4. ✓ Check your understanding: auth and row level security

  4. Storage and Realtime

    Private buckets, object ownership, signed access, Broadcast, Presence, and channel authorization.

    1. ✓ Protect Storage objects
    2. ✓ Choose a Realtime feature
    3. ✓ Authorize Realtime channels
    4. ✓ Check your understanding: storage and realtime

  5. Functions and production

    Edge Functions, secrets, environments, observability, backups, limits, and recovery.

    1. ✓ Add a trusted Edge Function
    2. ✓ Separate environments and secrets
    3. ✓ Observe, back up, and recover
    4. ✓ Check your understanding: functions and production