Home/Skills
// Skills
Skills you can practice
Prepshotz is built to teach any technical skill through hands-on, graded practice. SQL is live today. Python, JavaScript, Java, C++, C#, plus data and algorithms, are rolling out during the free beta - and you'll be able to describe your own goal and get a tailored track as the engine comes online.
SQL
Query real databases, graded in your browser.
Practice the SQL that interviews and real analytics actually test - SELECT and WHERE, aggregations, HAVING, JOINs, window functions, subqueries and CTEs. You write queries against real datasets and they're graded by running them. Great for data-analyst and data-engineer interview prep.
-- rank products by revenue per category
SELECT category, name,
RANK() OVER (
PARTITION BY category
ORDER BY revenue DESC
) AS rnk
FROM products;// Rolling out during beta
More skills, same loop.
// The engine
Coming: describe your own goal.
Type what you want to get good at - "window functions for a data-analyst interview"
- and get a hands-on, graded track built around exactly that, that adapts as you go.
In development; today you practice curated tracks, starting with SQL.