What is the best most efficient way to learn SQL when my current role does not call for it? I want to transition into data analysis but it calls for SQL experience.

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

Build project: All you need is a 2-8hr course on YouTube or Udemy, a small idea like World Cup DB or DC/Marvel characters DB or Pokemon DBs or whatever, and discipline(30m+ per day for about 4-8 weeks). You could also use FreeCodeCamp's relational db program.

You won't learn much in the grand scheme RDBs. Just like everything else, real learning happens at work or while working on projects that are demanding. You will learn enough to get the ball rolling toward a future as a DS.

likehelpful

Thank you! I am going to look into those for sure. I doubt my manager will have anything for me to work on in my spare time, but I will work to see if I can do my own projects on something like Dataquest.

like

Teach yourself SQL and find ways to implement it into your current role to make life easier on someone. You, your boss, a teammate, someone.

like

1. read the basics and do tiny examples on w3 schools. (5-6 days)
2. open leetcode (free version) and do 1 qn daily.
3. even id you do 1 easy level qn daily you’ll be much better than many data analysts in market now

like

This helps a lot. Finishing up my MSHI in August. We took a very basic SQL class early in my degree and have definitely lost those skills. Thanks for sharing! Thanks OP for asking!

No real suggestions here but just wanted to say I love this for you! As someone trying to pivot industries, it’s inspiring to see

like

Thank you! ☺️

My coworker's daughter studied Health Informatics. I don't know much about it but might be a good marriage of the skills you want to learn and the ones you already have. As a matter of fact, there is a Nursing Informatics career.

like

That’s awesome! I haven’t even looked into nursing informatics, but I will. I am not an RN though; I am just an LVN. I do have a history of extracting healthcare data but it’s clinical data in reviewing medical records, not code or anything.

The engines might be different but the syntax to write the queries is fairly similar if not the same.

like

DataCamp. That's what I've been using.

like

How do you like it so far? Is it coming along ok?

W3schools, geeksforgeeks, and then practice on HackerRank. If you know what "flavor" of SQL you want to learn, that can help too. If I recall correctly, Mode has some live databases and training you can work on. Luckily there are so, so many free resources for SQL and the overall concepts are pretty straightforward.

Select - what do you want
From - where does it live
Where - what conditions

like

That's correct! However, it's really about syntax versus functionality for the most part (how you say it vs how it works). If you can write one kind of SQL, you can usually Google search how to do it in each version. "how to do inner join in SQL Server" or "if statement postgres"

like

Related Posts

I have just got an options trader job at a prop trading firm. But I knew nothing about options/trading/finance. The firms said they’ll be officially training us once we start. But in the meantime, what are some books/resources that you would recommend to start learning first?

like

Hi Fishes, I am bit confused to pick the role in KPMG lighthouse as Sr Cloud Data architect or Saama technology as a Project lead. Money wise it is not a big difference. In KPMG I will work with partner where as in saama I will work with project/program manager. Please suggest your opinion. Saama KPMG KPMG India

like

What’s the best way to break into a big law litigation practice as a Junior associate? I’m currently working in non-auto accident insurance defense and don’t know any attorneys in the area

like

Hello all, I’m planning for a career switch. As I’m currently in Finance sector and planning to quit my job and to start my career in IT Hardware companies like: HP, Dell and Lenovo etc.. Before taking this jump I want to know how is the career growth in IT Hardware, how is the promotion structure in such companies. I personally don’t like my present job as it doesn’t relate any part of my interest.

I have experience working as Lead Software Engineer for over 5 years with Goldman Sachs across many Retail Consumer applications. I'm considering switching to Technology Consulting roles with McKinsey / BCG - any suggestions?

like

Hi all, I’m working with KPMG India. I had a question, i wanted to shift to the KPMG Middle East without quitting my job. So my question is that is this possible that i get an internal job switch with the same company to the middle eastern branch or does KPMG don’t allow you to do that?

like

Got a tough decision now
My current job pays around :120k
Current job: senior ServiceNow consultant , just got raised, mid to big consulting firm, mostly government job, opportunities to become manager

One of my former client ask me if I would join them as contractor for around 160-165k
Job offer: 2 year contract each year has a chance to turn full time, with benefit , mortgage insurance company

What would you choose and what else would you consider?

like
like

I’m currently working on my Juris Masters in American Legal Studies online. It has been stressful beyond belief!!

I want to go to law school but I found passion for education law and working in the government can I do that with this Masters or should I keep going towards law school?

like

McKinsey & Company Received offers from AlixPartners (Vice President - Enterprise Improvement Team) and McKinsey & Company (Associate -Implementation Team). Pay level is pretty much the same and had great interview experience at both firms. Where should I go?

like

I graduated with my bachelor's in HRM and I'm wondering if there are any certifications or trainings I could do before I lock down on the SHRM-CP. I recently became HIPAA certified for my company and that got me thinking about what else I could do to add to my resume. Looking for good stepping stone certificates.

like

I am starting a new job where I will be investigating sexual discrimination cases. Employment law will be a new practice area for me. Do you have any recommendations on good learning resources? Any treatises?

like

Would you strongly advise against going in-house right after a state court clerkship? (No law firm experience in law school either). I don’t know if I want to become an in-house forever. Would it be difficult to get a law firm job at a later time?

like

@EY sustainable finance team, is there an appetite to accept an internal transfer from the Digital finance practice (M based out of London)? What steps would you recommend to make that happen?

like

Hi Fishes
I have got offers from PwC AC Bangalore (EA) in Management Consulting vs Accenture Capability Network as Management Consulting Analyst.
CTC almost Same

Which would be better considering WLB and growth?

Workex :Pre MBA 3 and Post MBA 1 (in consulting)
Tier 1 Bschool

like

I m in a manual qa with 12 yoe, is it worth to shift in SDET? If yes, how can I shift in SDET?

What career path you guys can see in future for Manual Testing candidates?
Any thoughts...

like

I don’t have sales experience but am a Manager at a consulting firm with broad tech experience (predominantly software implementations and upgrades). I would like to explore a Customer Success Manager position but most positions ask for experience in sales :( Can anyone lend insight on other skills needed and tips on how to land an interview?

like

Looking for opportunities to work in my field eventually. I’m almost certified in project management through Google. Since I was previously trained in project management, I’m doing sometimes a week or 2 weeks worth of google coursework in one evening. I have used project management tools to improve processes and business outcomes ($$) in my jobs. And I have worked to teach others these principles to improve efficiency.

like

How many of you were direct admits to Partnership? From other consulting firms, or from industry? Was it a lateral move, or a step up/down?

The reason I ask is: I’m a Y3 Director at Big 4, always been a consultant and probably 2 years away from Partner. I have an offer from industry for VP at a F50 company, but am wondering about how difficult it’d be to boomerang back if it doesn’t work out.

TIA

likehelpful

Hi Fishes, What kind of work is envolved in ReactJS projects in Nagarro? Is it maintenance or Development From Scratch work. Also is it possible for a UI Developer in Nagarro to take up backend development work along with UI? I am currently working as a full stack Python developer and Got an offer in Nagarro as ReactJS Developer. I would also like to contribute in Backend Development as well. Last Ques 😅 - Mid-Product Organization vs Nagarro, Which one shall I choose for UI Dev role? TIA

like

More Posts

How many days require to process relocation allowance after joining.
Credit suisse joining date is 22 aug.

like

How many billable hours do people in prosecution tend to average each month? I’ve gone through waves of feeling like my billable hours requirement is reasonable to feeling like I’m drowning and can’t possibly do it for that long.

like

I applied for a job at Visa and was contacted the same day. A few days later I had a 30-minute screening interview with the hiring manager. I knew I was very early in the process since the job had only been posted for a few days. It's been 3 weeks and I haven't heard back, even after reaching out to the recruiter. Have I been ghosted or is there still hope? Does anyone at Visa have insights? Looks like there are a ton of jobs posted so maybe they are just backed up?

like

Does anyone mind sharing how they are saving for the future? Or just securing yourself? I have stocks/bounds, 401k, regular (1) savings/ (2) checking, about to open a self found Roth IRA. But, what else am missing? Should I do a health found? I’m also starting a bit later at 34, so I feel like I have a lot of catching up to do. Any advice?

like

Friendly reminder about our Bowl meetup tomorrow (Thursday) in Wash Sq West. $6 Margaritas and $6 Nachos all night long. Hope to meet many of you there!

Date: November 3rd, 6:00 pm
Where: McGillin’s Olde Ale House

like

Does JPMorgan Chase scrutinize internet expenses bill for reimbursement? Like cross checking bill amount and account number with company

like

Hello fishes, to join in wipro passport is mandatory like they mentioned in onboarding as my previous organisation(payroll company). it is not mandatory so i dont have a passport and my joining date is april 28th

any suggestions what to do?

like

I everyone,
I have been selected for the associate position but till know I have not received my offer letter from legato company please suggest when can I except my offer letter discussion has happened on jun 27?

35 yo with 340k in 401k. Same amount between investment and savings. Would it be stupid to lower 401k contribution to pay down mortgage faster? (250k remaining, 2.5%/15 yr).

like

Hi All-
Need a suggestion. H1 maxing out in sept 2021.
Got a job offer from small consulting firm (<200 people) and they are ready to file my GC from day1. About to resign in next couple of weeks once I receive my h1 approval.
But Deloitte sent a notification that they are restarting Perm process. Currently with Deloitte - nothing has been filed. They have the JD and all the documents from my side but haven’t filed pwd yet. Stay or move out .?

like

What’s everyone doing today?

like

I am moving from Germany to Seattle soon. What should i do first to explore the real Seattle? And what should my new hobby be?

like

Is it just me, or does Seattle not feel as "welcoming" for first-generation immigrants?

like

Anyone else been impacted by the teacher strikes?

like

Any good Christmas party networking events? Thanks!

like

Is dsa important for technical interview for 2-3 YOE?

What percentage of your peers would you estimate views and/or posts on Fishbowl at least once every few weeks?

like

Had to tell my old man this morning to stop looking for things to complain or nitpick about and start looking for things that are going well.

likeuplifting

How did you decide your speciality in Cybersecurity? Did you naturally gravitate towards one area?

like

Additional Posts in Career Pivot

What are the prospects of being hired into a company you failed the first round of interviews (not the HR one)?

like

Why is education deemed more valuable on a pay scale than experience? Employers will pay someone with a degree and no experience a greater salary, than someone who has exhibited the experience. Understanding that the degreed person committed to school and finished, yet that doesn't diminish what the not degreed has committed to and accomplished in their careers. This has to stop!

likefunny

Anyone looking to join Coinbase? Open to any locations. DM me!

like

Any tips for someone trying to pivot into product management from Property Management ?

like

So I have just left my Consultant role in a finance company to move to a Account Executive role at a ftse250 tech company. All good…unfortunately today i received a letter from my old company saying im due to repay them £4.4k in training costs and guaranteed commission etc. How should I respond?

like

You can give me a referral to bank of America ?

like

I'm currently in a BDR role but have been studying for my PSM and getting ready to take that test soon. Does anyone have any advice for how to pivot from sales to being a Scrum Master? It seems everyone wants a SM to have 3 to 5 plus experience to even look at your resume.

like

I’m so burned out and not sure what to do. 29 in Texas. I am currently a Deli Manager. My experience is in banking, real estate, shipping and receiving, caregiving and the obvious retail. Unfortunately I struggle getting a job due to a deferred adjudication on my record for theft. It was dismissed but it still pops up I have 4 more years before I can seal the record. Idk what I could do and still make a living.

like

Let’s celebrate 2021! What was something you accomplished this year that you’re proud of ?

like

anyone switch over from full-time position to contract or temp work? if so what was your experience?

like

What do you do if you feel stuck in your career?

like

Anyone struggling with imposter syndrome? When I worked for a very well known Fortune500 tech company I couldn't help but feel major imposter syndrome. One- I am a woman in a male dominated industry, I didn't go to a prestigious school like most of my peers and I just didn't think I deserved to be there. Everyday was a struggle and tried to keep myself small so no one would find out I was a "fraud." Looking back on it now, wiser and more experienced, I realized how detrimental feeling that way

like

Hello! I am in the mortgage industry but was originally in operations and management. I am looking to transition back into operations and even intro learning and development/training. Any advise and/or referrals would be great! Have a great professional day!!

like

Crossroads Toyota Motor Sales, USA, Inc. I have been with the organization almost 6 years and have accomplished achievement of my MSL (Masters Strategic Leadership) and LOVE the organization…BUT…I am not having any success in moving into a new position…my interviews are great experiences but it seems to be a pattern of not being selected yet encouraged to continue applying…received information from a mentor/manager to ask for candid feedback…when is enough…ENOUGH??

like

Hi! I’ve been in hospitality & management for over 10 years and desperate for a career pivot. As anyone in restaurants knows, the work is ~80 hours a week and often making less on salary than your own tipped-wage employees. I have experience with training, team building, HR, financial analytics, client needs, communications and so much more. Does anyone have recommendations on a new career path or job listings to investigate??

like

Been thinking about a career switch. Am a lawyer with top experience in energy and construction transactions and have industry specific insights and knowledge. Wondering if the management consulting firms would be an interesting place to go. Also have MBA for what it’s worth. Thoughts?

like

Does anyone have experience with career changers in Data Analytics or UX/UI after taking the Career Foundry or Spring Board bootcamps? I’m curious to hear opinions if it’s worth the investment. Interested in hiring perspective or career changer!

like

Interview tips for a role in E-Commerce at a CPG? Currently in Sales at a CPG and have an interview for an e-commerce role at a beverage company. What kind of things should I research and be ready to discuss beforehand?

like

I’m quitting my job tomorrow morning. I don’t have a new job lined up. I’m scared, but also excited? I’ve felt under utilized for months, and haven’t had a promotion after two years. I never take risks like this, but life is too short. Is this a bad choice?

likeupliftingsmarthelpful

Looking to pivot from Sales at Bloomberg to Management Consulting/Change Management Consulting in the NYC area. 4 years working experience. Certainly open to Big 4 firms, but also to boutique consulting firms.
Looking to connect with someone who has pivoted from Sales to Consulting, or someone who is willing to provide insight into their Consulting role as it pertains to the type of Consulting roles referenced above, or provide a referral. Thank you!

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal