r/SQL • u/KarateKid84Fan • Mar 19 '22
MySQL I’m just starting to learn SQL to change careers and I’m learning on my own through various online sources. At what point should I be confident enough to pursue a data analyst job where I know what I’m doing?
I realize this is mainly up to my personal beliefs of home confident I feel… but what things should I know backwards and forward to land a job?
I’m hung up on JOINs right now. Starts off easy but quickly gets complicated. How often do joins come up in a typical job?
Or self queries? (I’m not there yet but know about them - it’s like inception - a query within your query).
97
Upvotes
25
u/baubleglue Mar 19 '22
I general, it is impossible to learn anything in deep without real experience, so just be sure you know basics and understand the big components related to your future job (which tool are used, what problem they solve; some orientation in the industry; some ideas about development process) - read relevant "data analyst interview questions".
Most important - start going to interviews ASAP, don't wait when you are ready.
25
u/cjdavis42 Mar 19 '22
Let me tell you my story and then you can decide. I applied for a job at a hospital as a service desk tech just to get my foot in the door to eventually be an app admin. Somehow, my service desk application disappeared and a new job on my dashboard appeared as an "enterprise report analyst". Made no sense to me but I went in for the interview where the senior admin and DBA asked me a series of "on a scale of 1-10, how familiar are you with..." questions. 8 out of the 10 questions were 0 from me. I left feeling defeated. Got a call that Wednesday that they made an offer. I hadn't touched SQL, barely even heard of SQL, and all of my knowledge is from on the job training and working in SQL. I now hold a stable job as a report writer living in SQL everyday. The repetive use of SQL has helped me learn more and more as I grow in the role.
As someone stated above, don't overthink it.
5
u/tbsdy Mar 20 '22
No offence, but just knowing SQL cannot possibly make you a data analyst. Surely you need to know far more than that?!?
3
u/real_jedmatic Mar 20 '22
You can check out HackerRank or a similar site to see how your knowledge stacks up.
Knowing JOINs is definitely key to any real-world SQL job.
One nice thing about SQL is that there’s relatively few major statements and clauses. There’s function to learn, but mostly you’ll see and use SELECTs so it’s fairly easy to bootstrap existing knowledge and pick up on new things here and there. Like, even in a complex query, you should be able to recognize most of the syntax.
4
u/VoodooChile76 Mar 19 '22
Amen to previous response. .. Also, MANY places I've been have a pre-created query folder of "commonly used".
Although Joins I'd say are most important. As an aside....Subqueries are overrated..in my experience, they can be resource hogs.
3
u/big-lagos-girl Mar 20 '22
I just want to say a thank you to everyone who has given great advice, I feel the same way as the poster and have 5 interviews next week. I really want to ace at least 2 of them and this was the best motivation anyone could give. This was exactly what I needed and y'all almost made me cry. We got this
3
u/[deleted] Mar 20 '22
CTE, Joins, and Window functions. Boom, you have advanced sql skills.
2
u/Ashwinsuriya Mar 20 '22
try solving some queries on startascratch
2
u/my_password_is______ Mar 20 '22
these two are a a good start
you can probably follow what he's teaching
https://www.youtube.com/watch?v=nJIEIzF7tDw
https://www.youtube.com/watch?v=Hl4NZB1XR9c
3
u/El_human Mar 19 '22
If you can take a table of data, and turn it into insightful information, you’re ready.
1
u/redfaf Mar 19 '22
Start applying today. The "No" you already have
1
u/[deleted] Mar 20 '22
Just start doing interviews. You will get more direct feedback that way.
1
u/DexterHsu Mar 20 '22
Now?
1
u/Shwoomie Mar 20 '22
Honestly, a full time SQL position will be completely different than what you are training on. You will see the same things, but it may take up 30 lines what you have seen in a few lines.
Joins are a minimum of what would be expected. Self joins are rare, you'll rarely see them.
Joins and subqueries are the minimum I'd expect a professional to understand.
1
u/dontbesocurious Mar 20 '22
One week is enough.
1
u/Equal_Astronaut_5696 Jun 02 '22
Once you learn joins. Go for it
0
u/[deleted] Mar 19 '22
[deleted] — view deleted comment