I’m a business analyst and I recently learned sql. I found it to be quite interesting. It’s making me want to transition into a more technical role, which is something I’ve always been interested in but never knew which area to focus on. I’m thinking of enrolling into a bootcamp or something similar and hopefully getting into more of data analyst roles. Any programs or boot camps you recommend? I was also considering a part time masters but not sure I can commit with how many hours I work.

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

Caught me right before a meeting but I'll post some resources later this morning for you!

like

Look at me, making promises I can't keep as usual 😅

When you're first learning the language, use SQLBolt.com - it's a guided tutorial with test exercises for every page, and it helps you focus on learning to write queries without worrying about downloading the software, connecting to the database, and so on.

Once you've learned the basics, any of the recommendations other people had are good - there's plenty of resources out the that will give you exercises to run through. But practice is usually the best teacher, so try either installing SQL server yourself or spinning up a small Azure SQL server, downloading SSMS to connect to it and work with it, import tables from excel files, make queries, test stored procedures, and so on. Get into the guts and challenge yourself to do what you think a client would ask!

My favorite thing to learn new skills would be the individuals projects that are available to do on DataCamp.

Basically you do the coursework for something like SQL/R/Python. Then the next step to practice is to work on a fake project. Obviously, it’s a controlled environment with cleaner data, Ans clearly labeled objectives (something that’s rare in the real world) but it’s great to learn and get confident in new skills

like

There's a good bootcamp on udemy if you've got an account...

like

Good BAs should know SQL, tbh. You can become extremely proficient just using google, but I’d suggest finding a more official data analytics bootcamp to learn Python and/or R and go from there.

Related Posts

EY-Parthenon looking to apply to a Consultant role, Strategy - Financial Services. I have 3 yoe in FSI management consulting. Looking for advice on resume stand-outs to include. Much appreciated!

like

Hi Fishes,
With overall 8+ IT experience and 4+ java development , how can Professional scrum master (PSM-1) certifications will help in
1. Enhancing technical profile
2. Career growth
3. For better salary package?

like

What salary can I expect for this role in Kyndyl? I just need a base for negotiation. I have three years of experience in IBM/Kyndryl and the role is System administrator.

like

I want to transition from advertising into entertainment agencies like Mocean, Hi5, BLT... they are using terms like key art, A/V... is it the same as print and TV spot in advertising instead cont...

Hello guys,
Hope you all are doing good.!
Does cgi provide free udemy access??. Also do we get any reimbursement if we clear the online examination like Microsoft or ccna kinda certification? Pls do reply!

like

When I moved in-house a year ago as a BigLaw mid-level, I took a 45% pay cut, far more than I was comfortable with (although I was fine with a 20-30% cut). I took the job because it was a great role and I was focused on making the jump in house and developing the skills I wanted, which required me moving away from my firm practice area. Now that my year-end review is coming up, how do I ask my company for a significant pay raise (not just a 2-5% inflation-matching raise)?

like

Looking for advice (& empathy): Started out in advertising, then became a journalist. Moved to the US for grad school, and back to advertising few years ago. Now stuck at a company where I’m deeply unhappy but they sponsor the visa (not H1B, so it’s not a huge ask). Also not too sure of advertising as my heart is still in journalism but this pays the bills. Wary of other companies that might push me into working (most) weekends and evenings +Still don’t fully understand the US job market. Tips?

like

I have a non business background, and I often noticed that to go a bit further on certain cases or distinguish yourself from others, some knowledge about the industry/sector can be good. Do you have a website/ressource where I can have an overview of the most frequent industries? Thank you in advance :)

like

Anyone in Pharma/Biotech within ClinOps willing to connect with me to discuss how to transition into industry/finding the right level?

like

Admins. Midwest region. Tax, audit or overall office admin. Salary range? Highest comp percentage increase you’ve seen in your role? I’ve been in my position 15 years & go above & beyond for anyone in our office. But my salary doesn’t reflect my knowledge, experience or work ethic IMO.

like

I currently work as an APM at a FAANG company but recently received an offer to join an MBB. I’m very excited about the role but didn’t realize I’d need to take a pay cut when I applied (~100k base + ~20k bonus + ~60k equity vs. 90k base + 10-20k bonus). Considering that I currently work 40-60 hours/week, I’ll be making significantly less per hour at the MBB. I’m very interested in the opportunity but also don’t want to make a poor financial decision early in my career. Thank you for your time!

like

Hello Fishs,

I have given 3 rounds of interview for the position of Lead SE. Now Hoping to go for Salary discussion round if 3rd round feedback comes positive.

What salary should i expected for Lead SE role in Gartner. Before the interview i quoted them between 31-34L and told them will be flexible on negotiation.

like

Anyone in PwC Value Creation in Deals (VCiD) team? I am interviewing in a few days and wanted to get a better sense of day to day role and responsibilities.

like

I’m located in WA and have been working as a certified medical assistant and front office specialist for the same organization and have 10-11 years experience. I graduated with my BS in Healthcare Management last September and I’m currently fast tracking my MBA in Healthcare Management. I have been applying for leadership roles over the last year and haven’t made any headway. I’m looking for some advice on actually moving into a role utilizing my degree.I currently make $25.80, with a raise soon

likehelpful

Currently making 125k salary with 10k bonus at essentially an assistant controller role. Client wants to hire me and is asking for my compensation range. What is the market rate for an assistant controller in a large private company? They are really really wanting to hire me and willing to pay a little more. They floated around 150k last time we spoke but is there potential to ask for more?

like

What is role of Agile COE in Wipro. How this COE works in Wipro?
It it worth to join Scrum Master in Wipro.?
Any onsite / Promotion Opportunities for ScrumMaster

like

Currently working as a consultant in the US for a software company. Moving to UK next year for personal reasons and my company is sponsoring my visa and has offered me a Product Manager position (per my request to make a career change). Currently at 155 TC in the US and not sure how negotiate UK salary for a new position.

do you think you need a college degree to become a cop?

like

Are MBB furiously hiring in Australia/Singapore like the Big 4?

like

Heya guys, actively looking for a senior/staff optical engineering position if anyone knows of anything let me know 😬

like

More Posts

To those in non-MBB: Would you rather have an offer in hand right now for MBB or FAANG pm? Assume it’s a lateral transition.

like

What are the best day cares in Houston? Had a baby recently and would like to start narrowing down the options in case I have to get on waitlists! I live in the heights.

like

Hi! Anyone know what type of comp could be expected for an A3 or SA1 in L&D? Tier 2 city. Thank you!

I have 9 years of overall experience and past 2 years with Oracle, I am in SAAS based apps, Recently I got 5 rating in the appraisal and Manager asked what is the number you are expecting ?
Any idea what to quote either percentage / LPA ?

like
like

What is the cheapest electric company these days?

I am looking for a referral for a job in Pfizer. I am a Pharmacist with many years of Pharmacy and Business experience. I am also in the process of starting my MBA. I would appreciate the help greatly as I have applied to other Pharma positions without referrals and not had much success this way. Any help will be greatly appreciated.

like

My background is in Visual Merchandising, and I am currently working in Merchandising Space Planning at a corporate level. How do I transition my transferable skills into E-commerce Site Merchandising to be specific.

Who is planning for next year's draft?

like

Just realized it's not Friday ☹️

like

Have you flip flopped between pharma and consumer? As in: consumer ➡️ pharma and back again. Tell me your story!

like

What is SM role salary band with Big 4 Value Service Creation/M&A offering? What is a sign on bonus?

like

As an employee at pwc, can I sign “Form 3115s?” Is that allowed? Also, can I sign these forms for companies in California even though I’m a TX licensed CPA?

likehelpful

Regarding purchasing coins is it better to swap BTC/Coin or BTC-> USDT ->Coin

like

How high you think BTC & ETH would go this year? + What are your top alt coin picks?

What are some fun ideas for projects about describing setting? I was going to have them create travel brochures about the setting of a story of their choice but I think this might be overdone.

like

I am Indian national and have a long layover in London Heathrow Terminal 3 on my way from US to India. Has anyone stayed at any hotel there that is considered airside as opposed to landside (trying to avoid need for transit visa by avoiding going through border control).

funny

Halloween is all about dressing up as something you're not, so I dressed up as a happy accountant with an engaging and fulfilling career. What are you all dressed up as?

like

I know it’s a stretch but anyone know of any junior producer (video/film) openings in NYC right now?

like

Anyone know of any short online ethics courses I can take for credits in Illinois?

like

Additional Posts in Technology/IT Consultants

Best advice when entering the world of SAP.

Anyone here that completed Udacity data analyst nano degree program? I feel that it would be a great way to get into the DataAnalytics practice or find exit opportunities in the industry? Thoughts? I am a first year Senior Consultant.

like

ServiceNow / CMDB / DevOPs questions

like

Do any of you use Jo Malone ?

Any suggestions on Tech Consulting to Product Management path (certifications, courses etc)? 6yoe including tech implementations (BI, ERP) ; consider myself a generalist. Honestly looking for an exit into some intesesting product related work (potentially in big tech) but wondering how to reframe my exp & upskill myself in Prod space.

like

Any Big4 looking for D365 supply chain consultants?

like

Interviewing with Oracle for Senior Director role (Strategic Client group). 18+ yoe
How is the work culture and PIP at Oracle? I have a comp discussion planned this week, any insights into their salary structure will help - base, joining bonus, RSUs, etc...

like

What’s the best way to break into the cloud environment ?

like

Anyone here on the tech side of PwC? Someone from PwC reached out to see if I'm interested in a QA Manager role. How good is the quality engineering practice in PwC? Also what's the range like for QA Managers?

like

Fellow IT Consultants. I am a BA on System implementations and would like to learn AWS. Can someone help me get started? How about the certification for administrator ? Cont..

I want to be qualified / informed enough to be able to reasonably brand myself as an ML or/and IoT expert. (Consultant) what's the fastest way?

like

What certifications are good for technical project manager? I was thinking to start with PSM and PSPO and then move to ITIL, ITSM. Not sure about this though. Not planning to do PMP as I think it’s more waterfall focused. Was also thinking about AWS. Any other certifications recommended?

likehelpful

Anyone familiar with Ephesoft Transact that would let me pick their brain?

like

What does it take to get promoted from Level 7 to Level 6 in the SAP Products stream?

like

Actively referring folks with ServiceNow and low code backgrounds looking to learn/move into cyber, should anyone be looking or interested.

like

Anyone here work for Microsoft Consulting Services willing to provide some insight on the day to day and/or comparison between tech consulting at traditional consulting firms? Looking to transition and wanting some more info

like

Hello everyone. Any suggestions for companies looking to hire for entry level UX roles with no UX experience needed?

like

Mindtree increment letter , when it will be out guys

like
like

Move from SAP practice to Ivalua ? Good or bad career move (7 years experience in SAP )

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