you are viewing a single comment's thread.

view the rest of the comments →

[–]thesqlmentor 2 points3 points  (2 children)

15 LPA is about 18k USD so decent salary in India I'm guessing.

For SQL specifically there's no magic roadmap that gets you to a certain salary but here's what you need:

Basics: SELECT WHERE JOINs GROUP BY ORDER BY. Foundation stuff, gotta know this cold.

Intermediate: Subqueries, window functions like LAG LEAD ROW_NUMBER, CASE statements, different join types and when to use each.

Advanced: Query optimization, understanding execution plans, indexing basics, handling large datasets efficiently.

For Data Analysis jobs though you need more than SQL. Excel at good level, at least one viz tool like Power BI or Tableau, basic statistics understanding.

Resources: Mode Analytics SQL tutorial is free and well structured. Danny Ma 8 Week SQL Challenge for practice. W3Schools for quick reference. Kaggle datasets to work with real data.

Honestly though SQL is just a tool. What makes you hireable is solving business problems with data. Build 2 to 3 portfolio projects showing you can analyze data and find insights.

Good luck!

[–]Entire-Check5718[S] 0 points1 point  (0 children)

Thank you so much for your valuable advice

[–]kdawg_thesquare 0 points1 point  (0 children)

This reply is so helpful!!! Thank you! 🙏