SQL remains the #1 skill tested in Data Analyst interviews. Expect questions on JOINs, GROUP BY, subqueries, window functions (ROW_NUMBER, RANK), and CTEs.
Practice writing queries for real scenarios: top N customers by revenue, month-over-month growth, cohort analysis, and duplicate detection.
Interviewers also test optimization basics — indexes, EXPLAIN plans, and when to use temp tables vs subqueries.
Velora's SQL for Analytics course covers interview-focused SQL with business case studies used in actual hiring rounds.