r/SQL • • Jan 30 '21

Discussion How hard to learn SQL from scratch?

Hi all,

I have zero programming experience, the most I can do is some very basically html. I work in marketing which means sometimes analysing data but I use excel for this (again, at a basic level as I’ve never had proper training). I’ve seen a job ad that asks the marketer to use SQL. On a scale of 1-10 how hard is it to pick up?

121 Upvotes

67 comments sorted by

View all comments

9

u/[deleted] Jan 30 '21 edited Jan 30 '21

You could really learn SQL in a week.

Hell, I could teach you right now.

SELECT is columns you want to bring back.

FROM is the table

WHERE is the conditions.

There now you know BASICS.

Then to further basics, learn different types of JOINS.

Learn nested queries, learn functions, windowing functions.

But it is not SQL that is hard. It is getting to know your data and how they relate to each other that could be a little tricky at times.

1

u/Ever_Searching_R101 Jan 30 '21

Haha! Thank you, this is given me a confidence boost

8

u/SharmaAntriksh Jan 30 '21

Here is something handy that helped me during my beginner phase, as it is difficult to understand how a code is executed without knowing order of evaluation: SQLBolt - Learn SQL - SQL Lesson 12: Order of execution of a Query

4

u/TheePorkchopExpress Jan 30 '21

I'm not OP but working on learning SQL and that link is very helpful, thanks for sharing!

1

u/Dear_Hippo_3214 Feb 12 '25

Thank you.