Practice Topics
- Adaptive Query Execution — 1 challenge
- Aggregation — 39 challenges
- Basics — 2 challenges
- Broadcast Join Optimisation — 1 challenge
- CASE WHEN Pivoting — 2 challenges
- CTEs — 1 challenge
- DAU / WAU / MAU Metrics — 2 challenges
- Data Quality Validation — 1 challenge
- Data Structures — 2 challenges
- Data Validation Pipeline — 2 challenges
- DataFrame Basics — 4 challenges
- DataFrame Deduplication — 1 challenge
- DataFrame Operations — 5 challenges
- Date Functions — 4 challenges
- Deduplication with ROW_NUMBER — 3 challenges
- Delta Lake MERGE / SCD Type 1 — 1 challenge
- Delta Lake MERGE / SCD Type 2 — 1 challenge
- Dictionary and Counter — 2 challenges
- Explode Nested JSON Arrays — 1 challenge
- Filtering — 3 challenges
- Funnel Analysis — 1 challenge
- Gap and Island Problems — 1 challenge
- GroupBy Aggregations — 4 challenges
- Heap / Priority Queue — 2 challenges
- Incremental Load with CDC — 1 challenge
- Incremental Processing — 1 challenge
- JSON Manipulation — 1 challenge
- JSON Processing — 1 challenge
- Joins — 34 challenges
- LRU Cache — 1 challenge
- Null Handling and Data Cleaning — 1 challenge
- Pandas GroupBy Aggregation — 1 challenge
- Performance — 1 challenge
- Performance Optimization — 1 challenge
- Pivot and Unpivot DataFrames — 1 challenge
- PySpark SQL Optimisation — 1 challenge
- Regular Expressions — 1 challenge
- Rules Engine — 1 challenge
- SCD Type 2 — 1 challenge
- Schema Evolution — 1 challenge
- Session Analysis — 1 challenge
- Sliding Window — 2 challenges
- Sorting with Custom Comparators — 1 challenge
- String Processing — 3 challenges
- Strings — 1 challenge
- Structured Streaming — 1 challenge
- Subqueries — 1 challenge
- Subquery — 1 challenge
- Subquery vs CTE Patterns — 2 challenges
- Window Functions — 80 challenges