- 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 - AnalysisAdvancedNew
Optimize a Slow Trino Query Over a Petabyte Warehouse
Receive the slow SQL query (around 600 lines), the Trino EXPLAIN ANALYZE output, the underlying Iceberg table schemas (partition specs, sort orders), and 30 days of execution me…
- Trino
- Sql Optimization
- Iceberg
Big Data and Data-Intensive Systems - StrategyIntermediateNew
Migrate a Local-Government Records System from MySQL to PostgreSQL
Audit the MySQL schema (around 60 tables) for incompatibilities (case-folding identifiers, ENUM types, TIMESTAMP semantics, character sets). Plan a migration using pgloader for …
- Database Migration
- Mysql
- Postgresql
Introduction to Database Systems - AnalysisExpertNew
Diagnose and Fix Query-Planner Misestimates in a FinTech Warehouse
For each of the 6 queries, capture EXPLAIN (ANALYZE, BUFFERS) and compare estimated vs actual rows at each node. Identify the misestimate source per query (single-column stats s…
- Query Optimization
- Postgresql Planner
- Extended Statistics
Advanced Database 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
- DesignBeginnerNew
Model and Normalize a Vet-Clinic SaaS Schema
Read the current schema dump (PostgreSQL, around 28 tables, heavily denormalized) and the team's 8 most common reporting queries. Produce an entity-relationship diagram from the…
- Data Modeling
- Normalization
- Sql
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 - AnalysisIntermediateNew
Add Indexes to a Slow FinTech Reporting Database
Read the 6 reporting queries and capture their EXPLAIN ANALYZE output on staging (a refresh of prod, around 90M rows). Identify the minimum set of indexes that improves all 6 by…
- Indexing
- Query Optimization
- Explain Analyze
Introduction to Database Systems - AnalysisAdvancedNew
Tune Concurrency Control on a Multi-Tenant OLTP Database
Capture 6 hours of pg_locks + pg_stat_activity snapshots during peak. Identify the top 8 contention hotspots and classify each (row-level conflict, deadlock cycles, FOR UPDATE p…
- Concurrency Control
- Lock Contention
- Postgresql
Advanced Database Systems - Browse challenges
Explore role
Product Manager
Ship product that solves real user problems. Combine user research, prototyping, and stakeholder alignment to turn ambiguous briefs into measurable wins — the role at the centre of modern software teams.
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.
Skills and disciplines shown on this page are derived from the Ewance challenge catalogue. When the median annual salary is available for this role via Adzuna, it will be shown above with the sample size and country.