What are the most common use cases for SQL at tech companies for business analyst roles? I have SQL knowledge, but want to speak better to the roles I’m interviewing for at Google and LinkedIn

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

Drop prd.fact_customer

likefunny

D3 I'm self taught SQL on the job and now I "own" the database, but I have no real context of my actual skill level to her than I'm still learning something new everyday.

When you say hard in reference to windowing and ranked partitions is that just because that would be hard going in cold in an interview situation, or because that really is high level stuff. I write window and rank queries about ever few days when solving a new problem.

I Don't mean that as a brag, my schema understanding is for crap because I just haven't seemed to need to use it. But I did completely rewrite our ETL from scratch to eliminate tons of technical debt too and horrible performance choices ... My predecessor didn't now the meaning of sargable. 😫

I'm mostly just wondering if my SQL skills are more marketable than I thought

likesmart

Omg. Selecting records of data from a table

likefunny

Practice your sub selecting. How many distinct users were logged in between 10am-11am on any given monday in Q1? If you can grapple this, you're good.

like

The harder sql interview questions will probably be using window functions and ranking partition etc

like

DROP TABLE. Always use this command.

like

Appreciate the sarcasm though 😶

like

You will be given a rdbms structure and will be asked to write a query to answer quick business questions. Example.. how to find all new customers in the month of Jan through email email referral? You will have to write the query and provide additional insights about the scenario.

smart

Yeah I think ey1 has got the general idea. Something like, given a few tables and a specific customer id, create a query to find all of that customer's orders within a time frame or other restriction. I don't think you should be asking for use cases, that'll box you into a specific way of thinking. Just try to approach it from how to generally use SQL if that makes any sense. Good luck

like

I joined a mid size tech startup and took SQL knowledge for granted. When i was on projects at D, all the data was given to me in csv, but at a tech company you literally ave to pull all your data through sql and grab different kinds of data from different schemas.

like

I know the queries, but looking for actual use cases since interviewer told me they’re mostly logic based. Thinking it’s more like joining tables

Customer 360 view...personalization and behavioral analytics. Marketing segmentation and user profiling

Guessing: go get your data

Related Posts

Anyone heard about Telstra?
How it will be for java developer with IoT knowledge?

like

Does anyone have question suggestions for a final interview with skip level boss? Big picture, vision for the role + team, growth strategy type questions! Thanks :)

like

Hows the data analytics project in wipro for IDeas apps and data europe region? Any business analyst over here?pls comment

like

Interviewing for a tech job for BlackRock. Do they really want people in Atlanta office 3 days? Doesn’t seem competitive for the market. Is there flexibility in this? Or are they watching badge entry?

like

I’m a jr SWE and have successfully landed an interview with Google. It’s time for the coding and interview rounds. I’m a wreck. What was the best way to prep for this portion of the interview?

like

Coming straight out of BIG4, I’m likely expecting an as a VP in CITCO - opinions / thoughts?

like

What does the technical assessment at Wynshop go over?

like

Is pwc sdc having permanent work from home option and how to get it and to whom to reach out?

like

Thoughts on TBWA\WorldHealth?

A recruiter there reached out to me about a Copy Sup job. What should I be looking out for?

like

What is the level and comp range for a Principal Program Manager (Amazon).

like

I found a company I was really excited about working at. I applied for the job and went through 5 rounds of interviews. At the end they said I was OVER qualified and they want me for a different position higher up in the company. I was super excited they then had me go through 5 more rounds, 3/5 people were the same. The interviews mostly went "didn't you get the job, I highly recommend you? I'll just put you down as a 10". After those were done they told me I was UNDER qualified. Can't win!

like

Does EY GDS sends any Welcome Kit for lateral hires? If yes, how many days it take to reach us and what does it include? EY

like

Hi Sharks,

I just wanna know a small information one of my friend got selected for
Microland ltd as Associate business lead Finance,

Can anyone give me insights on the role and company
I was checking these details online i have mixed reviews can anyone comment ?

Mains doubts on these 3 topics
- work life balnce
Working culture
Financial growth

like

I’d rather not put a title behind my name, but if I were looking to attract the attention of recruiters on LinkedIn (legal and public accounting) would using “JD” or “Esq.” behind my name help my name pop up in a search?

like

Hey folks, I just want to know how to identify by seeing an offer letter of TCS, is it a C2H or Parament position ?

like

Hi folks, I just want to know the chennai branches for Citi. Specially in OMR exactly where do we have Citi offices?

like

How’s Fcb Ams?

Hi Fishes,
I have total 2 years of experience as a ServiceNow Developer. I am planning to switch from Accenture to other organization but I am not sure which offer should I take?

Infosys Or Wipro - having the same offer around 12 lpa

Which of the above organization will be a better for learning and growing opportunity as a ServiceNow Developer? Which one of the above is better?

like

Do we have to sign a bond if PWC buys out an employee from the previous company?

like

Thinking about sending my resume in comic sans. Cause most of these clown recruiters literally disregard my salary requirements and try to low ball me....

likefunnysmart

More Posts

Has anyone tried any paid dating apps? (Match, eHarmony, paid features on Hinge etc.) and is it worth it?

Has anyone else hit the airplane mode button on their laptop when they get asked a hard question by the client they simply cannot answer. Hoping someone else will answer while I get "reconnected".

funnylike

My friend’s dad was a firefighter during 9/11 who died very young because of lung cancer. He was one of those who were denied coverage. She was just having a really hard time this week. Her boss knows this and told her last Friday with a straight face that she’s sulking. Some of these VC people man.

like

Bain & Company Got referred to Bain 4 days back but haven’t got a call yet.I guess the conversion rate from referrals to interview call is way too low to put any bet.
Bain & Company

like

does anyone know anything about experiences working at “Stampli”? I have an interview for an Account Executive position there!

uplifting

I'd love to see some photos of people's favorite plants or wishlist plants

like

Saw an article about the chilling effect that the Big Law salary raises are having on in house hiring since associates cannot bear to take the pay cut. Do we believe this? Of course if an in house role offers less than a first year salary it’s a tough pill to swallow, but what if the role offers in the mid-200s for a substantially better WLB? Thoughts??

like

Does Kroll support a masters degree? Any tuition reimbursement or working with your schedule for night classes?

like

What can I do outside the office to boost my resume and be a substantially more attractive candidate for top consulting firms in ~12 months time. Working in disputes and valuation role but want to go into management consulting next year (post MBA role). I feel like my job isn’t enough because skills aren’t considered as transferable outside this field.

like

Average London Producer Salary?

like

Is 19LPA for 3.5 YoE - Full Stack developer is good?
Should I look for long term at Nagarro?

helpful

Joining Deloitte in two weeks. Going from Consultant role at KPMG to SR C in Deloitte within the org transformation. Any Muslim fishes work at D?

like

Hi people, Recently I've cleared all rounds of interview in Honeywell. How long it will take to get the offer letter. I've already sent my documents before 4 days. I've reached HR she said it might take some time generally. Any of you know tentative time taken to release offer?

like

How much Salary IC3 gets in Oracle (SMTS)?

like

Bain PEG vs. BCG PIPE in India - which is better from a work-life balance perspective?

like

Hello Fishes..
I am currently in Wipro having CTC as 7.8 LPA.. I have got an offer from TCS which is 11LPA.However, my Basic Pay/Fixed compensation is getting reduced in the new offer and also the HRA is getting reduced. The HR is telling that the basic is fixed as per policy and they cannot change it. The base pay is less but there are several other components which are higher. Should I take up the new offer? Please help. New Job location is Mumbai.

like

Arey kidhr gaya mumbai ka spirit 🤣

like

Had a fight with my MD or let's say more like argument. After that the next 2 months was endless nitpicking and pulling me for mistakes that aren't really in my control.

Post 3 months, I apply for a transfer. Transfer process delayed for some process reasons
No negatives/issues in my f22 feedback. Utilization above target. Way Above average
Recently fired without reason
Who should I escalate to?

PS: Ignore typos. Written in anger

like

Just got offered a position at PrimeSource Building Products. I will have to relocate if I take the job. Does anybody have any advice for relocating or PrimeSource?

like

I got Medical Reimbursement of around in current month salary, but I don't think I had applied any bill or submitted any such amount. Can someone tell what exactly is this amount for?

like

Additional Posts in Consulting Exit Opportunities

I interviewed for a job in a diff location and during interviews they asked me multiple times how I felt abt relocating. I said it was fine, but the more I think about it the less I’m open to relocating. I now have an offer from them, is there anyway to negotiate no relocation? They are remote until mid year 2021. I’m Happy to fly in on a monthly basis but I don’t want to move there.

like

Anyone ever interview with a firm covid times and not have a video call? Second to final round and everything has just been a phone call so far.. seems little odd and it’s a f500 company

like

Hello fish,

Could anyone recommend any good reading on Capital Project Management. Specifically management side for large projects and best practices on how to align finance, procurement, business PM, construction management, and assurance

like

Which firms offer Day 1 Green Card Process?
I know there is FAANG, Microsoft, Twitter... any others?
Thanks!

like

Recently got laid off in the middle of my search for an exit from consulting. Will this come up in background checks? If so, how do I address if it’s brought up?

likehelpful

I have an offer with a start date in November. It’s 2+ months away, but should I consistently reach out to the recruiter? I don’t know what to say though, since I have a start date, but want to keep them me on their radar.

like

MBB AP about to exit to non-FAANG tech. Would you expect a signing bonus and/or pre-determined severance pay if things don't work out with the new company? Anything else that people have negotiated during their exit? I'd be leaving a large amount of bonus on the table to leave before the end of the year.

like

What books would you recommend for someone wanting to get better at sales?

like

Here is my idea for a startup! I collect all the data from career transitions and use Data Analytics to predict the most likely career transitions. I could start with consulting. What do you guys think about this? I would be able to predict based on your firm(mbb, big4), your experience, which role you are likely to move (Faang pm, strategy manager, move to mbb). I have all the data to do this, but wanted your thoughts. Would the output of this be relevant to you?

like

Resources for writing good cover letters? All the interesting jobs seem to require them now and my previous attempts have been... Bad

like

Anyone witness slackers who got into companies you have no idea how? Had a coworker who does jack chit at work besides chatting on Facebook yet lands at a faang company? I guess if he brings the same work ethic he will be spit out for sure. Or maybe he just had no interest in doing project work.

like

Is it easier to go from product management to customer success, or customer success to product management?

like

Anybody have experience with the Jane Street Rotational development program interview process?

like

Trying to get out of consulting and into some sort of project management. Can I do this without taking a pay cut? If yes, anyone willing to review my resume?

like

Hey Amazon🐠...

When it comes to Amazon interviews, what was your “Victor Cheng” type of prep resource? Especially with LP stories. Any recommendations are welcome!

like

BCG C here, trying to see if I should consider an offer. Big pharma: 205 base + 30 bonus + 50 RSUs / yr. Worth taking while it’s on the table?

like

What should one disclose/not disclose in an exit interview or should it be mum’s the word, don’t burn any bridges, any advice fellow fish?

like

What are similarities of product management versus portfolio project management?

like

Thoughts on Joining Teradata in strategy team at Director level? Any insights on TC?

like

Has anyone been able to switch (to industry ) on H1 visa? I am getting a lot of interest from recruiters but am not able to get past the initial screening because of visa.

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