Schema Design
If you like applying Schema Design, every challenge here gives you a chance to practice it on a real industry brief.
- CodeAdvancedNew
Build a GraphQL Federation Schema for an E-Commerce Platform
Receive the existing 22 REST endpoints' OpenAPI specs and a list of 5 priority subgraphs. Design a federated GraphQL schema using Apollo Federation v2 directives (@key, @externa…
- Graphql
- Graphql Federation
- Api Design
API Design and GraphQL - DesignAdvancedNew
Design a Transactional Schema for a SaaS Order-Provisioning System
Design the schema for orders, quota packs, consumption events, and refunds. Define each critical transaction (buy, consume, refund) with isolation level and locking strategy. Id…
- Transactions
- Acid
- Isolation Levels
Introduction to Database Systems - DesignAdvancedNew
Migrate a Monolithic Database to a Sharded Topology
Analyze schema (32 tables) + query workload (anonymized 7-day pg_stat_statements export) to identify the right shard key per table. Most tables shard on user_id; identify the 4-…
- Database Sharding
- Postgresql
- Vitess
Distributed Systems - DesignAdvancedNew
Design a Geo-Distributed Storage Layer for an EdTech
Map the access patterns (90 percent reads from the country of origin, 10 percent cross-country via teacher reviewers). Design region routing using a metadata service backed by a…
- Geo Distribution
- Data Residency
- Cockroachdb
Distributed Systems Practice your coursework on real scenarios.
Every challenge is shaped from real industry context — not generic exercises. The work mirrors what your degree prepares you for.
Why Ewance
- StrategyAdvancedNew
Migrating from Relational to NoSQL for a Social Media Startup
You are given a simplified relational schema of SnapVibe's current database (users, posts, comments, likes). Your task is to: (1) analyze the limitations of the relational model…
- Nosql
- Mongodb
- Data Migration
Database Systems
How it works
From brief to credential, in six steps.
Step 01
Browse challenges aligned to your studies.
Step 02
Accept the one that fits your goals.
Step 03
Work through it with AI Copilot guidance.
Step 04
Submit for structured evaluation.
Step 05
Earn a verified credential.
Step 06
Add it to LinkedIn with one click.
Industry teams behind a decade of practitioner briefs
Hiring from this pool?
Sponsor a challenge and meet candidates through actual work.
Industry teams can shape briefs around the skills they hire for, then evaluate students on rubric-scored deliverables — not resumes.