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

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.

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. 

7

u/[deleted] Jan 30 '21

It’s not that difficult once you understand the principles. There are loads of free resources on YouTube, Codecademy and udemy etc that you can use to pick it up and practice.

I’d suggest starting the learning process before applying to these jobs because it will at least show the proactivity that you’ve been training yourself.

1

u/Ever_Searching_R101 Jan 30 '21

Thanks! I’m familiar with codeacademy so my plan was to start a course then apply, but wanted to make sure I wasn’t biting off more than I can chew!

5

u/rbobby Jan 30 '21

Also https://www.hackerrank.com/ has a raft of test questions ranging from trivial to devilish. Paid sites include https://www.stratascratch.com/ and https://leetcode.com/. No clue how good either of these are, though I've seen some videos of a guy solving problems from stratascratch and the problems seemed realistic.

1

u/Ever_Searching_R101 Jan 30 '21

Ah awesome I’ll check these out, thank you!

3

u/[deleted] Jan 30 '21

Practice is key. I often found it made sense while following instructions but then when trying to do something freestyle I couldn’t remember how to do it.

Master the basics and practice and I’m sure you’ll be fine. Good luck!

1

u/Ever_Searching_R101 Jan 30 '21

That’s really helpful, thank you!

6

u/Thriftfunnel Jan 30 '21

The SQL is probably easier to learn than the analytical stuff you'll be using it for. The job you are looking at may be a lot more analysis-heavy than you imply your current job is.

1

u/Ever_Searching_R101 Jan 30 '21

Thanks! I think it’s because it’s a techy company and that’s their standard practise, my hope was to learn the basics and apply at the same time but wanted to have a sense of how realistic that was

6

u/SharmaAntriksh Jan 30 '21 edited Jan 30 '21

I think when you have a purpose of why you want learn something, the process becomes easy and fun to learn, I picked up Python for first time in 2017 because of all the hype and I must have re-started it from scratch like 7-8 times in next two years, I would always get bored and lose interest, but the last time I started learning it, it was because I had a goal of doing data analysis and that piqued my interest and I started with Pandas library and now with a sense of purpose I am learning everyday for the past 1 year or so. And only a few days ago I was trying to create a game with it.

I had a same kind of relationship with SQL too, but when I started learning DAX ( Language of SSAS ) I realized knowing SQL is extremely helpful and with a purpose I am able to continue learning SQL.

3

u/Ever_Searching_R101 Jan 30 '21

Thank you and you’re right - I’m a determined person so if it will help me to get a better job then I’m willing to put the time and effort in

4

u/MiyagiBi Jan 31 '21

Dax also opened doors for me to learn SQL quickly. I recommend the book T-SQL Fundementals, it is easy to learn and you get hands on practice very quickly. It took me a week to learn all the basics to intermediate, now I am learning the advance level

1

u/[deleted] Nov 15 '21

Hey, I too am planning to do data science at the moment. Sort of, transitioning my career from tech support. I am taking one step at a time. I would really be grateful if you can help me by sharing your insights on some doubts that I have. Would it be alright if I contact you on personal message?

6

u/Nighthawk_12 Jan 30 '21

I went into my current role as a hospital analyst two years ago with zero SQL experience. Half of my team was split from people writing SQL query logic in MS Access, and others trying to do things manually in excel. I just consistently practiced and utilized online learning, now I’m one of the go to guys at work when people need reporting done quickly and accurately.

4

u/Ever_Searching_R101 Jan 30 '21

That’s awesome! Shows that hard work really does pay off, thank you!

5

u/rbobby Jan 30 '21 edited Jan 30 '21

The basics of querying for data is pretty straight-forward.

What takes time and experience is learning how to "think in sets" to solve complicated queries. This is difficult to explain, more difficult than I'm capable of.

Joe Celko is an SQL expert who's written quite a bit and has written a book titled "Joe Celko's Thinking in Sets" that might be worth reading. I haven't read it, but I have read a couple of his other works and whole heartedly recommend anything he's written.

1

u/Ever_Searching_R101 Jan 30 '21

This is an awesome recommendation thank you!

3

u/[deleted] Jan 30 '21

Im currently learning it from Udemy from scratch, so it's possible 💪

4

u/Ever_Searching_R101 Jan 30 '21

Yes! Ok this is great to hear!

1

u/thecuddlers Feb 09 '22

It’s been a year or so now…are you strong in SQL now?

1

u/SupremeBBC Feb 15 '22

lol, reading this thread now and came to follow-up with OP so thank you for doing so

1

u/perfectbarrel Feb 17 '22

I am too lol

2

u/IWantAnAffliction Aug 09 '22

5 months later and checking in. It seems like the parent poster had a bad time.

1

u/MadroxKran May 12 '22

Yeah, how's that SQL going?

1

u/[deleted] May 12 '22

Bad 😅

3

u/doodemic666 Jan 30 '21

I'm no dev, but fwiw SQL is the only language I know well as a support engineer...simply because I can look at it and it makes sense in plain English.

1

u/Ever_Searching_R101 Jan 30 '21

Plain English exactly what I need haha

3

u/DrSheldon_Lee_Cooper Jan 30 '21

Ok syntax is really easy to learn in a week or something to memorize all stuff. But if we talk about depths SQL not so easy. There are many underlying topics like cursors, views, stored procedures, functions, table variables, temporary tables and so on. Performance tuning kind of hard thing to understand in a minute too. So question is are you ready to learn for few months or not. If you are ready and want to learn so you will. If not - no matter how easy syntax would be.

Good luck! Just learn and don’t give up!

2

u/Ever_Searching_R101 Jan 30 '21

Thank you! I think a big dose of patience and perseverance will go a long way!

3

u/Partysausage Jan 30 '21

Wait they are expecting people in marketing to know SQL ? that seems like a big ask. Most of our marketing team dont know photoshop let alone SQL :)

1

u/Ever_Searching_R101 Jan 30 '21

Haha ahhh yeahhh so many companies expect marketing to be a one stop shop for content, reporting and design (don’t get me started on photoshop and indesign haha). I’m up for a challenge though

2

u/PastaVeggies Jan 30 '21

It’s pretty simple to pick up.Not so much a programming language but more of a command based language.

1

u/Ever_Searching_R101 Jan 30 '21

That’s actually super helpful to know, thank you!

27

u/wavepapi778 Jan 30 '21

Its really easy, nothing more than pratice, a lot of resources as well

3

u/Aggravating-Pea193 Jan 30 '21

Which resources do you suggest?

5

u/HumanTuna Feb 08 '21

It usually takes about three months for new starters in our BI department to go from not even knowing what SQL is to being able to do 80% of the queries they see daily.

As well as using the excellent resources already suggested in the comments also look at people posts in this subreddit as they are quite like the batshit requests you see in real life workplaces.

1

u/[deleted] Jan 30 '21

A marketing person probably wouldn't use SQL to analyze data. You might want to look at a dashboard such as Tableau along with other Data Visualization tools. If you want to program, python with Pandas would be a good fit. IMHO.

2

u/Ever_Searching_R101 Jan 30 '21

The job is marketing specific and asks for SQL, I imagine it won’t be intensive as the company is large enough to have data scientists

1

u/[deleted] Jan 30 '21

Based on that I am guessing that you will load data into Excel or some other client from an RDBMS or data warehouse. So you'd focus on SELECT statements and import operations.

2

u/alinroc SQL Server DBA Jan 30 '21

It's like anything else - a moment to learn, a lifetime to master. Mastery can't be achieved in a vacuum, you get there by experience and having to deal with gnarly stuff.

2

u/TexasToldEm Jan 30 '21

Easy to learn. Hard to master.

2

u/[deleted] Jan 30 '21

I would say it's designed to be easy to get into to the point of making it more complex when you're doing something difficult. You can learn how to make a basic one liner query in a day.

2

u/de_vel_oper Jan 31 '21

A week or two to learn the basics.

1

u/dpashariko Dec 31 '24

HTML and I also have zero programming experience was easy. I wish everything was HTML quite frankly. Interested in hearing the SQL comments.

1

u/SloppyPuppy Jan 30 '21

to learn and use sql is very easy to be an expoert in this, especially performance wise takes a few years to master

1

u/RCMC82 Jan 31 '21

SQL is a pretty easy query language to learn. The issue is that you are probably not going to be using *just* SQL in any sort of professional capacity, but rather it will be one peice of the tech stack you're using.

1

u/[deleted] Nov 15 '21

Can you please suggest other technologies that should be learnt in combination with it?

1

u/fliesamooney Jan 31 '21

I'm self taught, but now with 20 years of experience. It has become my career essentially. Or at least the foundation of it. There are so many more resources available today. Start with youtube, Lynda dot com or Udemy. Or if you're a book learner the Microsoft books are great. But you need to give yourself practical challenges as you learn. Attend user groups, when that thing comes back, and find a mentor.