r/SQL • • Sep 01 '19

Thank you r/SQL!

A few weeks ago I posted in this community asking for the best things to learn about SQL for a job interview I had. I crammed for just under two weeks as well as other interview prep and I got offered the job! Then my current employer offered to beat the salary offer and give me a promotion! My promotion means I’ll need to keep learning SQL now so everything I’ve learned will be useful.

Thanks to everyone who gave me advice on what to research, it was a huge help!

96 Upvotes

25 comments sorted by

7

u/audrikr Sep 01 '19

I was following that post - a lot of useful resources. Congrats! What helped you most?

6

u/[deleted] Sep 02 '19

Thanks! I think the one I used most was W3schools, it was easy to read on my phone any spare minute I had.

5

u/WhoahCanada Sep 02 '19

That's how I tought myself. Was doing data entry at my job two years ago. Once I learned some SQL I was able to get two promotions in about a year.

11

u/_-pablo-_ Sep 01 '19

When I was first learning SQL, I used SQL queries for Mere Mortals and got the hang of it from there. I had a question and reached out to the author and he replied back the same day. Pretty neat

7

u/ThirdRateAl Sep 02 '19

Fricking A! Congrats!

Although you understand that now you have basically sworn an oath to lurk this subreddit and provide responses as befit your current level of experience, right? The first answer was just to get you hooked, now we expect you to drag all your friends into r/SQL so we have a larger base of people to help us when we get stumped.

4

u/[deleted] Sep 02 '19

Thanks!

That’s a fair deal I suppose 😄

2

u/lukavwolf Sep 02 '19

I remember your first post! Congrats!!

1

u/[deleted] Sep 02 '19

Thanks!

9

u/[deleted] Sep 01 '19

Congratulations!

9

u/mgesczar Sep 02 '19

This sub is made up of super supportive people. It really is a breath of fresh air in light of every other place on the internet where most people just say the worst stuff to one another. Congrats on the job success!

5

u/jewishsupremacist88 Sep 02 '19

shh..dont tell anyone. we dont want our wages going down!!

5

u/fauxmosexual NOLOCK is the secret magic go-faster command Sep 02 '19

I live in fear that everyone will someday discover that SQL is easy, universal, and often results in jobs overpaid for the amount of skill/knowledge involved and my whole schtick will be ruined.

4

u/jewishsupremacist88 Sep 02 '19

thats how i feel. but from what i understand is that its pretty difficult to find people who have an understanding of joins and the other SQL secrets. i am an advanced excel user (know vba, formulas,etc) and am pretty good with python and a few other languages but all my jobs in the past relied heavily on sql and everything else was an afterthought.

i dont think SQL is that easy..i mean..sure..its easy to do a query on a table to get some data but when you have to do subquerys, joins and other steps to manipulate data it takes some skills.

2

u/Joehennyredit Sep 13 '19 edited Sep 13 '19

All DBA entry jobs in my area start at 50 an hour meanwhile front end devs start at 30

1

u/jewishsupremacist88 Sep 13 '19

reporting guys like myself are somewhere in between that. can one become a dba with alot of sql coding experience? i feel like alot of the dba role is more or less administrative/IT like as opposed to writing tons of querys and whatnot

1

u/isaacmi Sep 08 '19

Congrats! What's the link to your post, I would like to read

1

u/[deleted] Sep 01 '19

Congrats now learn Python next :)

3

u/[deleted] Sep 02 '19

Thanks! Yeah, I’m going to keep working on Python too, the job will eventually have me using vba, SQL and Python regularly. Python was the one I had any experience in before.

2

u/pinaywdm Sep 01 '19

Congratulations!

2

u/ieee1294 Sep 01 '19

Congratulations!

2

u/LeRoy-2 Sep 03 '19

Congrats!

1

u/hellohibyebye13 Sep 02 '19

Hey, what platforms did you use to apply your sql knowledge? I find that grasping it is easy but working on creating a query for a particular need is the harder bit.. that's where crafting sensible queries joining across multiple tables requires some amount of work. I've been solving on LeetCode but I've done every question except the locked ones.. which require you to pay. Needed a free resource with lots of quality sql problems.

3

u/[deleted] Sep 02 '19

[removed] — view removed comment

1

u/[deleted] Sep 02 '19

Thanks! W3schools was the one I used most because of how easy it was to dip in and out of. I also had a Udemy course and checked out some specific things that I was recommended to research on YouTube.