Home/Skills
// Skills
Skills you can practice
Prepshotz teaches technical skills through hands-on, graded practice. SQL, Python, JavaScript and TypeScript are live today: core language work in all four, data analysis in SQL and Python, algorithms and data structures in Python, JavaScript and TypeScript. You can also describe your own goal to get a track built around exactly that. Java, C++ and C# are not available yet.
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;// The rest of the catalog
More skills, same loop.
The classics in Python, JavaScript or TypeScript, graded by tests.
Start practicing →Not available yet. Core languages for interviews and coursework.
// The engine
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. This is live today.
Each account can build 5 of these tracks while we are in beta, and a track cannot be deleted afterwards, so pick your goals with care. The curated ladders above are unlimited.