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

3L with mostly A’s and B’s. I am having the worst luck trying to find work for after school and my experience working with lawyers has left me completely dejected. I cannot get an interview to save my life. I was so excited to get an externship summer after 2L with a small business and IP firm only to get yelled at on the phone a few times for not doing an assignment correctly. Mind you, I was working FOR FREE as it was a school connected externship. That made me never want to work in the law.

like

For those who haven’t been given too much time for R1 interviews (experienced hires) and R2 (if it happens) is less than a week from R1, do they know / care that they’re not giving enough prep time to people who have full time jobs?

like

Hello there,

Last week, I was causally updating my Naukri profile and to my surprise, I saw a Goldman Sachs recruiter bookmark my profile and download my resume. Until then I was of the opinion the I'm a long way from even thinking of applying to GS. That li'l incident has piqued my interest and now I'm obsessed with working for GS.

That said, can anyone here help me with getting one step closer to my newly envisioned dream? I"m looking for a PMO profile - I have relevant exp of 2.5yrs.

like

Hi everyone Google ,

I am facing interview trouble.
1. First round of interview has done
2. 2nd was scheduled on 1 july but interviewer did not join. After a few mails to hr and recruitment team one hr replied that they will reschedule it, and asked me for possible dates.

Since then i am waiting for the interview schedule as all of my given dates have been passed. I don't know how to deal with it as I don't want to miss the opportunity.

like

When is a 3 page resume acceptable?

likefunny

Is anyone able to refer me to a company's product marketing position? I come from almost 6 years of advertising client/account management background and have been failing miserably in applying for PMM.. I have a legitimate certificate too!

like

Hey designer fishies! I'm conducting an interview tomorrow for a new Director of Product. This person will be managing our team of Product Managers and Product Designers.

What are some good interview questions for this level and type of role? I have a few in mind, but would love to pick the group's brain as I have never interviewed anyone for a Director role before.

Thanks in advance!!

like

How bad is it to sound shaky during the case interview? I got everything right and nailed the math but I feel like I sounded like I was about to cry even though I was confident 🤦🏻‍♀️

like

I don’t have the relieving letter as of now.. it will take some time for my current organisation to release it.. how can i ho forward with the onboarding???

like

For people with Non-technical backgrounds who are now Product managers in the Tech industry, what kind of resources did you use to prep for your interviews? I've had people recommend brushing up on cracking the PM code but there's SO MUCH information out there and it's hard to figure out if I'm looking at the right thing or not. Please share resources that helped you get into PM roles (bonus points if you work at companies like Amazon and Google).

like

Hi all,
I had a video screening interview earlier last week, got an email back couple days later and this is what the email says ( referred to screenshot below).
I replied with a date and time which is today at 1:30pm- I still didn’t get a response. Needless to say I emailed them this morning to remind them.
What to make if this ?

Post Photo
like

Benefits Question: how is the health insurance where you are? How does your employer handle it?

This has become one of the most important things when interviewing for me. My last employer went from having no insurance option to giving us one terrible plan that they contributed 50% towards. My current employer works with Gravie so we get so much per month and can use it towards any plan on the marketplace. Only thing that sucks is the contributions are post-tax so it counts as income.

Had a couple interviews today for a position - what is the etiquette on follow-up thank-you / emails? I kind of feel like they're outdated. Contd...

like

Anyone have any experience of how technical an interview with Baringa Technology Transformation is? I have a delivery background, and specifically extensive experience in Testing and Agile Delivery but I would not say I am a deeply technical person so I'm a bit concerned about what to expect

like

Any recommendations for recruiters? NY RR second year. I prefer to stay in NY.

like

How is Delta Airlines client interview questions?
I am a Java + Aws developer

like

Any recs on how to land an in house gig? I’m applying to things online with no bite

like

After you got an offer (from Industry), if you are interested in another role, would it be ok to interview (but retain the offer) till you get a decision?

like

I have an upcoming interview with Dataiku and wanted to get thoughts on the work culture and the benefits package. Any help will be much appreciated, thanks in advance.

like

Anyone interested in group conversation and prepration for Java 8, microservices, spring mvc and boot? Interview preparation basically.

like

More Posts

Masks at open houses?

With flu season (and COVID season?) just around the corner, I’m thinking of asking buyers to mask up at showings. Good idea or am I going overboard?

like

Do you think people working in the pharma industry will gain more trust, respect, or positive vibes in 2021 after vaccines are widely distributed? Right now it’s the industry with one of the lowest perception scores

likefunny

What type of food do you all feed your fur babies? I have a very picky eater, and doesn’t like hard food/treats. He’s at an ideal weight, and I’ve been making homemade food to mix in with his kibble, but not sure if that’s the best thing to do for his nutrition. I’ve tried wetting his food to make it softer, but he won’t touch it. Not sure if I should look into premade human grade food or continue making my own. Or using something else for his kibble. Any advice would be helpful! Thanks :)

like

Hello Friends, Please help me out which paid online platform is best for java full stack developer. I have 7 years of experience in java and want to enhance my skills more. There are many in markets like:- upgrade, great learning, scaler, simplilearn and many more. Please suggest which one is best. Or anyone here joining any of these platforms yet?

Is contata worth joining?
Read scary reviews on Glassdoor

like

so should I sell dodge? lol

funny
like

What is the structure of the interview process for AMC position at Mastercard Pune?
How should one prepare for it?

Also if someone could share the CTC range, that would be helpful too!

like
like

After how long we will hear back once online test compelted ?

I want to hear it all, let it out. Why did you hate HRC? Or you just felt she couldn’t be president because she was a woman?

like

I was wondering if anyone works as a medical examiner assistant (gov) and what your salary is?

like

How do you think healthcare startups are going to change the healthcare marketing landscape? What trends do you see happening now and later on?

If you can, say what type of company you're in (startup, hospital, etc)

like

Just curious, how much do Partners make at a firm

like

Moved to the GTA last year from Vancouver; and we have a BIG raccoon issue here. It’s pissing me off. Raccoons keep taking a dump on my porch. Tried everything to deter them away but been unsuccessful

funny

I read an interesting article from Accenture about using APIs in RPA projects. I always wondered why I haven't seen anyone RPA project where we used APIs. It just seems to enhance the process...

Hi Fishes,
What should be the salary for Manager / Sr Manager having 14+ yoe in project/product service operations? I am at 32 lpa which I think is quite low having worked with top consulting firms for close to 12 years.

like

Urgent-Anyone working in Lowes Project in Nagarro? Please pour your suggestions regarding project culture and work life balance.

Thanks in advance Nagarro

like
like

Hi folks,

I wanted to to know the in-hand salary for the CTC 16 lpa in which 14.5 is fixed. company is wipro.

With the pf and home loan exempt and tax deduction what will be in hand amount?
Anyone who can calculate or whoever is receiving the similar amount can help?

like

Additional Posts in Consulting Exit Opportunities

Anyone know if any Tech/FAANG companies hiring in Sourcing and Supply Chain management roles?

like

Graduated May 2019, can I apply for campus hire jobs 🙂

like

About to have my first session with a career coach to discuss exit opportunities - any advice on what to reflect on ahead of the session or things to bring up?

likehelpful

What’s the common process for when a client offering you a job at the end of the project? Do you still have to go through interviews and stuffs like a normal application or the client would just send you an offer?
The client asked me to join their team, we talked about the position (no specific comp yet), and they asked for my resume. Just want to know what the common process is like in this situation, TIA.

likehelpful

Any thoughts on Publicis Groupe for a corporate role? I have an upcoming interview for an Associate position on their Growth Operations team

like

Has anybody done the Uber take home test? What do they define as “support model”?

like

Hedge fund or VC route?

like

Who are the top PE/VC headhunters in SG?
How common is it to move from MBB to PE/VC in SE Asia?

like

4.75 YOE in consulting. What comp should I be aiming for? Looking at strategy and business development roles across industries. I’m at 110K right now.

like

Which resume line would provide better signaling of talent to employers?

MBB? Or a mid cap VC ($500 AUM, not a name brand like Sequoia). Post MBA level at both, no promotions assumed. Not necessarily focused on future VC path over the long term, but interested in experimenting.

like

How long as a senior associate at EYP till Consultant? Have a ex colleague who moved over with 3 yoe and is now a senior associate

like

Trying to chart my next move and not sure what direction to go. All I know is I’m tired of being always “on” in a client-facing environment.

Any podcasts, books, etc I can read for insight into more internal roles like biz ops, corporate dev/strategy, other??

4 YOE total all in consulting. Currently a SC. Clients/work have been commercial healthcare implementation & public health strategy, risk, process imp etc.

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

Anyone have insights on what it’s like to work at Aetna right now, with all the CVS merger activity going on in the background? Got pinged by an Aetna recruiter and trying to gather intel. TIA!

like

How much do recruiters and account managers at recruiting firms really make? I know people that appear to be living the high life - lavish vacations, buying expensive homes, etc. and am wondering if I should consider a career switch

like

Reports are that the average tenure of people in top consulting firms is 2.4 years. Interesting how the industry is even shorter. Thoughts?

Post Photo
like

Anyone from Amazon willing to refer me? ~3 years in tech implementation and product management

like

During these times, when joining a new company - are you folks negotiating any language of not being laid off or compensation if offer is rescinded?

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

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