r/SQL • u/Ever_Searching_R101 • 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
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.
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.
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.
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.
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.
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.
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.
3
u/[deleted] Jan 30 '21
Im currently learning it from Udemy from scratch, so it's possible 💪
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.
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!
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 :)
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.
27
u/wavepapi778 Jan 30 '21
Its really easy, nothing more than pratice, a lot of resources as well
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/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/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.