SQL – CRUD, DDL vs DML, OLTP vs OLAP, UNION vs UNION ALL, datatype conversions, joins, subqueries, group by, order by, aggregate/CASE queries.how to reduce expensive DB calls .
Python/Java – data structures (list/tuple/set/dict), list ops, functions, DB operations, OOPs,JWT/session management
System Design – movie DB schema (tables & relationships).
data engineering concepts, tools, downtime reduction. LLMs basics, prompt design, ChatGPT usage,
Overall: A mix of coding, theoretical, and conceptual questions with strong emphasis on SQL and databases.