Majority of top companies hiring for analytic roles (Data Analyst/Business Analyst) focus heavily on SQL understanding as a selection criteria, which according to me, should be the first thing you start your preparation with.

I have divided this SQL roadmap into 3 steps (Basics, Level Up & Practice), and it should take around 1 month to complete.

Step 1 - Basics 🔢 :

➡What is a Relational Database / RDBMS?
➡SQL Data Types - Varchar, text, int, number, date, float, boolean.
➡SQL commands - select, where, like, distinct, between, group by, having, order by, insert into, case when, update, truncate, delete, commit, rollback (basically all the DDL, DML, DCL, TCL commands in SQL).
➡Integrity Constraints - Primary key, foreign key, not null, unique.
➡Operators arithmetic, logical, and comparison operations.
➡Use of distinct, order by, limit, and top.
➡Use of union and union all.
➡Joins in SQL inner, left, right, outer, self, full outer, cross join.


Step 2 - Level up ⬆⬆ :

➡Normalization in SQL
➡Aggregate, date, and string functions
➡Sub-Queries
➡CTE table / with clause
➡In-built SQL functions
➡Window functions
➡Views


Step 3 - Practice SQL Questions on leetcode & hackerrank ✅

Hope it helps :)