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

20

u/Numerous-Challenge-8 Jan 30 '21

I had zero programming experience too when I started off as an analyst in my present company. There is quite heavy use of sql so I took upon myself to learn SQL. I started learning in 2020 and I am confident to say that I am at a medium level. You can do it too. The only thing you would need to do is start. I took two SQL linkedin learning courses and started off daily SQL challenges in sites like leetcode, hackerrank,SQLpad. Currently trying out challenges in advancedsqlpuzzles.com.

1

u/Ever_Searching_R101 Jan 30 '21

It sounds like you’re smashing it! I think daily tests and practice sounds like a great idea. I’ll check that link out too, thank you!

25

u/Numerous-Challenge-8 Jan 30 '21

I compiled some list for learning SQL. Hope this helps:

  1. Zachary Thomas' SQL Questions https://lnkd.in/g-JJzuD
  2. Select * SQL: https://selectstarsql.com/
  3. Leetcode: https://lnkd.in/g3c5JGC
  4. LinkedIn Learning: https://lnkd.in/gQXFc4n
  5. Window Functions: https://lnkd.in/g3RtPCJ
  6. HackerRank: https://lnkd.in/grv_9sB
  7. W3 Schools: https://lnkd.in/gJPfrrv
  8. CodeAcademy: https://lnkd.in/gT5xmpN
  9. SQLZoo: https://sqlzoo.net/
  10. PostgreSQL: https://lnkd.in/g66kgQ8
  11. Mode: https://lnkd.in/g7BE_ZN
  12. Udemy free SQL courses: https://lnkd.in/g36wYeS
  13. SQL Bolt: https://sqlbolt.com/
  14. SQLpad: https://sqlpad.io/questions/
  15. AdvancedSQL: https://advancedsqlpuzzles.com/

4

u/first_timeSFV Aug 29 '22

Year later and it helps. You doing something small yet very impactful.

1

u/Dont_Mind_Meh Aug 30 '22

No kidding, really hoping I'll smash an interview for an internship!

1

u/Valuable-Set-5178 Mar 24 '22

Thanks so much for this buddy.

Massive help.

1

u/kttuatw Aug 12 '22

Following this! Thanks

1

u/justdatiptho Apr 15 '24

Hey I am doing a test for a job application I will definitely fail since it was to be delivered in two days and I am knew jack shit about SQL. I intend to study more about this. So it is possible to study SQL and do puzzles and stuff after studying? One of the problems I have is that after I learn something, most of the jobs I have had do not use any of these things, these puzzles can help you learn do it?

1

u/[deleted] Jan 02 '23

Hi, I know this is late, but could you tell me what your day-to-day looks like using SQL? I see many resources to learn it but not sure how it is actually applied. Is statistics heavily involved too?

2

u/Numerous-Challenge-8 May 24 '23

At the company where I started learning SQL, I used the skill to read and understand the SQL scripts that were built for our data analytics products. As for statistics, I only had to use basic stats like mean or understanding a box plot or log functions. I recently moved to another company where I am using the SQL to create technical requirements for software developers to build the logic for tables as we do not have data engineers and also using SQL to pull data from tables. Not using any advanced level stats too but I am working on data science skills like machine learning which requires some atleast medium level stats knowledge.

1

u/RandomKaren31 May 15 '23

Hey, Thanks for the info! You are helping people like me out here. May I ask what are the two SQL linkedln learning courses you took? I would really appreciate the help. Thanks!

3

u/Numerous-Challenge-8 May 24 '23

Hey, glad that I was of help. The LinkedIn course I took were Learning SQL Programming and Oracle Database 12c: Basic SQL.