Computer Science
Database & Storage Challenges
Database & Storage challenges put you inside the work of designing data layers that stay fast and correct under load. You'll develop skills in Data Modeling, Database Schema design, and Domain Modeling, and you'll write SQL with JOINs & Aggregations against PostgreSQL or MySQL.
From there you'll handle the harder edges — Indexing strategy, Query optimization, Replication basics, and Multi-region writes — working through High availability & disaster recovery and Oracle database administration the way data teams actually do. Each challenge you solve earns a verified credential you can share with recruiters.
Recommended Challenges
- ResearchSeniorNew
SAT-Based Planner for Smart-Grid Demand Response
Encode the dispatch problem (which customers to curtail by how much, respecting per-customer contractual caps and grid-cell totals) as a SAT or MaxSAT instance. Solve 50 histori…
- Sat Based Planning
- Constraint Encoding
- Benchmarking
Automated Planning - CodeIntermediateNew
Migrate a Legacy Warehouse to a Lakehouse for an Edtech AI Platform
You receive a Postgres dump of around 50 GB and the current dbt models that produce the student-attempts mart. Land the raw data in object storage (S3 or GCS) as Parquet partiti…
- Lakehouse Architecture
- Delta Lake
- Spark
Data Engineering and Big Data Systems - DesignBeginnerNew
Optimizing Inventory for a São Paulo D2C Cosmetics Brand
You are given a CSV file with raw sales, inventory, and supplier data. Your task is to design an E/R diagram, create the normalized relational schema in 3NF, populate it with sa…
- SQL
- Database Design
- Normalization
Database Systems - CodeIntermediateNew
Add Idempotency Keys to a Payment Webhook System
Read the current Go webhook-sender code and 30 days of duplicate-delivery incident logs. Design the idempotency scheme: server-generated key per event (UUID v7 — time-ordered), …
- API Design
- Idempotency
- Webhooks
API Design and GraphQL Develop in-demand professional skills.
Each challenge names the skills it strengthens. Over time, your profile fills with the competences a hiring manager would actually look for.
Why Ewance
- AnalysisSeniorNew
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 - DesignSeniorNew
Designing a Data Warehouse for a Renewable Energy Firm
You are given sample data from three sources: energy production logs, weather data, and equipment maintenance records. Your task is to: (1) design a star schema with fact and di…
- Data Warehousing
- Star Schema
- Etl
Database Systems - DesignIntermediateNew
Migrate a 6TB Social-Commerce Database to a Sharded Topology
Using the supplied schema specification and the seven-day anonymized query-workload export, decide the correct shard key for each table and justify it from observed access patte…
- Database Sharding
- Postgresql
- Vitess
Open coursework - AnalysisBeginnerNew
Index a Slow 90-Million-Row FinTech Reporting Database
Your analysis task is to read the engineering ticket and the six reporting queries in the case file (M1), study the transactions table definition, column statistics, and write w…
- Indexing
- Query Optimization
- Explain Analyze
Open coursework - Browse challenges
Explore role
Strategy Analyst
Frame the business question, model the options, build the recommendation. From market sizing to competitive analysis, this role is where strategy consulting meets in-house decision-making.
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.
Related skill families
Browse all skillsIndustry 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.