SQL & Databases
Asked in analyst, backend, BA and data engineering interviews alike. Joins, aggregation, window functions and the normalisation questions that always appear.
6 questions 14 min read 36.4K candidates preparing
Before you sit for this round
- Be able to write a query on a whiteboard without autocomplete
- Know the difference between WHERE and HAVING cold
- Practise window functions — they separate mid from junior
- Prepare one story about a query you optimised
Questions & model answers
More technical topics
Data Structures & Algorithms
The screening round most product companies start with. Arrays, hashing, trees and complexity analysis, with the patterns that repeat across question sets.
6 questions
Frontend & React
Rendering behaviour, hooks, state management and performance — the questions that separate someone who used React from someone who understands it.
5 questions
System Design Basics
For 3+ years of experience. Scaling, caching, databases and queues — the vocabulary and the structure to walk through an open-ended design.
5 questions