I have an interview coming up in 2 days. My SQL skills are kind of rusty since I haven't used it for years. I'm not sure if i will be asked some SQL but it's one of the requirements. Any tips on how to get ready for it in such a short time?

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

cheatsheet the way to go to prep. Also, remember that you can easily translate what you're trying to solve in SQL to English if you understand what the question is asking!! You got this

like

Thanks :)

Watch some YouTube tutorials to refresh?

Look at some cheat sheets

Seems like it's the best option 👍

Is it a knowledge of sql type of role where you are going to be expected to review code by others or will you be expected to code?

If it's the former, I would suggest brushing up on common pitfalls. How would you check to make sure it is accurate? Are any joins executed correctly, is the correct population in the where clause, are any exclusions missing, etc?

I think it'll be combination of both. Thanks for your advice:)

Related Posts

Hello fishes,

I have an interview call with chubb Limited for DevOps onboarding Engineer role. Any one working there or knew chubb limited could share some few insights on the company's work culture and expected salary for the mentioned role.
chubb
CCTC: 7.2
YoE: 5.9

Is it a norm to send a thank you note through your recruiter? I had an iffy interview, and wondering if I bother sending a thank you note. It was very clear that they were trying to do a stress interview so I feel weird saying the usual nice things.

like

How many days will it take for Wells Fargo to release the offer letter ?
I attended my interview and got shortlisted as well, I just got an email stating congratulations and send us list of documents !! After which When I try contacting the HR, he's not responding !! What do I do in such case !!
Kindly Advise...

like

Hi Guys , can somebody please let me know what is this Core values round in Sapient

How long does take for hsbc to release offer once bgv is complete and salary discussion is done with HR. Hsbc Hyderabad

like

I attended an interview and did assignment for Multimedia designer role 15 days ago fo BMC team at EY GDS, still not heard back, interview was positive and assignment is also good. HR's don't reply to email and don't pick calls, should I keep hope or forgot it? I'm just asking for feedback because I have put 6 hours hard work in to assignment.

Interviewing for a digital transformation manager role at GT, any tips? Thank u fellow fishes 🤞😊

like

Any recommendations on where to go to brush up on your Boolean search techniques? I’ve been recruiting for 10 years, but admit I don’t know the latest ways... for example X-ray

like

When you recruiters say at the end of a 15 min call.
“I will get back to you by the end of this week” does that really mean “your not right for this position”? Because this whole thing is a waste of time. I’ve did these calls with 3 recruiters and is yet to hear back from someone. Today would be the 4th recruiter that I’ve spoken to. Does this practice annoy you guys just as much as it does us? My dream career is to be a technical recruiter but this whole thing is discouraging.

like

I have a friend who was let go a few months into his first job after college (reason: the manager felt like he wasn't grasping the training content to the level that was expected). He's worried about if he should put the experience on his resume anyway, if he does will recruiters ask why he had such a short time at this place, and what will recruiters think if he explains he was let go. What are some things recruiters expect from candidates in this situation to continue considering them?

What’s the best way to turn down a 2nd interview? During the 1st interview, I learned that the compensation for the role is not within the range that I am looking for and requires 400 more billable hours a year than what I bill now. I’d basically be laterally for my current salary just to bill 400 more hours. I also wasn’t aware that the local office was strictly ID. Firm website advertises lots of practice areas. Any advice? TIA!

like

Hello Fishs,

I have given 3 rounds of interview for the position of SE- B8 , i.e. Lead SE. Now in salary discussion round i asked HR for a CTC between a range of 31-34L. But they told me max they can give is 29.5L. I still did not accepted the initial offer from HR, it is going again one more round for salary negotiation after HR confirms the bracket from Business. I know Natwest dont negotiate once you accepted the offer. What CTC can i expect from Natwest for Lead SE.

2YOE life sciences consulting after mba as consultant with managerial duties and am given senior associate consultant role with lower comp. Would you pursue final interview with them or move on?

like

Can anyone share interview experience for the role of Full Stack Developer at McKinsey & Company for  Build by McKinsey?@

Yoe - 3

like

I had two interviews with two people at different companies and each time the interviewer had their camera off stating that they are having connection issues. Is that acceptable for candidates to do?

like

Does anyone have any interview insights for Grant Thornton? I’m interviewing for CX Specialist and confused why it’s 2 half hour meetings and unsure what to expect or how to prepare.

like

Looking for Data scientist/ML engineer/python developer roles in Europe/UK. I am applying but not getting any calls. Could anyone help me with referral or how I can apply for the companies in better way

like

I have about 12 years of experience with java, spring boot and Microservices.
How much shall I ask for in my HR round? I will be interviewed for Engineering manager role

like

More Posts

Hi all,
I am currently serving my notice period and actively looking for better opportunities.
I already have 2 years of experience in python and Deep learning. I have also done my Master's in Artificial Intelligence specialization and have strong knowledge in Machine learning, NLP, and Computer Vision.
Do let me know if anyone can refer me to the above-mentioned profile. I would be open to having a conversation to discuss further for any open position. I look forward hearing from you.

like

How to find your legal team/ help? I am working on and iOS app and there are some legal areas I need straightened out before I sink anymore money into it. Where is a good place to find legal help

should I just say fuck it and get a divorce and move to 80% travel....I can see my daughter on the weekends

like

i'm in Privacy at Deloitte, what other consulting firms have a comparable/ better privacy practice?

like

Do you think house prices in NJ will go down/up? Thinking of buying a house in 9-12 months and saving. What % is a good down payment? (First time home buyer here)

like

It seems as though entry level/junior roles in the industry are slowly disappearing. How can young people who haven’t managed to get their foot in the door yet actually start? For not so recent grads.

like

Hello,
I have been in accounting for 5 years....and thinking about switching to a marketing role where I can combine my love for numbers and creativity. How can I make the switch??? Any pointer would help

like

Hi everyone, how is OW in the middle east?

In terms of culture, career progression and projects?

Are their projects more into strategy or how exactly?

like

Pre-MBA at MBB — Have worked on a few DDs but have not touched the model workstream yet. Any advice on how I can best discuss my “deal” experience in PE interviews despite that? Thanks in advance!

likesmart

I’m 25 years old, totally healthy, working from home. My parents want me to come visit for a few days given the uncertainty with the virus. Is it safe for me to visit? Both are 60 and in good health

like

Vialto Partners - Anyone else out here in the new party? Have you changed your profile yet to Vialto?

like

Anyone in here in Baton Rouge Louisiana? 

like

What's your commute time to work?

like

I obtained a judgment against a defendant who is also plaintiff in a pending case in another county. Can I secure funds from the other case to satisfy the judgment in mine?

like

Which company to choose?
BNP - X lpa
Persistent - X+4
I am confused because in bnp it is hybrid mode . And persistent atleast for now is remote work. Due to personal reasons, I need work from home, so leaning towards PSL but worried about wlb. Please help...

like

What’s the comp most people cap out at if you dont make partner?

like

Received offer letter with mentioned that at "TCS Kolkata". Can it be considered that my base/work location is also Kolkata (*as i need this). Or is there any chance that after project allocation it may be changed and forcefully transferred to any other location without my consent?

What’s your fave shop that integrates social/digital into their creative?

like

How much does an associate scientist make at Pfizer-Groton? (I have 1 year experience out of college but have published 2 papers first author, ample experience during university, internships and have an bachelors in biochemistry with honors).

like

What stocks are you guy guys buying right now in this market?

like

Additional Posts in Consulting Exit Opportunities

How is the current market for moving to another consulting firm? Currently at a T3 and was thinking about trying for MBB or T2 next year

like

I excited to a 🦄 earlier this year. Not sure if I was lowballed on salary or not. Interested to hear other people’s comp at comparable companies. I’m a Growth Manager. Please dm!

like

When would be a good time to inform employer of my resignation if I have a start date in two months but would like to take a break before starting the new role? Taking the pandemic into cont.

like

Is it okay if I get fired from D after my H1B transfer for the new employer gets approved ?

Salary/comp range for KPMG Advisory experiences Associate role?

like

Hi all! I’m looking to connect with folks who either work at Coinbase or have interviewed recently for the Business Operations and Strategy Manager or similar role. I am looking to schedule my first interview which I believe is a consulting style case. So any details you can provide, I am all ears. The next interview will be a presentation. Again if you have any experience/advice on this, I’m ready to listen.

Thanks in advance! Help me escape Deloitte pleaseeee. I want this job sooo much!

like

Sooo

Recently started a new job and got completely fleeced by internal politics and am not gelling with leadership.

I had another offer from a cool firm - what’s the best way to ask if they would consider me again?

like
like

About to start my first PM job! Any tips to be prepared and ramp up quickly? Books to read, courses to take, etc.. any tips are appreciated! Currently in ops consulting. No tech background.

like

2 Questions:
1) Do you randomly email recruiters on LinkedIn?
2) Does anyone have LinkedIn Premium? Has it truly been helpful?

like

Doing the writing assignment for Lyft operations interview, I feel like I’m over thinking this. Any tips?

like

Any advice (besides good GMAT) on how to get into a top MBA post consulting? Im a public sector consultant.

like

Anyone else feel like Chicago has very limited "upward" exit options, especially for tech? It seems like outside of consulting, most people who earn a higher incomes are in trading/banking/PE 😕

Looking to exit from 195k base to a sales role base 140 + 40 in guaranteed bonus year 1 to make up for the lengthy sales cycle. I know in the long run total comp through equity and sales commission bonus can be much higher but having a hard time making the jump… mostly my ego to drop drastically in TCO the first year after spending all these years trying to increase base. Still interviewing - unicorn saas account exec. What would you do?

like

I've become really jaded about consulting. I find all so often you need to tell the client what they want to hear to keep their business and I feel like so much of the what I recommend doesn't actually get implemented. I'm looking to make a career switch so I can both create and execute on my strategies. A product management path seems very promising for this.

Does anyone who switched from consulting to product management have any recommendations of h helpful PM books, courses, or programs?

like

So JUUL is hiring again? Had a recruiter reaching out..

likefunny

Pros and cons of going into I banking after MBA?

like

Tech company offered me either macbook pro 16 or dell xps 15 for a nonengineering role. Which should I choose? Ive only done professional work on a PC

like

What are the exit opportunities for digital consulting if product management recruiting doesnt go well?

like

Looking for Sr Con positions in Cyber with an LA home office. If you’re hiring I’ll apply, get your sweet referral bonus!

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