DataDesk
Live projects · Hands-on practice · AI-powered feedback

Real practice. Live projects. Job-ready skills.

Learn tech skills by doing: practise each concept with instant checking, then apply it to live projects built on realistic industry data. Starting with SQL, Python and Data Analytics — with AI and more tracks on the way.

  • 1690+ practice questions
  • Instant answer checking
  • Runs in your browser
  • Live industry projects
Practice · Window functions · Question 6
Intermediate

Top earner in each department

Return the highest-paid employee of every department. Include ties.

answer.sql Submit
SELECT dept_id, first_name, salary
FROM employees
QUALIFY RANK() OVER (
  PARTITION BY dept_id ORDER BY salary DESC) = 1;
Correct! All rows match.+10 XP

How it works

A clear path from practice to live projects

Learn a concept, practise it until it sticks, then apply it to a real business problem.

  1. Step 1

    Practise one concept at a time

    1690 short SQL and Python questions, organised by topic and level. Each answer is checked instantly.

    Start practising
  2. Step 2

    Solve guided projects

    12 real-world business problems with messy data. Work through them with hints and detailed feedback.

    Browse guided projects
  3. Step 3

    Deliver live industry projects

    Multi-day projects with a full Business Requirement Document, industry-style datasets and a portfolio-ready report.

    Explore live projects

Get started

Where should you begin?

Pick the option that describes you best.

Feedback that teaches

Know exactly what to fix — without being handed the answer

Hints point you in the right direction in plain English. Project reports receive a detailed review covering your result, your data cleaning, your insight and your recommendation.

  • Instant checking for every practice question
  • Three levels of hints that never write code for you
  • Detailed project reviews with scores for each criterion
  • Solutions unlock after you solve a question or make three attempts

Hint · level 1

Before you average the waiting times, consider which visits should not be counted at all.

Project review

82 / 100
  • Correct result90
  • Data cleaning85
  • Business insight75
  • Recommendation78

Strong cleaning of duplicate visits. Next step: quantify the change in minutes and name the two departments driving it.

Current track: Data Analytics

Skills employers look for, built through practice

Our first track covers everything an entry-level data analyst needs. AI and more tracks are coming next.

SQL

From CREATE TABLE and constraints to joins, CTEs, window functions and date logic.

Python for analysis

Strings, lists and dictionaries through to NumPy and pandas cleaning, grouping and merging.

Spreadsheet thinking

Pivot tables, sorting, filtering and sanity checks on every result.

Data cleaning

Duplicates, missing values, inconsistent spellings, outliers and mixed date formats.

Business metrics

Revenue, retention, conversion and cohort metrics, defined and calculated correctly.

Communicating insights

Clear findings and recommendations that a decision-maker can act on.

Live projects

Projects built around real industries

Each project comes with a complete Business Requirement Document, original industry-style data and 50 checked tasks — solved right here in your browser. The first project in every domain is free.

For trainers and colleges

Run hands-on labs and live projects for your batch

Create a batch, share a join code and follow every student's progress — including the mistakes your batch makes most often, so each class targets what students actually need.

Set up a batch
  • Batches and join codes

    Invite students by email or a six-letter code.

  • Progress per student

    Scores, attempts and skill levels at a glance.

  • Common mistakes

    See where your batch needs more practice.

  • Shareable portfolios

    Every student gets a public project page.

Pricing

Start free, upgrade when you are ready

Simple, student-friendly pricing in rupees.

Free

Everything you need to get started. No card needed.

₹0forever

  • Basic practice questions in every SQL and Python topic
  • 3 complete projects, including a 15-minute starter
  • SQL and Python workspace in your browser
  • Detailed feedback on every project report
  • Public portfolio page
Most popular

Pro

Every question and project, from beginner to advanced.

₹299per month

  • All practice questions, including interview sets
  • All projects across 8 industries, with new ones every month
  • Three-level hints and detailed project reviews
  • Skill meter, badges and streaks
  • Cancel any time

Colleges & trainers

Run hands-on labs and live projects for your students.

Customper batch

  • Trainer dashboard with batch analytics
  • Invite by email or join code
  • Most common mistakes across your batch
  • Pro access for every student

FAQ

Frequently asked questions

Start building real skills today

Free to start. Nothing to install. Your first question takes less than five minutes.

Create a free account