Any recommendations for learning SQL? Would Youtube/LinkedIn learning be the best method?

likehelpful
Posting as :
works at
You are currently posting as works at

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

Post Photo
helpfullikesmart

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.

like

Danny ma’s serious sql course

likehelpful

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.

like

W3schools and a live SQL DB, with enough leeway in your deliverables to allow you to figure out maximizing the SQL functionality.

like

SQL Murder Mystery

like

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.

Related Posts

How do I pivot from a broker to any job in tech?

like

Hi Guys,

I'm going to join in NatWest group, Chennai as Wow- QA Specialist with Band 7.2.
Actually I have 7.5YOE and my package is decent for my experience. Joining date is on September'22. whether I'm eligible for the current year appraisal and what will be the performance bonus & hike percentage ?
Is promotion possible for my position within 2-3 years ? what are the employee benefits available in NatWest Group ?

Could some one please answer for this ?

Thanks in advance.

I currently work at Fidelity Investments in the call center. I want to move my career towards in person planning at a branch and there isn’t a lot of opportunity here at Fidelity to do that in my area. What are some other good firms to work for? I was looking into Merrill Lynch, Morgan Stanley, Edward Jones, and some others. Thoughts?

like

What books or other resources would you recommend to a beginner plaintiffs PI attorney looking to learn the ropes? Thanks in advance.

like

I am a fairly new corporate counsel for tech company. What does “career progression/growth” mean or look like on average?

like

Are PE/ VC hours for associates / entry level really better than IB? Please respond if your in PE/ VC your honest weekly hours. Curious if it’s worth switching form IB or just changing careers if I can’t take these long hours anymore.

like

Got an offer from Netwest . Grade B7.2 , Fixed CTC offered 20 lacs , , department product control . Could you please let me know what that B7.2 means & how much time it will take to reach to AVP level .

like

How does one move forward in digital marketing roles? I do not have a masters and am facing neglect and being under paid. Is Masters the only way as I do not want to be in debt to have an increase in salary. How do I go ahead?

like

Is it worth it to pursue infrastructure/network administration esque jobs while in college? I am getting stressed seeing not many job openings in my area and the pay is very low compared to programming jobs. As much as I enjoy this side, I’m not sure if it’ll be worth it in the long run. Thanks a lot in advance

Looking for some advice on how to branch off into a job in tech. I’m a Mechanical engineer interested in working in a big tech company. I have some programming experience but excel mostly in mechanical and product design as well as 3D CAD. Was wondering if any other mechanical engineers have managed to make the shift from a traditional mech job to a tech job and if you could give me advice on the best path that worked for you. Thanks!

like

What are the exit opportunities from executive search?

M7 MBA vs M7 JD? Came across the following comment while researching dual JD/MBA. I've always been fascinated with law and represented myself in several small claims suits against medium sized businesses and won, got a big kick out of it.

Post Photo
like

Should you go into PE if you have a girlfriend?

likefunny

What has your experience been switching from on-premise solutions to SaaS software? Any regrets?

like

Hi, how do I start a career PHAMACOVIGILANCE ?
Really hoping for some advice.
Thanks.

like

*Keeping an eye open for new opportunities*
I have my Bachelor's degree in Healthcare Administration along with 13 years of experience in healthcare. My experience ranges from medical coding, biller/AR specialist, patient financial advocate, and since 2019 my role is in the Quality department as a health care data analyst.

like

So I just started at a new company about 5 months ago. I’m already looking to leave. My boss should not be in the director of HR role she in, she does not have the experience for it. She was put into that role because the prior director left and she was the senior most person on the team. I’m also not connecting with anyone on my team. I don’t feel fulfilled or happy here. Should I be leaving so soon? I assume if I do apply to other places, my short tenure here will be a red flag. Thoughts?

like

Can anyone provide some insight as to what exit opportunities there are for someone who practices Securities Lit/Arb? Is it possible to jump from lit to transactional work into a firm doing capital markets, fund formation, or M&A? Thanks in advance!

How to get a roll off from project Where's there's alot of dependency on me as of now but I really don't want to continue due to mental pressure and not much to learn. How can I start and what can be a good reason to get a roll off?

like

I’ve been in my current role for less than a year and within my first 6 months multiple managers left as well as my hiring manager and multiple developers on a team I manage. I was kind of thrown to the wolves which is fine but recently another manager was just hired in the next pay grade who is walking into a much better position. Worst part is my new manager didn’t even know my title wasn’t the next level. When do I bring up that I feel I should be moved to the next level as well?

like

More Posts

Anyone in the suburbs find it harder to make friends compared to the city? I don’t want to move back but I don’t know what else to do..

like

Male 🐠 here. Looking for a casual vest to wear (fleece/down/polyester). Preferably <$100. Any recommendations?

Best casual restaurants in the world?

(Preferably no fine-dine)

like

I’m planning to move to California from the east coast shortly. Any advice for a cross country move?

like

Any open Tax Operations roles that have gone fully remote or 4 day work weeks?

like

Hey all! I’m not sure if this allowed (I’m new to Fishbowl) but I have a lot of Strategic sales roles open for Splunk’s Observability platform. Comment/message if interested

like

PwC folks, any news of any kind of salary adjustment happening soon? The rental market is bonkers right now and I don't know how long I can continue staying here at the current salary

like

I have spent the last two months complaining that the “specialty” bulb in my desk lamp has been burnt out. I was so lazy, I bought a cheap ring light to brighten my face on conference calls rather than searching for a specialty bulb.

Tonight, I was cleaning my office when I discovered the desk lamp was unplugged.

funnylike

What’s a good PCS salary to ask for in NYC for senior? Is 100K too high?

like
like

How is Mastercard(Ekata) as a company in NL ?Work life balance , pay etc?

How has turnover been across the big 4? Seems like a lot of people are leaving.

like

Anyone who can share their experience with the Harvard Extension School?

like

Has anyone experienced burnout from interviewing? I’m extremely exhausted because of the extensive interview processes I’ve been through and I’m not sure what to do. I have 2 big interview rounds coming up for roles I really want but I’ve put so much energy into interviewing for other roles that I can’t even focus and prepare for the upcoming 2. I’m not prepared for the interviews so I’m not sure if I can take a long break but I’m open to literally any suggestions! Thanks!

like

What are exit opps like for government consulting? First year PL and I’ve worked mostly with federal health agencies.

like

Hi fishes,

Any idea on how to contact Capgemini HR for your offer ? I cleared the technical round, had sent them my documents and completed AMCAT test 2 days back. When I was following up on the status the HR with whom I had my salary discussion asked me to contact 2 other HRs. I only have their mail IDs . Now I am clueless about how to proceed . Can anyone help me on this ? Also , is AmCAT an elimination test??? Please guide me through

It has just been a week in my first project, can I raise a performance snapshot?
Please guide?

like

Hello everyone! I am looking for referrals in Scotiabank (specifically Research Consultant). Any leads will be highly appreciated. Thanks in advance.

like

Additional Posts in Data and Analytics in Advertising & Marketing

NYC Analytics outside of advertising and media - broad question, but what areas to look into? What companies / industries have deeper analytical needs? And whats the best way to look?

like

What are some good sources to learn python ?

like

The perfectionist post made me think this is a good place to ask: how do you deal with a manager or team lead who's micromanaging or refusing to delegate? I like my team lead but everything down to the smallest detail has to be checked and rechecked by him and it slows down EVERYONE else. Our team is doing really good work, it's just taking longer than it should and it's frustrating to feel like he doesn't trust our skills at all.

Hey Bowl,

Does anyone have any insights into the role of an analytical lead at Google? I currently manage ad tech products and want to understand more about the role at Google

Would be great to hear your thought on:
1. Moving from Product to Analytical lead role
2. What to expect with the role

like

I need an analytics manager to join my team in Chicago and recruiters have been slacking. If you’re interested shoot me a message.

I’m feeling very burnt out working in analytics at an ad agency but want to stay in the marketing analytics field. Are there any other positions in marketing analytics that offer better work life balance?

like

It's that time...🦃

What's one thing you're super grateful for in your life or career at the moment? Big or small.

Drop it below! 👇

like

Trying to transition from hands-on analytics freelance into advising. What service or field would be best to focus on as an advisor to companies within data?

like

Tips to stay motivated and cut procrastination? I started a new client side job remotely a few months ago at the beginning of covid. I know that I'm extremely lucky to have landed a role during shutdown, but lately my motivation has taken a hit. My entire team of two people is new, and it's definitely been odd to onboard remotely. Things are not as fast paced or as exciting as agency side, but I have also been dragging out tasks due to procrastination and just feeling lost. How can I do better?

like

What do you consider to be "insights"? What makes them meaningful?

I see a lot of other analysts push out insights that feel pretty meh to me, like showing best performing tactics, audiences etc. Was I wrong for expecting there to be more?

like

What do you use Python for at work?

like

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?

like

So, it seems like everything is an “analytics lead” or a “lead” of some sort. It can be 2 years or 10 years of experience, sometimes both at the same company. What are your thoughts?

like

Currently working as an Analyst.
Looking for a Analyst position within Amazon, Deloitte or KPMG
Looking for referral from Amazon, Delotti or KPMG

like

I recently completed the Google Data Analytics Certificate. I saw a tip about getting projects on your resume that you can talk about in interviews. How did you go about finding projects to practice your skills? What was one of the first projects you took on early in your data analytics career?

like

Industry benchmarks: what is your go to source for benchmarks for stuff like brand awareness, ad recall, brand lift etc?