Mini Projects

Apply what you practice. Each project turns a realistic business scenario into a short series of SQL or PySpark tasks, graded by the same engine as regular practice, and ends with a portfolio-ready summary you can copy into a resume or README.

E-commerce Sales Analytics

Report on customers, order activity and revenue for an online store using SQL.

SQL · Beginner · about 70 minutes · 7 required tasks

Skills: INNER and LEFT joins, Anti-joins, GROUP BY aggregates (COUNT, AVG, SUM, MAX), Monthly date grouping, Top-N reporting

Customer Data Cleanup After a Migration

Audit a customer-data migration, remove duplicates and bad values, and keep address history using SQL.

SQL · Intermediate · about 80 minutes · 6 required tasks

Skills: Anti-joins, Duplicate detection with GROUP BY and HAVING, ROW_NUMBER() deduplication, CAST and REGEXP validation, LAG() over history tables

Incremental Customer ETL Pipeline

Fix, enrich and incrementally update a customer table with PySpark DataFrames.

PySpark · Intermediate · about 85 minutes · 5 required tasks

Skills: DataFrame joins, dropDuplicates, Window functions (row_number), Broadcast joins, CDC-style incremental updates

Prefer a single long-form build? See the Log Analysis Dashboard PySpark project.