Related Posts
How do I pivot from a broker to any job in tech?
Should you go into PE if you have a girlfriend?
More Posts
Additional Posts in Data and Analytics in Advertising & Marketing
What are some good sources to learn python ?
What do you use Python for at work?
Just recieved a offer from Western Alliance Bank for a Senior Business Analyst role. Comp 100k but the role would be in office. I currently work remote,have unlimited PTO,and a really healthy work life balance but am being underpaid tremendously. The new role seems like it does not have healthy work life balance and many red flags have already come up. I want to grow my skills and wouldn't mind being in office as I do miss being around people. How do I vet the role before accepting?
You can take a LinkedIn Learning course to understand the concept and then there are SQL practice quizzes online that come with solutions. Or you can take Data Camp courses that should let you practice as you learn!
Also I always have this as a little cheatsheet whenever I help my team troubleshoot their queries
Subject Expert
Agreed. It takes years and real-life practice.
I’m still learning SQL too.
It’s ironic: I’m good with python because i frequently use it to automate my workload. For SQL, I don’t actually have a database to work with on a daily basis. If we do, my company hires someone more junior and makes me focus on what I’m good at.
So while most job postings advertise SQL as must-have and python as nice-to-have, my skill set is reversing that order.
Subject Expert
Danny ma’s serious sql course
Danny Ma and Alex the Analyst. I'd also do daily exercises on Stratascratch or Leetcode. Stick to this regiment and you'll be solid.
W3schools and a live SQL DB, with enough leeway in your deliverables to allow you to figure out maximizing the SQL functionality.
SQL Murder Mystery
Mode
Into to SQL on Udacity is a really good one ( and it’s free). It covers all the foundational topics with good amount of practice.