I have a technical skill interview where I need to show an interviewer my knowledge of SQL. Can anyone help let me know what kind of questions I should prepare for? I want to make sure I'm as ready as possible and never had to do one before

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

I like the LeetCode SQl interview questions.

like

Try easy to medium level qns in leetcode. You should be good.
Some sql interviews ask to write in notepad on screenshare and discuss. Some ask to write in live environment where you can actually run the code.
Thats all i think you’ll need to know.
good luck

like

Thank you:)

Depending on the company, they usually comprise of joins & aggregation. They may give you 2-3 different tables & ask certain questions to see how to process the data.

like

Related Posts

London office - been told to do a 2 hr case round. Any idea what to expect? 2 hrs seems over the roof.

like

Currently interviewing at JPMorgan in their CIB division for a associate operations role. Have met with 5 people for two different teams and another person for another team, all of which I believe are 3 total open positions for 3 different teams. Any insight on the interview process or how long it takes or any sort of idea to give me on what I could look for that might help me believe I might get an offer? Checked my online application again recently and still says “In Consideration”

like

Hi folks... What is the interview process for lateral hire in Airbus? How many rounds will be there and within how many days the feedback in given?

Hey folks,

I have my phone screening interview coming up soon for an L6 Senior applied scientist position for Tax classification team. I was wondering if any if you can provide any sort of help on how to prepare better for this interview. It's a pretty big deal for me, and I really want to Ace that interview.

like

Has anyone gone through the deloitte cyber risk interview process recently? How many interviews did you have and how was the process?? Salary?

like

I am looking for a summer internship in consulting. Currently, I'm a 3rd year Economics and Stats student at U of T.
My target companies are KPMG and Accenture, and I really want to work in one of these two as they have the best workplace culture.
I'd appreciate if anyone could help me out with applications or share tips on how to get to the interview round, thanks!

like

Three job interviews with a company, last one creating a marketing plan and presenting to marketing VP. I received good feedback from him. Three days later recruiter wants to give me a call and “give an update”. Schedules it after 2 days. This morning cancels last minute as they are having “internal discussions”. I’m really annoyed and tired. Thoughts?

like

Is Deloitte hiring on H1B for transfer? Cleared 1st tech interview but recieved email from HR to confirm visa status. My fear is to get ghosted :)..GFS practice if that helps.

like

Experience hire applied via referral 10 days ago. How much time does it take to hear back after the pymetrics at BCG?

like

Anyone working at Omada Health? I have an interview scheduled for Assoc PM role. Would really appreciate any help in preparing for the interview.
Interview theme is case study & SQL skills

like

Hi guys, I am a systems engg in TCS with 3 years exp. Technologies known: C, C++, Java, COBOL, Oracle DB, SQL, Unix/Linux, Shell scripting.
I had applied for Infosys in the company portal long back, but haven't got any replies yet. I am looking for the Developer/ Production support roles.
And I am in my notice period, lwd is 27th sept.
Also, have an offer from L&T with doj 29th Sept.
If any one can help me out with a interview referral, it would be great.
Thank you

likehelpful

Hello Fellow Fishes

Can someone suggest a good website to create resume/cv Or share a blank template that you know worked well for you during job search?

Would highly appreciate your help. 😊

I worked FT as a paralegal and went to law school in the evening. I recently interviewed at a small ID firm in employment law with about 9 attorneys. They asked for a writing sample. I dont have anything recent but provided what I had from last yr in a legal writing class, it was not enough for them. I became licensed this May so I dont have an array of motions to pick from. Then they asked for my undergrad transcript, at this point, I am now annoyed They are not Biglaw. Are they going overboard

Cleared the first round in kpmg,what to expect from the remaining technical rounds there?

like

Globant India Pvt. Ltd. Hi Globers ! I have an offer from Globant for the role of a BA. While discussing the role with HR pre and post the interviews & offer, I had specifically ask the HR to tag me to Ahmedabad location as that's my hometown and I do not wish to relocate. But she has rolled out the offer for Pune location ane verbally ( isn't giving me in writing ) assured me that the location will be flexible. May I know from the fellow Globers if we have location flexibility or WFH option available? Globant India Pv

I recently had an initial interview for a technical recruiter position. The guy on the phone stated that this is not a 9-5 job and long hours are expected. I proceed to ask how much PTO is offered and he said that is not recommend within the first 6 months of working and the harder you work the more PTO you receive. From that conversation, I saw instant red flags. Any thoughts?

like

New to Fishbowl, currently working on a career pivot! I graduated in May with my MBA and have experience as a Director of Operations as well as recruiting and HR experience. I am looking to move more into Change/Project Management or Director of People Operations roles. I have been at the application game now for two months with only two interviews and over 20 applications sent out each week. Any advice would be greatly appreciated!! Feeing a little defeated over here. Thank you!

like

After my Interview round now after 2 months received a mail from EY GDS HR to share a few documents on mail.
Does this mean I got selected or something else?
Please please someone help!

like

Currently applying to federal clerkships. Is there an average amount of time before you hear back (if selected)? Also, is it proper to call to confirm receipt of submitted apps outside of OSCAR?

like

More Posts

Fuckjerry, overheardLA, overheardNY on instagram are pretty funny

What’s a good LA or NY business litigation firm and salary to expect? I’m a 2yr with quite frankly a lot of experience across civ rights, PI, excessive force, wrongful death, employment defense, K dispute, corp. structure dispute, professional licensure. Write every kind of brief, appeals, argue motions, take depos. Am the only associate working directly under partner on all cases. In house or M&A/Real Estate Transactional are likely the end goal but want to get the litigation out of me first.

funny

Hi all,
Wanted to know the range of salary for consultant specialist role? Yoe 10+

Is anyone here in KPMG’s CRM Risk practice? If so do you know if they are still hiring??

like

If anyone is looking for a referral as an experienced hire to the PwC DAT (Digital Assurance & Transparency - formerly Risk Assurance) practice let me know and would be happy to refer you. We are actively looking to hire.

like

What makes more money IT Audit or IT GRC?

like

Hi all,
Looking for a career change, I’ve experience in project management, oncology, health promotion, engagement, inclusion and diversity and hoping to work for a pharma. Happy to relocate and would love some guidance and referral please 🙏🏾

like

Do partners at top consulting firms have better WLB?
An Associate here contemplating whether all this is worth it.
Thanks!

like
like

I love Secret Santa exchanges at work. Bahaha

Post Photo
likefunny

Need some urgent help can anyone DM me, Please

like

Any WhatsApp group for Pune Deloitte USI folks ?

like

Could anyone tell me about the technology consulting practice of NTT Data in the UK? How are the work culture, WLB, clientele and nature of the projects, bench policy, ethnic diversity in the UK?
TIA.

like

Hi JPMorgan Chase

I got mid year promotion to a 601 level. What can I expect in terms of hike and bonus in the year end?

like
like

Do you still implement reference checks (on top of background checks)? I’m not convinced of the value add to the selection process and it takes a lot of time and resources

like

How much are my fellow VP Account Directors out there making? Just trying to gauge if I am being paid fairly. Don’t forget to state market and YOE. I am making $135k, 10 years of experience and in Chicago.

like

Anyone prepping for the SHRM-CP test? I’m taking a prep course this fall and would love tips or to know if there are any study groups out there!

like

Agency producers in nyc, how much should a monthly retainer be? Max hrs?

like

Heard PwC gave $500 to staff for every in-person inventory they performed. Can anyone confirm or deny this?

like

Additional Posts in Data and Analytics in Advertising & Marketing

This is a long shot but anyone on here in Brazil? I need to hire a good Data and analytics person in Brazil. Must know sql (but not necessarily super advanced) and R or Python (but again not the most advanced)

like

Adobe Attribution

Does anyone have an experience with Getting view thru attribution working in adobe? And if so, how was it implemented.
Thank you so much in advance for your help.

like

Are there any AGENCY folks at small/mid-size shops that are using CDP's? If so, how are you staffing the team and how are you integrating the CDP with your DSP's etc?

like

Hiring for a Senior Analyst position, and looking for someone who likes to use data to inform UX. We have someone to pull and organize data, need someone who can put that data into actionable website optimization recommendations. You will see your work in action for a large, global brand. DM me with any interest.

like

Other than providing insights and reporting, how does your analytics team help drive business KPIs, find new ways to look at audiences/businesses situation or have a huge impact on planning?

like

If there's any other industry you could do analytics in, what would you choose? I'd really like to work in tech, more interesting, better pay, and I've heard if you can get over the wlb it's worth it.

likehelpful

Top companies or types of companies for consumer insights/analytics? E.g. in terms of opportunities to learn, general progression, salary, etc

like

How much information about the kinds of work you’re doing do you include on your LinkedIn?

like

[Facebook Ads Data VS Google Analytics Data] 🤯

How can I merge FB and GA data? Some clients of mine believe that Facebook doesn't bring us results 'cause GA says so. The difference between the two of them is A LOT. Facebook says we have 100 conversions and GA only reports 2. How can I prove to them that Facebook does its job? What data can I show?

like

Hello, I am currently looking for entry level data analytics roles in Advertising and Marketing in Chicago or remote. I am currently an apprentice in a program that is data analytics focused through which I have completed certifications in Google Data Analytics and Google Analytics. I am also familiar with programming languages like SQL, Python, and R. I would love to see if you guys have any leads, it would be greatly appreciated. Thank you!

like

What projects could I do data related to build my portfolio? Not sure what kind of projects to work on related to advertising and marketing.

like

Anybody got any good recos on stats/coding courses for beginners? I’m an extremely client-facing analytics guy with knowledge of these things but not really the technical skills to execute.

helpfullike

Hii! Question for everyone, how much should a UX Researcher (quantitative) with 5 years experience + PhD should be making? NYC based

like

Hey Fam, I am trying to come-up with the carrying cost for different DCs however I am lost went comes to the average inventory, do we take into account the average inventory at a specific point and time or do we have to annualized the inventory since all other cost are annual cost? Thoughts

like

Is it just me or is the YouGov Profiles tool completely unintuitive to use?

likefunny

Anyone from or at client side data analytics/media science? Wondering how the worlds differ, agency vs client.

Hiring alert! Two open roles within Weber Shandwick’s Global Intelligence in NYC but open for non-NYC candidates as well - 1) Sr. Analyst and 2) Team lead (seasoned VP or SVP). If you want to learn more, happy to share more Info!

like

Opinions on having other people do the readout of decks that you created all the way through (data processing, analysis, and compilation)? I personally think its so silly having else do it.

like

What advice would you give to a 3year exp Data consultant from Europe willing to relocate in the US?

like

What’s the most fun and interesting analysis you’ve done or been a part of in the last year?

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