I have a Amazon DS interview lined up. Can anyone please suggest some good exercises to revise sql? I’m solving few leetcode problems,but is there a set of problems which covers all SQL functions? TIA

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

I personally liked the data camp sql course I used it for a Facebook interview and felt prepare . I also really like kaggle although I have only used it for python. Kaggle is free data camp is not

like

Yeah it was intermediate sql

like

Go through hackerrank and leetcode

like

Mode SQL course has almost all you want.

like

D1 I have an fb interview coming up. What datacamp course did you like ?

Intermediate sql on datacamp. They will almost definitely ask you a question on self joins so brush up on that and I would google more complex cases if case when statements

like

Thanks all for these amazing recommendations, very helpful. I just followed these. Got the offer from Amazon last week

Related Posts

Hi , After submitting the document when I can expect the HR round for salary discussion?

like

does anyone have experience exiting after 1 year? any vengeful MD stories? my MD knows a lot of people and i’m scared if i interview or exit to one of these places that he has a connection at he might try to mess with my career...

like

Recruiter emailed and told me that I applied for the wrong job because it was a more creative role - I have a creative background and education... anyone else feeling pigeon holed?

like

Hi. Currently interviewing at a few companies and wanted to know about Prophet Brand Strategy & Capco…

Are they good companies to work for and what is their WLB like?

like

AM here with corporate finance (M&a) experience just moved to the US to marry my American fiancé but having a really hard time landing a job right now. Job apps that match my background and requirements almost always gets rejected immediately. What should I do?

like

Anyone from EYP, have a round with them, says 2 X 2 case studies (i.e total of 4 case studies over 2 days), can someone provide some insights on it??

like

Any MNCs hire me If I performed well in every phases of the interview and I have 2 backpapers in my B.Tech degree course??

like

My temp contract has been extended. I’m relieved to be able to pay the bills, but after giving 70-80 shots a day, I literally dream about giving vaccines almost every night! Struggling to keep positive about finding a new permanent job - I was laid off at the end of April, have applied to over 60 jobs, had 6 interviews, and no offers. I can’t go back to chain retail - it damn near broke me in my 20’s, and it’s much worse now.

like

I have one query, i received survey mail from ey gds regarding joining date and location preference, so it mean iam selected or any other round happens? Because i give self recorded video interview on 7th feb and i recive survey mail on 7th March which i filled on same day and in joining date there are two options 25 March and 25 April ,wheres i select 25 april but there is no communication after survey mail so what should i do?

like

Mckinsey folks - do you recruit for Dubai offices or is it limited to Abu Dhabi/Riyadh? If so, Can exceptions be made if the candidate is a strong performer?

like

Can anyone give ideas on Novartis case Study round?
Can I prepare it from somewhere?

like

Hi Fishes,

I got offer Letter from infosys 2.5 months back, now when I am trying to decline the offer by sending a mail to HR, it was not getting delivered as HR left the organisation 1 month back, I forwarded mail to feedback team of infosys but still got the mail from onboarding team with joining details and WebEx link, kindly suggest how to proceed in this case.

funny

Any idea, what will be the second round interview for azure data engineer in EY gds?

like

Hi,
I am working as a Senior Mulesoft developer with a total of 6.5+ years of experience (tibco bw 3.6 yrs and Mule 3 yrs) and I was applying for European companies from India.
I had a screening and a little bit technical round with a company from Lisbon, portugal. They have asked me to provide the expected salary.
I need your help.

like

Is it okay if I ask my interviewer from the first round tips for the next round of interview/format of interviews? They’re a school alumni.

Looking to do a department change. Does anyone have experience in Pathology? I have an interview as a pathology assistant. What can one expect working in that environment? Is it fast-paced? I attached is the description…

Post Photo
like

I recently became an Anaplan Certified Level 1 Model Builder and have been applying to a lot of roles. Does anyone have any recommendation on companies to apply to and a range that is suitable with that certification? So far I have applied to the the big four consulting firms and Fintech companies.

Any help would be greatly appreciated!

like

I am an Automation tester with 9 years exp. What all should I focus for FAANG interview prep? Will the interview be different from that for Dev folks?

how did you know you were ready for your case interview? (and did well)

like

Hello recruiters, happy Monday!

I want to know why recruiters ask me in an interview if I am looking at other opportunities, or if I am interviewing at other companies. If I say yes they will ask at what stage I am.

I just want to know the reason behind it and if there is a right answer to this question!

like

More Posts

Did anyone in EY Forensics who was up for agile actually get it?

like

Hello all, I’m planning for a career switch. As I’m currently in Finance sector and planning to quit my job and to start my career in IT Hardware companies like: HP, Dell and Lenovo etc.. Before taking this jump I want to know how is the career growth in IT Hardware, how is the promotion structure in such companies. I personally don’t like my present job as it doesn’t relate any part of my interest.

Medical Malpractice Lawyer Recommendations in NYC? For post-surgery blindness due to eye infection

like

DM for referral for PwC/S&, happy to answer questions too :)

likeuplifting
like

I don't think this is going the way Ron wanted it to....

Post Photo
likefunny

Curious to know has anyone stumbled upon a bar(cocktails, drinks) that has also nailed social accounts so good so that besides their bar offerings people also cant wait to consume their content?

like

How long does it take to implement a Plaid API product?

like

Hell YEAH!! They JUST approved!!!! Make it rain on Monday!!!

Post Photo
likesmart

Hi there!
To which European country can I move to work in audit without ACCA? (passed 11 out of 13)

Hi Guys,

Can anyone help me with a referral in HPE(Hewlett Packard Enterprise). Please comment on this post if you're willing to refer.

Thanks in advance.

With NYC legalizing weed, are there any stocks to watch out for?

like

Hey - Might be moving from Florida to Illinois. Is there any way I can avoid changing residency and IL income tax? Realistically, will I be audited?

like

Please help me..

Post Photo

Can anyone advise - if I did not file taxes for 2019 and 2020 is there a way I can file without receiving a penalty? I just didn’t file them no great reason. Nothing complicated and I probably owe a few hundred each year in fed taxes. Nothing crazy.

like

Do you guys factor in how far your parents live when looking to buy houses? My folks are here but I'm thinking of buying in Louisana. Scared to leave them though, haven't ever lived more than an hour away from them 🥲

like

I currently work as a optician, referral coordinator and optometry technician. Busting my butt off wearing all 3 hats and I get paid $20 an hour… I don’t think this is a fare wage considering I’m doing the job of 3 people. I want to negotiate a higher wage any tips of what I should ask for?

like

Would you say your job got easier or harder since Covid started?

How is CGI for a SAP ABAP Consultant? WLB, hike and Work culture. Have interview tomorrow. YOE - 4.5

Additional Posts in Data & Analytics Consultants

I'm non US citizen and thinking of moving back to EU. My plan is getting remote opportunities across the world and work as a freelancer. My speciality is Data analytics and BI (Qlikview, Tableau). 1) How likely I can get a gig from the US? 2) if a job looking for a remote 2-3 months contract do they care what country I'm in? 3) how can I compete Indian rates as I'm in Europe 60-70$ per hour as a BI consultant is a good rate but I see online rates as low 10$😫?

like

Partner: Let’s take the data in the spreadsheet and put it in PowerBI so we can cut it up.

Me: What? It’s already cut up in the spreadsheet. I don’t get it.

Also me: Yeah! Analytics!

likefunny

Single book recommendation for user research?

Goal is interview prep. Ideally focused on applications in tech.

like

Docket + R - I have an container running a rocker image and I’m trying to launch a bash terminal and the RStudio server (/init) at the same time. Is this possible? I tried adding CMD [“/init”] too.

like

I am finishing up a project and I’m trying to document what I’ve done for my resume. What are some good metrics for someone who mainly created user stories, created dashboards, interacted with the client and developed statistical models? One of my dashboards got deployed to production but it’s to early to see the impact. My other dashboards are almost done but I’m moving on to something else.

like

I have been working in healthcare clinics and health techs for a few years now. I’m an independent consultant. Bust, a friend of mine referred me to a big bank job. The role is of data governance manager. What should I know for the interview, or how can I prepare for it? Any thoughts? They told me I don’t need financial background. Data is data, but they wanted to know metadata management and how do I build frameworks/implement enterprise systems.

like

Is there a good online course on storytelling with data? Something that can help structure your thought process and design choices when creating visualizations and Dashboards in Tableau, Power BI etc.

like

Data Scientists: What were the skills you were interviewed on and what are the skills that you use in your day to day job? Let’s create a thread.

like

Business practice: "can you guys build a model that overlays where Coronavirus is going to break out with client sites"

likefunny

What is the best way to handle group financial consolidation in a multinational company?

like

Any cyber security folks here? or those interested in systems engineering? Potential role with TC 120-180, awesome team and wlb, at least compared to consulting.

like

Do any of the top consulting firms have analytics roles (preferably not super technical) that don’t require weekly travel?

Have a lay-off meeting lined up, and now look for next opportunity. My background is around building machine learning models, data wrangling, visualization, feel confident with python. Open to any industry. Appreciate any lead on job opportunity. 3yrs of work experience

like

New data offering: name.co, or namesoftware.com for the main domain? I’m leaning toward name.co, but I worry about not having the .com.

like

So pretty much you work In consulting, get paid half of what fang people make and In many cases work IB hours to meet clients continually changing demands . All the while the consulting project is built on a half thought out rushed tech stack/architecture? Meanwhile tech companies expose their employees to best in bread tech stacks? I really don’t understand why anyone in the field would work as a consultant doing data work? The only + is in consulting there are lots of low hangin fruit 🍎.

like

What are some interesting non-tech/insurance/advertising/consulting careers where data science is applied? Thinking of epidemiology and economics

like

What tech companies are best for Data Analysts? Looking for $120k base + equity that’s gonna be worth a lot + other great benefits + possible remote.

funny

Have you ever failed to deliver? What was it and why?

like

Hi! Does anyone know what kind of knowledge is needed to crack the Data Scientist interview at Google?

I'm currently working in Marketing Analytics (primarily using SQL and a bit of pyspark). Apart from mastering SQL, I wanted to know from people working at Google what does it take to get there as a Data Scientist? (I'm very interested in Strategy Ops)

I plan to another 6-8 months in preparation and upskilling myself before I even apply.
Any help and guidance is appreciated! Thanks :)

like

Does your company split data science roles into different practices like data & analytics and software engineering? Does this inhibit collaboration & Where does a data engineer fall?

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