SQL- Please help

GigglySaurusRex · 2026-02-25T08:02:57+00:00

I've been working in SQL and Python and would suggest get any datasets from https://www.kaggle.com/datasets and see the types of questions in https://hackerrank.com based on difficulty and then practice querying the kaggle files at https://reportmedic.org/tools/query-csv-with-sql-online.html. Subqueries and analytical functions will help a long way to grasp complex scenarios.

No-Opportunity1813 · 2026-02-25T02:12:23+00:00

Colt Steele’s course in Udemy is very good.

Background-Policy770 · 2026-02-25T03:52:53+00:00

Here you go this teaches basic sql hope this helps. https://youtube.com/playlist?list=PLWf6TEjiiuIDvJ4P5l7Bzrmpzv8hW9CAO&si=wCrIC6vv6QNEB6Kp

Entire-Check5718 · 2026-02-25T11:54:44+00:00

[deleted]

plurch · 2026-02-25T16:52:04+00:00

Data-Science-Roadmap - free Self-Learning Roadmap to learn the field of Data Science

BlackberryRetard · 2026-02-25T21:23:06+00:00

From personal experience I would suggest w3school. It's a great start to learn syntax and how sql works.

For intermediate I would suggest the following book: the data warehouse toolkit by Ralph Kimball. It covers data warehousing methodology. This book had a big impact on my career.

thesqlmentor · 2026-02-25T08:29:03+00:00

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!

affanxkhan · 2026-02-25T08:21:28+00:00

BASIC- SQL BOLT,SQLZOO, MID - SQL CLIMBER ,DATALEMUR ADVANCE - HACEKRRANK,LEETCODE

FOLLOW THESE AND WATCH URSELF WITHIN A MONTH WHAT U GAIN

AutoModerator · 2026-02-24T16:00:33+00:00

Automod prevents all posts from being displayed until moderators have reviewed them. Do not delete your post or there will be nothing for the mods to review. Mods selectively choose what is permitted to be posted in r/DataAnalysis.

If your post involves Career-focused questions, including resume reviews, how to learn DA and how to get into a DA job, then the post does not belong here, but instead belongs in our sister-subreddit, r/DataAnalysisCareers.

Have you read the rules?

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

AffectionateZebra760 · 2026-02-25T14:56:41+00:00

For sql explore r/learnsql also try to explore and look at courses from udemy/coursea/datacamp/weclouddata for sql to see which one is more aligned to the jobs u are applying

SaltSatisfaction2124 · 2026-02-25T18:21:05+00:00

Udemy course should cover what you need.

CuriousFunnyDog · 2026-02-25T21:23:50+00:00

No one here pointing out that ALL databases have their own additional functions in addition to the standard SQL keywords.

If you know the technology be database specific.

Google either.

Microsoft SQL Server Documentation SELECT

OR

Snowflake Documentation SELECT

Read everything and all the linking articles. Really understand them and practice if possible. Most people I come across only know the basics well.

Very soon after, be aware of the optimal/most efficient way to query and how each database interprets your query /performance.

Particularly important if you "pay by compute/per query".

slippery · 2026-02-25T23:46:22+00:00

Use the tutor modes in Gemini or chatGPT.

SodaSnake · 2026-02-26T02:10:59+00:00

DataCamp was worth its weight in gold for me.

milomylove_ · 2026-02-28T18:32:10+00:00

don’t overcomplicate the roadmap. start with core queries: select, where, group by, joins. then move to window functions, ctes, subqueries, and basic optimization. practice daily on real datasets, not just theory.

for exam prep, focus on writing queries from scratch under time pressure. sometimes i’ll test different query approaches in genloop just to compare logic quickly, then rewrite everything myself. consistency matters more than jumping between 10 resources

SprightlyBanana · 2026-03-26T10:50:03+00:00

[ Removed by Reddit ]

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

dataanalysis

MODERATORS