Overview
What this challenge is about.
Build a multi-tenant Postgres schema with RLS, write migrations, and test for cross-tenant leakage to earn your verifiable certificate.
The scenario
The yoga-studio SaaS (bootstrapped, profitable) cannot afford a tenant-data-leak — one cross-tenant bug ends the founder-led trust the brand sells on.
The Brief
What you'll do, and what you'll demonstrate.
Migrate from schema-per-tenant to single-schema multi-tenant with RLS, proving tenant isolation through an automated test suite.
Earning criteria — what you'll demonstrate
- Design a multi-tenant data model that scales beyond schema-per-tenant
- Write and reason about Postgres Row Level Security policies
- Build a test suite that proves data isolation, not just functional correctness
- Measure the performance impact of RLS on a real workload
Program Fit
Where this fits in your program.
Sharpens the same skills your degree expects you to demonstrate.
Aligned coursework coming soon.
Skills
Skills you'll demonstrate.
Each one shows up on your verified credential.
- Multi Tenant Architecture
Apply multi tenant architecture to solve real industry problems and demonstrate production-level capability.
- Postgresql
Apply postgresql to solve real industry problems and demonstrate production-level capability.
- Row Level Security
Apply row level security to solve real industry problems and demonstrate production-level capability.
- Database Migrations
Apply database migrations to solve real industry problems and demonstrate production-level capability.
- Test Strategy
Apply test strategy to solve real industry problems and demonstrate production-level capability.
- Performance Testing
Apply performance testing to solve real industry problems and demonstrate production-level capability.
Careers
Career paths this challenge builds toward
Completing this challenge demonstrates skills that transfer directly to these roles: