Quickest way to learn SQL for a FAANG interview? Know through joins, aggregations- but I’m a data sci consultant so 99% of my work is in Python. Interview requires CTEs and complex expressions

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

Leetcode Databases easy & medium questions. For the most part itll be window functions, joins/sub queries, functions

like

Here's an awesome reference for joins. 😂

Post Photo

Related Posts

How long do y’all like resume bullets to be? I know to keep them to 1-2 lines and to keep the resume to 1 page but I’m conflicted about how to balance details vs white space. I’m in product and see some resumes with bullets averaging 5-10 words that state “Manage roadmap for $200mm product” while others use ~20 words per bullet and highlight product info, process, or impact in a bit more detail.

Hi Folks
How many rounds of interview conducted at Oracle for SeniorSystem Administrator position?
I have cleared first round . But they are telling there are other rounds too. I am curious please clarify if anyone from Oracle or recently joined .

like

In my notice period in TCS decided to hunt for interview in other company after one month, within 3 months i should able to get any offer letter from companies.m I doing the right thing,any openings please let me know guys.

like

I’m interviewing for a GC role at a company that’s never had in-house counsel before. I’ve never been a GC - what questions should I be asking?

like

Hey everyone, I am new here and was wondering if anyone can give me referrals for a position as a SM. I have been applying non-stop for a Scrum Master position and haven't gotten any interview. I currently work as integrity analyst and my contract expired in a couple of Months.

Thanks in advance for your feedbacks

like

I have an interview coming up for a Case Manager position for the in-home care company. I would have 16 patients in my caseload 9 locally & 6 out of town. The company said the case managers are the backbone to their organization. Is the workload much greater than the in home nurse? Would a Case Managers make more an hour bc of their leadership decisions & caseload they are responsible for? In Indeed the ranges for salary varied. What would you negotiate for in NW Ohio area?

likehelpful

If a senior partner referred me, and I still haven't heard back after 4 weeks, what could be the reason as to the delay? Am I not getting an interview?

like

I’ve been working for a company for 25yrs, looking for advancement. I’m considered an SME, managing people, Vendors and working on large system conversions. Have provided long term goals. When requesting feedback I’m told I’m on the right path, no suggestions on what to improve. I asked about timelines for advancement and not being given anything concrete. Recently interviewed with another company as a Vendor Mgmt partner. Individual contributor, high visible position with potential. Thoughts?

like

Anyone in AFS willing to chat about the practice and their experience? My brother found a role he’s interested in applying for, but curious if anyone could talk to him about so he could get a feel for it. I worked at Accenture years ago, but not in Federal, so I know nothing about it!

like

Have a phone screen with a recruiter today. Dodged the salary requirements question in the application but I know it will be asked in the phone screen. If they ask me, can I turn the q on them?

like

What's a good base salary to live comfortably in the San Jose area for a single person? Thinking about interviewing/moving out there from East coast but seeing the rents is giving me sticker shock.

like

In final stage interview for Product Manager position at Early Stage VC startup. The company convo is coming up soon and I am looking at asking 140K base, 20K sign on, and 40K equity. Is this reasonable am I selling myself short (or too high), I’m coming from consulting.

like

I’ve been promoted with a title but not the responsibilities. I’m job searching and am primarily looking at postings that don’t include my promoted title — I’m not sure how to professionally articulate in an interview why I would be willing to take a “step down”. As I see it, I’m looking for a lateral move because I don’t actual have experience as a true “senior”.

like

Hi folks, any idea about the current hiring process for an experienced hire at big4? I meant in terms of total duration.

like

What does it mean when your application goes from under consideration to application submitted with No HR screening.

like

My final round with Deloitte for UK Tech Consulting Manager position soon. Strangely it’s not a PMD round as it usually is for other Big4/tech consulting firms.
1. Can anyone tell me if they’ve been through the whole process without speaking to PMD? (First round Sr Manager, second Case Interview by a manager and third again by a manager) 2. What is a typical salary to expect? I was asked in screening but kept it vague (e.g can discuss later bla bla). I was hoping 75-80 (ridiculous?)

like

Hi Fishes... I have cleared interview with Wipro and while uploading the documents i uploade document but they mentioned LOA & education certificate are incorrect so i re-uploaded them but again they mentioned LOA is incorrect.. so i connected with the person who sent me the link to upload the doc but no help from her.. i tried to open the link today (17th March) evening but the link was not opening... what will be the next step.. how can i upload it again.. Need your valuable advice.. TIA

Hi.
Would anyone be willing to share the Interview process at Amdocs, Pune?
I've an interview coming up and would like to have some heads up.
Also, do they provide good salary package?

How long is the recruitment process from E2E? From first time recruiter reaches out to when you sign offer letter? I know this will vary but very curious because the people I’m interviewing with talk about how long it is a lot

More Posts

Those of you that interviewed at aws sales, did your interviewers go through specific bullet points on your resume?
I understand its lp focused, im just curious if ppl used examples outside of their resume for majority of their stories.

Did they ask you specifics of your resume bullet points?

like

Hey you guys! can somebody please help me answer these questions!

1. WonderWorks wants to increase hospitality sales by 25% in the next year. What are some sales and marketing strategies you would use to increase sales with our corporate partners? Outline a variety of paid and organic tactics you would use, indicating any potential costs that may accrue in your plan.

like

Started a new job 7 months ago. There’s been a hiring freeze and it seems they canned the recruitment team. Things seems to be slowing down drastically in the span of a week. Getting the resume all spiffed up and getting interviews together. When do you make the exit? “When you find a job” I know, but…

Also, would me making my exit to another role that I might leave in a 8 months bite me in the ass down the line? Do I just grab anything in the interim?

like

Anybody read Ants Among Elephants? Thoughts?

like

Hi Team,

Need your suggestions on Fractal VS UBS.
I am a Sr Big Data Engineer in
Barclays. Recently i got an offer from UBS for Big Data Engineer and got one more offer for same package from Fractal Analytics for the same kind of profile.
Could you please help me to decide that what should the best option for my carrer as a Big Data Engineer.
YOE: 5+

like

What can be salary range of lateral hire in HCL for SAP functional with 16-18 years experience

like

Hi! I have 9yoe in startup, hyper growth environments. I have a strong customer Quality Assurance process improvement background. I want to shift into becoming more of an IC vs people manager. With that in mind, what steps would get me there? Should I consider a PMP or Lean Six Sigma certification? Any other ideas? I feel so stuck and need a change. Thank you!

like

Anyone looking to join Coinbase? Open to any locations. DM me!

like

Definitely don’t see where the Asians are at in my office...

likefunny

Hi! I do freelance job as a UX Designer
And I just have rejected a job, because I don't believe in the business idea. I don't think it's gonna work and don't want to take a part in it. I also don't want to waste time arguing with the company manager...

Do you think it was a right choice ?

like

I get crippling anxiety everytime I think about moving to NYC. I've never felt anything like it before.

like

Looking to buy a watch from Chrono24 any suggestions on how to avoid fakes ?

Coming to the US after summer as I got my visa approved. However im seeing a lot of people commenting they got laid off. Is it risky for me to change countries right now and get a job I might lose in 3-4 months? Or it's not that bad overall?

like

I accepted an offer from Cognizant for a consultant position a little less than a month ago. My joining date is 5th September and I would need visa sponsorship. I have completed my pre joining formalities and background verification. The thing is I haven’t heard from HR in a while and no update as yet on visa sponsorship process. Should I be worried?

like

Hi fishers,
I am a fresher, I have a chance of getting AWS or Sailpoint (Cybersecurity)technology to work on .. kindly suggest which I need to choose.
Also ,If I get Sailpoint project now, can I switch to Cloud in future?

What does Business Analyst at band A2 means in EXL services?

like

How is the WLB in Clairvoyant - an EXL company?

like

Hi Fishes,

I am about to have HR discussion for Assistant manager Analytics.
I have 5.6 YOE , CCTC - 14 LPA

How much would you guys suggest I should ask?

Thanks

like

How long does I-140 preparation take? From the moment they receive the hard copy PERM doc to the moment they mail out the application? Can this be done technically under 2 days if law firm obeys?

like

Additional Posts in Consulting

Good consulting books? Not talking case prep but a fun read about the industry and what it takes to succeed, etc. Thank you!

like

If you win the lottery tonight, what’s the first thing you’d do and/or buy?

like

In your experience, is "Going above and beyond" rewarded by your company? Or is it taken for granted?

likefunny

Planning to do a PRM or FRM qual. How useful is it to move from Big 4 Risk and reg consulting to industry? Finding it hard to get anything other than non-PM roles

like

You know it’s going to be a good day when you’re able to pair all of your socks after doing the laundry

like

Looking to buy a house in Seattle. Will start search in a month or so. I know it's a competitive market and some people even say it might be a bubble. Any advice?

like

Thought I'd have time at LGA to get some work done. Been in Uber for about 90 minutes since leaving office. Want to kill myself. What's the deal?!?!

like

What is everyone’s top 1 or 2 favorite books on personal finance? I’m always looking for a new one to bring into the fold of what I’m doing

like

How to deal with being rejected from a consulting job you want?

We've all been there (not just me I hope). It's so frustrating when the consulting one is a tough hill to climb. Has joining a smaller management consulting firm ever worked out for anyone?

I'd like to hope one day I could get into big 4 or even MBB.

like

To the employees who take the "2 bag rule" too seriously: my wallet cross body is not going to take up anyone's over head space. Men have pockets, I need somewhere to put my phone.

like

Definitely not a fan of Westin's "Eat Well" proposition. I'm working in the room at 2:00 AM and the most appetizing menu item is a cold turkey avocado and arugula wrap. I just want a burger and fries!

like

Travel every week from Chicago to Arlington VA. Urban area -not bad for diversions but for what it is--am I missing something--it's expensive, kind of stuffy feeling, and food is just okay,

like

Going to Dublin for a few days, any cool suggestions on what to do?

like

Books to learn more about how to drive sales in consulting? Any recommendations?

likehelpful

How much severance should you expect after getting booted after 1 year. I got 3 months salary

like

First year senior, thinking I was underpaid at 94k. Have 9 years experience in technology and web development

like

🐠 Fam - What’s a good whiteboard solution for my home office? What do you use and from where do I get it? Thanks!

like

We’ve shared a lot of good stories from our hotel stays, but I’d be curious to hear all the stories hotel staff has to offer. I’m sure they’ve seen some crazy shit

like

Any good books/reads to learn aspects of Account Management / Engagement Management in context of tech consulting?

likefunny

Houston downtown JW vs Westin.. Thoughts?

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