As an analyst on the business side on the bench, which software the best for processing SQL (MySQL, sqlserver, SQLite, oracle, etc)?

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

You just asked what car should I drive… a Ferrari, a Taurus, or should I find a bike. Oracle is the best and most popular, sql server is middle of the road, and MySQL is free but has warts that requires true geek to run.

like

^Thats definitely not a requirement for Business Analysts.

like

Do not use access for anything ever

like

SQL Server is the most common.

like

None, just get really good with excel and some VBA if needed.

like

That is a super technical question, depends on what you are trying to do and how much server power you have behind it. Overall I would say it's a toss up between oracle and sqlserver. However I would say that the new memory databases blow all these out of the water.

Teradata for its parallel processing. Also check out open source databases such as MariaDB or MongoDB.

Just trying to execute and qualify for business analyst roles, not trying to be an expert in tech or anything

If you really want to tinker with SQL to get some familiarity - use Access! All queries there you can view as SQL.... so create some using the GUI, then flip to SQL view.

If you want to be flexible in your learning, download the free SSMS along with adventureworks. Writing a simple SQL query is easy, but having the ability to write complex T-SQL or PL/SQL (Oracle's Toad) transactions can really open you databases capabilities. If you really want to be cutting edge, take a foundational JS course, learn JSON and make your own NoSQL DB - check out MongoDb or Elastic Search or some of Hortonworks products

Sorry, I prefer tech over decks 🤓

@d1 lol right? I'm not interested in being a DBA or TC

A3 for president

Related Posts

Any 7A / 7B on bench for more than 2months now ?
What's your plan now ? Seeing outside ?
I am on bench close to 2months now , hence any advises would be helpful
Band and Skillset : 7B , bigdata Spark

like
like

Have joined Mindtree a month back still no client interview, & hearing from other people on bench that client interviews are hard to crack here, I'm bit stressed now, can someone tell how long it takes for a client interview & what's the level of client interview here?

like

What is bench policy of coforge ?

Can anyone give me reviews of epam anywhere. I am currently interviewing but not sure if is worth to join considering 50k fix while on bench.

like

How do people deal with time on the bench or if you have little to no project work in the office to fill up the day?

like

Just got a news that I have been fired. I tried my best but there weren't enough projects and so was on bench. I am on H1B and have 9 plus years of SAP FICO experience. Please see if you can help me

What is the bench period for new joiner? I have joined cognizant 11 days back , I have given two client interview but did not selected. Should I asbscond from cognizant? Or should I continue in cognizant ?

likehelpful

Can anyone provide an honest summary of the bench policy? I’ve heard everything from 2-10 weeks

Anyone from Capgemini having vacancies in their team , please let me know ,i am on bench looking for a project. Core skills : ETL , Datastage,Unix ,SQL ,Certified on Azure Fundamentals. Capgemini. Capgemini Engineering.

like

Just got a job offer as a bench applications analyst. Looking for an insight into the company! TIA

like

Hey Guys, What's up? Is Altimetrik is good enough to stay for long time? Joined sometime back still unaware of real truth. how they will behave when we will go through bench??

Anyone in consulting and doing OE? Using bench time for J2+ seems like a good opportunity in this environment, considering it wouldn’t look out of place to remain on the bench for quite a while

like

How much does a biomedical bench tech make in Toronto area?

like

I have an offer at nagarro for senior staff engineer. I heared recently many people are on bench. Do they have enough projects? Tech stack- React/UI/Js.

like

Anybody pursuing a side hustle while on the bench?

like

Is it worth joining Valuelabs Dubai?
How is the work culture?
Is the Hire and Fire takes place without second thought?
Any bench period if exists for UAE Location joiners ?

like

Anyone have any advice breaking into LIS work? I’m looking into getting away from the bench with stable hours. If you have any other suggestions let me know. I’ve looked into clinical research, but half the time they want a nursing degree.

More Posts

Any recommendations for a good, knowledgeable buyers agent? Looking for condos in LES and Brooklyn.

Thanks :)

like

Hey LTI's,

It's been a week since I had a discussion with HR on CTC, but haven't heard anything after that. Should I wait or move on?

like

Need 15 likes for DM. please help.

like

Name all legal jobs that do not use billable hours.

like

I Will be having my very first technical interview with Infosys for an entry-level consulting position. Seeking for advices to pass the interview as I am nervous about it!.

like

𝐌𝐨𝐬𝐭 𝐀𝐰𝐚𝐢𝐭𝐞𝐝!

𝑹𝒖𝒍𝒆 𝑭𝒖𝒏𝒄𝒕𝒊𝒐𝒏 𝒕𝒐 𝑪𝒂𝒍𝒄𝒖𝒍𝒂𝒕𝒆 𝒕𝒉𝒆 𝑺𝒖𝒎 𝒐𝒇 𝑪𝒐𝒍𝒍𝒆𝒄𝒕𝒊𝒐𝒏 𝑭𝒊𝒆𝒍𝒅 𝑽𝒂𝒍𝒖𝒆𝒔

#SAP #SuccessFactors #BusinessRules #1H2022 #ReleaseInformation

Post Photo

Hi Everyone! I'm looking to transition from healthcare consulting to pharma / biotech preferably in BD / corporate strategy roles, especially in LA area. Would appreciate if you can share your experience if you have made the amas transition (roles? Work type?). Looking to get a sense of what type of work exists out there.

For context, I've a PhD in Life sciences and 1.5 YOE in healthcare consulting at a boutique consulting firm

like

Recent law grad here, looking for a firm job. Can others share what I should be looking for in a compensation package nowadays? What's typical and what's not? (e.g. 401k match, health/dental/vision, paid time off, vacation). And how does that change based on: small firm, midsize firm, big firm? Thanks in advance!

like

For those of you who have an annual merit process, what are you looking at for a budget? How is inflation influencing that budget?

like

Nvidia is my 🦄! I’d love to chat with anyone who works here to figure out what I need to do to get a job there!

like

I’m looking for recommendations of photography studios who work with smaller budgets but have a strong vision and can create smart, conceptual work. Up and coming shops, creative solutions and unique points of view.

Any suggestions?

Yaha pe koi funtalk nehi ho raha, Bowl Leader please mujra suru Karo nehito audience nehi ayengi!

likefunny

I am considering a VP of Marketing role…Any suggestions on what my salary requirement should be would be helpful…

like

Any leads on remote work? Let's start a thread, and share any company that you know is looking for remote employees, thanks!

like

ACN strategy or Monitor Deloitte?

like

Do you return gross or net sign off bonus if you are leaving the firm before 1 Year? If gross how do you get back the tax portion?

like

This is the crux

Post Photo
like

What is Grade 5 mean in Hexaware ?
Can anyone explain the hierarchy

like

Got two offers -
L.E.K. Consulting -120K as Associate
Deloitte - 120K Strategy Consultant

Trying to figure out which is better - thoughts?

Also I I had a 4.0 for my masters but a 2.9 for my Bachelors - I actually applied to L.E.K. with 3.3 with my Bachelors by mistake (didn't think they cared) - Thoughts on how to bring it up to them/is it worth.

like

Additional Posts in Consulting

I loved reading this book, and now I'm looking for something with a similar feel - any recommendations? In general I like memoir, psychology, self help.

Post Photo
like

Who’s got book recommendations? No lame “business guru” books that repeat the same principle over and over again.

like

FYI: It’s surprising because it’s coming from tech folks who usually don’t believe in Ivy. Well, how the turn tables.

Post Photo
like

OTS is growing rapidly and leadership has asked us SMs to assist with recruiting. One of our needs is for cybersecurity and data privacy consultants interested in M&A e.g. CISSP, CISA, CIPP, CIPM, etc

like

My girlfriend has bad breath (non health related) and we're looking for solutions. How can we best mask it when kissing? Anybody ever experience this with their SOs? Tips?

like

just watched a girl on my flight put both her (bare) feet up on the headrest of the seat in front of her... glad most ppl only fly twice a year.

like

is there any benefit to getting scholarship money for mba while on company sponsorship?

like

Should I get the 12.9” iPad Pro, or the 11”? Want to use Lightroom, Insta, Netflix, and some games, that just so happens to be able to do bigger stuff when I’m w/out my Mac. Also, silver or grey?

like

Cloud , cloud , cloud ! Looks like Accenture is buying professional services firms doing cloud almost every other day 😂🤣. IBM bought one yesterday. Today McK bought Candid partners . Interesting name ... sounds like soft core po*n 😂🤣.

likehelpful

If my home office is in Philly, but I live in NJ, and work mostly elsewhere, do I still have to pay the Philly city tax? Can anyone in similar situation explain how employers fill your W2s? Thanks

like

Accenture Strategy, can you share your experience taking maternity leave? Was it 16 weeks fully paid or partial? Also how did you feel transitioning back?

likehelpful

Woah. That’s it, ima setting limits on y’all! What’s yours??! Clearly Friday was a newsworthy day.

Post Photo
likefunny

Which are top upcoming management consulting firms in US which hire H1B or people on OPT?

like

Nothing quite like ripping your suit pants wide open on a door handle mid-sentence with your client sponsor.

like

Just discovered a new hire friend of mine got laid off at S& after one year...

like

Trying to aim for better WLB...for those who use client laptops/emails, do you link your client email to your phone? I get anxiety seeing an email come up and feeling obligated to respond immediately.

like

If I move to a town a few hours away from my home office, how often am I going to be expected to go into the office on fridays? Seriously considering a move to the beach for my own sanity

like

What books would you recommend for understanding human psychology / personalities? In a people oriented industry like consulting, I imagine it really helps understanding human behavior and building self awareness. For context, young person in consulting here.

like

Has anyone taken one of those online executive courses, like the Harvard Extension School offers? Looking to use my $5k of tuition reimbursement and already have an MBA. Worth it? Best programs?

like

Worked really hard on some work only for it to be discarded/not get utilized. Super demotivated right now...how can I change my mindset to feel better?

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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