SQL queries, JOINs, indexing, ACID properties, window functions, and DBMS interview concepts.
INNER, LEFT, RIGHT, FULL OUTER joins and GROUP BY queries.