SQL + PySpark Practice Lab: Scenarios & Solutions with Kadiyala Ajay

I built DataGeeks Practice Lab to help you practise the decisions that change a query's result. Each scenario

gives you a business problem, input data, and clear output rules.

You write the SQL or PySpark answer, run the checks, and compare your reasoning with the complete

solution.

• Deduplicate order updates with deterministic tie-breaking.

• Calculate customer revenue after refunds without join fanout.

• Find consecutive login streaks across calendar boundaries.

• Process late-arriving sales and check safe reruns.

• Reconcile source and target tables, including duplicates and nulls.

Your download: five practice notebooks, five solution notebooks, 17 fixture cases, input and expected-output

CSVs, explanations, follow-up questions with discussion answers, scorecards, a progress tracker, and the

illustrated START_HERE guide.

Each notebook includes its own small synthetic datasets. Use a compatible Databricks Python notebook or

local Spark. SQL uses the Spark SQL dialect. Reference execution was checked with PySpark 4.0.1, Python 3.12,

and Java 17.

Best for learners who know basic SQL and Python. This is a personal-learning download. Videos, live

mentoring, certification, and job placement are not included.