{ "media_type": "text", "post_content": "Have a SQL interview coming up... They said it will be 3-4 questions that should take me 1-1.5 hours total, and to know \"intermediate to advanced SQL, particularly joins and window functions\". Any tips for preparing? I can do the hard questions on StrataScratch and am wondering if that's as hard as interview questions will get.", "post_id": "60dfe37cf62804002e188dc3", "reply_count": 6, "vote_count": 2, "bowl_id": "5ae4a4f739e7cb001391ec8b", "bowl_name": "Consulting Exit Opportunities" }

Have a SQL interview coming up... They said it will be 3-4 questions that should take me 1-1.5 hours total, and to know "intermediate to advanced SQL, particularly joins and window functions". Any tips for preparing? I can do the hard questions on StrataScratch and am wondering if that's as hard as interview questions will get.

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

There is an Arab guy on YouTube that has a 6 hour mastery course. Depending on when your interview is you could watch the whole thing

like

https://m.youtube.com/watch?v=7S_tz1z_5bA&t=5108s

likehelpful

Link?

Right Join: Everything in table to the right of INNER JOIN plus any common records from Left table Left Join: Vice Versa Inner Join: Only displays records from both tables with a common attribute defined in the ON clause You need to alias the tables in the FROM clause for instance: FROM customers C INNER JOIN orders O ON C.CustomerId=O.CustomerId Any columns in a join need to be aliased in the SELECT clause Make sure you understand Aliasing

There's no shortcuts. Just practice practice practice using different datasets. Also maybe find out what SQL package they use (Postgres, MySQL, Oracle, etc.), so you can prepare according. Each package have minor variations in syntax.

Related Posts

I had a final interview on Friday, and was explicitly told they would be giving me an offer. The wait is killing me. When can I reach out to follow up on status?

like

tips on preparing for superday for CDP for ACN? how hard should i expect the interviews to be? any tips would be helpful.

like

Hi fishes, Anyone who has appeared for Data Science interview with Konverge.ai, can you please share what kind of questions can I expect in their 2nd round of interview.

like

A few years ago I landed an interview at W+K to for their lead social role. I didn’t get it. The guy who did was just promoted to…ECD of W+K in Portland. I work at a third-rate digital agency reporting to our head of strategy in a big network making boring decks for boring clients.

likefunnyhelpful

several interview rounds. Positive (glowing) feedback all around. Im then told "they" just need to check w/the CEO...a short time later "sorry, we've decided to go in a different direction"...

like

What are the topics that I should focus on for an Interview in Infosys for the position of Data Scientist with 3.9 Total YOE of which Data Science Experience is 1.5 YOE ? Is the knowledge of MLOps, DVC, Model Version necessary for interview?

like
likeuplifting

Just got turned down by Amazon after two extensive writing assignments, 6 interviews and hours spent preparing. And their policy doesn’t allow them to give feedback when an offer is not made. Talk about a bruised ego. The only silver lining is staying long enough to collect the October and January big law bonuses and then I’m out! The question is where else pays like Amazon?!

like

I’m in a small, close knit bar. I love my firm (not biglaw) and the people I work with but I really, truly hate billing hours. I am interviewing with a boutique firm that does not track billables and has a great rep for work/life balance. I’m excited at the prospect of more $ for less time, but will also feel guilty to leave my firm after they spent significant resources over the past few years “raising” me, only to lose me. Tell me I’m being silly and that this won’t burn bridges.

like

Could the Deliotte interview process be more disconnected? Contacted for S&O, told them I’m tech/digital, nailed all the interviews & now they want me to interview with their digital practice? Ugh....

like

Show of hands; who has been laid off because your agency lost a big client? Also, when you interviewed for your next job did you feel comfortable saying that? And do other agencies understand?

likehelpful

Anyone here have insight into Uber Health’s interview process? I have an initial convo with the recruiter but was wondering if anyone here knows more details. The position is implementation manager. Thanks!

like
like

Hi fishes, today I got call from hr to schedule interview and asked for ctc details. I asked for 7.5LPA for 3 yoe in rpa domain. Is it over expecting? What would be ideal pay for 3 yoe in ey gds

like

I have a second round of interview (meeting partners) at Davis Wright Tremaine this week? Any tips will greatly be appreciated.

like

Have an interview tomorrow for what’s likely a dream job as first employment counsel to a small established pharma company with some other responsibilities which closely mirror my current role. I’ve got a referral from a current member of the legal team and an hr business partner who previously worked with the general counsel and is friendly with him. My guess is the pay will be a 40% increase or better plus stock. Just wanted to share because except my wife I can’t really tell anybody.

like

Background:Asia, expecting to promote to M this cycle. Looking for some advice on being headhunted/jumping ship. I’m speaking to HR from another big 4 + a recruiter for another firm for an M role, and it looks like the $ and potentially benefits will be bigger, but I’m not that keen on moving unless the $ is a huge jump. Any advice on how I might navigate this? Have interviews next week for the other roles.

like

Have anyone done contracting negotiations before? I've interviewed for co A & B and co A extended an offer today. The offer does not meet my current salary. Co B's interview structure is 3 rounds and I've finished my 2nd round today. The recruiter mentioned that since I am a contractor my current salary is incomparable as they will provide benefits, etc. Is this true? I have 2 yrs of contracting HR exp from fortunate 500 co’s & OMW to get my SHRM-CP. Appreciate your advice in advance.

like

Hi, I was contacted for a role and had phone screening interview. First interview with HM was set after one hour: - what is the process from there? - there are in person interviews or is everything remote? - what LoB privacy program manager belong? - how the privacy work looks like? - I've 11 yoe, masters, doing PhD and tons of certs. What can I expect?

like

Can anyone please recommend tips to ace a partnership case study? This is my first time working through one, and would really appreciate the help!

like

Additional Posts

Legit question: now that 90% of you all don’t have an expense account or travel, why are you doing consulting? Wlb and pay are shit, professional dev opps are good but can be developed in 2-3 years - so why not leave after

like

Can anybody suggest any books or resources to get smart on medical device marketing and/or medical device manufacturing?

like

Has anyone exited to Appian Corporation? Looking at a strategy analyst role and wondering if it is the right opportunity.

like

Hi Guys, While I joined Mindtree before 3 months, recruiter said I will be getting joining bonus after 3 months of joining. But it was not mentioned in the offer letter, as well as I was not aware that joining bonus will be mentioned in offer letter as this is my 1st jump in IT field. Now the recruiter left organization and my HR is telling they cannot accommodate request as it is not mentioned in offer letter. How should I escalate this to the recruiter's manager to get a positive reply?

like

Flight delayed and deplaned...peasant travelers rush to line up at the desk, business travelers call the diamond line from the comfort of a seat drinking coffee watching the chaos 😂

like

Need to find my job for a friend: she’s got 10+ YOE in pharma validation and quality. Looking for Philly area job (or remote) that’s more chill/not high stress. Any ideas of roles to look for?

like

How’s the Royal Hawaiian Resort? Thinking about redeem 5 nights there. Worth it? 20000 points per night .

like

How long should I stay at an “A-list” agency if I haven’t made anything worthwhile? It’s not for a lack of work ethic but a lack of luck with everything getting killed by client.

like

what are the best consulting firms for sourcing and procurement? Looking to make a switch soon

like

Returned from sick leave and found out from other people at the office I totally messed up on a project that I worked on prior to sick leave. Now that my reputation has been ruined and facing an upcoming negative performance review. No one at the office stood up for me despite of positive work done prior to COVID or wants to hear what I have to say. I m bothered by this gaslighting practice both professionally and personally. I felt I was designated as the scape goat. Continued.

like

Can someone share responsibilities and day to day activities of Associate Principal (Project management) / project CEO?

like

COVID positivity rate is lower than 3% today for the first time since last March.. Dare I say that we are finally seeing light at the end of the tunnel?

like

Hi all, DBS is hiring! Location: Hyderabad. DM for referral.

Post Photo
like

Thoughts on Guidehouse compared to Big 4 Financial Services?

like

Probably a dumb question, but where can I exit to where I do as little work as possible and still make 100k?

likefunny

Anyone else nervous about the future and not being able to retire at a reasonable age. How do you determine how much you need for retirement? Late 30s family inc. is $200k planning on kids as well

like

All right FB let's share the love - what and how does one get perks for this f-up Delta has? I've seen miles/coupons/hotel arrangements so far.

like

What’s the fastest way to get a COVID-19 test result? Urgent care places say 2 days for RTPCR results. Someone suggested going directly to a hospital for a same day result but on calling them, hospitals are saying tests only for in- patients who are going for surgery etc.Appreciate any help 🙏

like

Greetings fellow HR members, I am currently looking for my next opportunity and looking at HR business partner/ HR Generalist or Associate HR manager. I’m open to remote work and East Coast and Midwest. Thank you for your Help.

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
Download Fishbowl to see what others are saying
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

Get realtime notifications and see
what's happening in your industry
from the palm of your hand.

For account settings, visit Fishbowl on Desktop Browser or

General

Legal