MFS401

Backend Brilliance: An Expansive Supabase Course for Streamlined Backend-as-a-Service

Chapters (7)

Chapter 1

36 XP

Supabase Foundations

Chapter Progress

No progress yet

Chapter 2

24 XP

Knock Knock!: Supabase Authentication

Chapter Progress

No progress yet

Chapter 3

71 XP

Data Expeditions: A Masterclass on Supabase Databases

Chapter Progress

No progress yet

LESSONS (6)

1
Planning the Walls: Data Architecture in PostgreSQL

12 XP

Foundational

Building blocks of relational databases

Data manipulation using SQL

Advanced

Non-redundant databases using normalization (1NF, 2NF, 3NF)

Performant data queries using database indexing

2
API Odyssey: REST, GraphQL, and the Art of API Navigation

11 XP

Foundational

Database connection options (direct, pooling, APIs)

GraphQL Basics

Integrate Typescript using Supabase’s type generation

Advanced

Unstructured data storage

3
RPC Wonders: Improving with Postgres Functions

12 XP

Foundational

Introduction to Postgres functions

PLPGSQL programming syntactic structure

Advanced

Controlling access within Postgres functions

Polymorphic functions using function overloading

Integrating logic using transaction control

4
You Shall Not Pass!: Row Level Security

12 XP

Foundational

Fundamentals of RLS

Postgres access control roles

Advanced

Finegrained access through custom RLS policies

Advanced RLS policies real world use cases

Implement Instagram Story security rules using RLS

Secure Twitter Edit feature using RLS

5
A Complete Guide to Full-Text Search in Postgres

12 XP

Foundational

Fundamentals of full-text search in Postgres

Writing text-search queries using SQL and Supabase

Advanced

Deep dive into internal working on Full-Text Search in Postgres

6
Triggers & Webhooks: Action-packed Database Management

12 XP

Foundational

Overview of triggers and webhooks

Building triggers using Supabase's GUI

Adding basic webhooks through Supabase

Best practices for optimal triggers and webhooks

Advanced

Complex triggers and webhooks using plpgsql

Clean deletions using cascading deletion triggers

Safeguarded data through modification prevention triggers

Robust data practices through integrity constraints

Chapter 4

24 XP

Storage Chronicles: Exploring the Supabase Storage API

Chapter Progress

No progress yet

Chapter 5

24 XP

Supabase Realtime: Put Supabase in the Fast Lane

Chapter Progress

No progress yet

Chapter 6

36 XP

Edge of Tomorrow: Unleashing Supabase’s Edge Functions

Chapter Progress

No progress yet

Chapter 7

36 XP

Beyond the Surface: Achieving Mastery of Supabase

Chapter Progress

No progress yet