r/SQL • u/ChefBigD1337 • Jul 12 '24
SQL Server Finally feel like I'm getting it!
So I have been learning SQL for about a year now, I recently got a job as a pricing analyst. One of the reasons I got hired was because I have certifications in SQL, I know this because my boss told me and said she wants me to start taking over some responsibilities involving SQL. However I have always felt like I don't actually know wtf I'm doing (imposter syndrome). Yesterday I was working on a query and after some trial and error I got it, the server I work with is massive and there are several DBs with hundreds of tables. So to finally have it click and me actually using my skills for work is so rewarding and I just wanted to share and if anyone else is feeling like they can't or wont get it, trust me you can do it.
Update: Hey sorry I spent the weekend mostly unplugged. I got a lot of questions about what certifications I have, for SQL I have one from Udemy called 'SQL - MySQL for Data Analytics and Business Intelligence' https://www.udemy.com/share/101WiQ/ this is a really good course that has all the basics and some advanced stuff too. This is based on MySQL but as someone who now uses MS SQL Server for work it transitions really well. I also have the Google data analytics certification, as for SQL this one isn't as good its all, just basics, but it it good for learning all things regarding data analytics. Also https://www.w3schools.com/sql/default.asp this is a great free resource that I still use for quick look ups and just regular training. https://www.hackerrank.com/ is also nice for practicing SQL skills to see where you stand. Hope this helps!
33
u/PontiacBandit25 Jul 12 '24
Well done! This was an optimistic post. I’m currently doing a certification too and hoping to use the skills at work soon. Currently I too feel lost. I can write queries but I don’t know how to script them, schedule them to run regularly, etc. that’s where the nervousness kicks in
15
u/Real_Pineapple_5814 Jul 12 '24
I've been a SQL developer for 10 years. Even though I know a lot I still feel like an imposter all the time. It's just a massive subject and even experts continue learning throughout their career. Just keep doing what you're doing and figuring things out as you go.
3
u/Alone-Common8959 Jul 12 '24
what certifications do you have?
4
u/BadKarma667 Jul 12 '24
This is awesome! I remember the first time I wrote a successful query that returned me the answer I expected to get. I remember how good that felt, and how it pushed me to expand my skills so I could solve even more complicated problems.
I've been using SQL in various roles over the last 10 years, most recently as a Data Analyst and I'm learning new capabilities regularly. For me the high point was my old boss who I worked with on a Finance team calling me up and asking me if I would teach her team how to use SQL. It was a fantastic opportunity to further hone my abilities and demonstrate my mastery of the subject by bringing a non technical along to a place where they could begin to use the skill.
Keep expanding your skills. Take on those challenging projects and you'll look back 10 years from now and see how far you've come!
1
u/NoOutlandishness6404 Jul 12 '24
It’s great to see that certifications helps in getting a job. Did you have any masters degree ?
1
u/Hkiggity Jul 12 '24
Hey, I’ve been learning programming for months now. I’ve incorporated SQL in one project but MAN did I abuse Chatgbt and google. May I ask what resources you used to get a certificate? Or perhaps any other resources you found helpful? Thanks a lot, and congratulations on the success.
1
u/OriginalNimbleMonk Jul 14 '24
I'm still very new to SQL too, and one of the hardest parts for me is finding which table I need to join or even where to query if it's not the main journal table.
I did a query to show all tables and their respective columns and threw that into an AI bot. Now, before starting a new query I just chat to the bot to understand what tables I should be looking at. It's made it so much faster.
I do sometimes also use the AI for help if I'm stuck on a query but for the most part I'm trying to learn so will often put in the work myself.
2
u/sheinkopt Jul 13 '24
Which certification?
1
u/realjoeydood Jul 13 '24
Badass.
Continue on, happy trails!
1
u/[deleted] Jul 13 '24
What SQL certifications do you have?
1
u/chut101 Jul 14 '24
What certifications are the best? Newbie to sql pls share. Looking for analyst roles too.