How would you prepare for a SQL or any coding live interview? Do you solve hackerank or leet code problems every day?

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

Partitions, groupbys, nested select statements, case statements , CTE tables you should be fine

like

Window and lag functions

like

Yes. Several days prep for SQL, several months for real code.

likefunny

LC all medium problems. Some hard. Should be good.

like

I LC as many medium problems as I can for at least 2 weeks before the D-Day. Almost always, it pays off. For SQL coding interviews though, spend a weekend playing with LC easy/medium problems and you're golden.

like

I just took one and prepped for a week by just doing a few SQL interview questions I found online. I also went back to make sure I understand theory behind more complex SQL. Studying will help you feel confident regardless of if you know it or not.

like

It’s one thing to be able to answer a question or define something it’s a whole other thing to be able to explain the application or why you would use a certain thing vs another. Keep that in mind.

like

Hacker rank SQL is awesome, I'll consider you as above average in SQL if you've completed all the medium and hard question on it.

We can chat to discuss more.

like

Related Posts

Hi all! My past role was a pretty toxic environment - extremely unrealistic & ever-changing expectations & condescending behavior & an overall mean & anxiety riddled atmosphere. Any advice on what to ask future companies when interviewing to really dig & uncover any red flags? Getting real feedback & a true sense of things can be difficult bc typically you get back what they want you want to hear. Probing questions that might allow to read btwn the lines & uncover negative atmosphere? Thanks!

likehelpful

Hi fishes! I'm currently looking to do a bit of a career switch from research in Medchem to a field service technician role (for laboratory instrumentation). I have applied a few places and got several phone interviews lined up. Can anyone tell me what type of questions I may get? Or general advice on making this switch?

like

What is the difference between Principal Design Strategist & Design Strategist?

My current title is the latter and I’m interviewing for a Principal role. The title suggests it’s more senior and would appear to be a promotion on my resume but the jd sounds similar to what I’m already doing. I’m currently and IC, Principal is also IC. The only nuance I got from the recruiter is that there is no actual designing in this role.

Is this a case of title inflation?

like
like

Researching the job mkt & pay for nursing: It is so easy to set up a first interview esp. as a nurse. Set up a zoom meeting, in the zoom meeting ask abt job details and ask for the salary range. They will give it to you, and in my case it was the same range for both of the companies. (Hospice oncall nurse here👋). Then you fit in somewhere on that continuum based on education & experience—that where the negotiation comes in—they will make a case to place you as low as possible on the scale.

like

4 years of total experience and currently at $96k in GPS. What’s a realistic number to ask for salary? Interviewing with D and Guidehouse.

like

Offering advice to job seekers who go around recruiters and message hiring teams, execs, etc. You are putting the Recruiters job in danger. If a Recruiter declines you or doesn’t choose to reach out, it is because the hiring team declined you, or you don’t have the experience. You will most likely not be considered for future roles because of this. When I see people giving advice to reach outside the Recruiter, it’s bad advice. Very rare is this a good idea.

like

Hello, has anyone filled in the Forte Fellows Kira video questions?

Are they any different from usual Kira interview questions?

like
like

Hi fishes,
Yoe-7 techstack - .net,MVC,webapi,azure certification (az-204) but no hands on azure projects.

Unisys- 23 Lpa(fixed) ,LWD - 23 oct ,CCTC -14.5
Given number of interviews but no one are ready to give more than this even if I reach last rounds.
I am confused right now like should give some more interviews or join the unisys?

Is unisys good company to join and how about wlb and hikes in unisys?

TIA

like

I’m doing second round interviews with Deloitte but also interviewing with three other companies. If I get an offer from Deloitte, how long can I put off making a decision in order to finish the interview process with the other companies? Is this generally frowned upon?

like

15 years experience interviewed for BA4 grade in Barclays. Does it make sense? I thought BA4 is below manager grade and lower salaries.

Interviewing for a finance lead position at Gemini. Anyone have insight as to work culture and what a good offer looks like?Gemini

My interview is scheduled with PS, i have 4+ years of experience as Automation QA. My current CTC is 9.81 how much can I ask them now?

like

What does the order of Stanford interview invitations mean? If you get one sooner (closer to 10/14), does that mean you’re higher priority?

like

I had my final round with Accenture. How long it takes for the HR's to get back and roll the offers ??

like

Hi All,

I have given an interview for BI Customer Analyst for 3 years experience @NielsenIQ. How much salary should I expect?

I need help, please. I’ve been applying to jobs for several months without a single callback. I am looking to stay remote, would anyone be willing to review my resume?

like

Any tips for what Google looks for in customer success manager roles? There's tons of info on S&O and PgM and Product Manager roles, but not CSM. I have an interview lined up but don't want to blow it by talking too much about management, product, or analytics stuff.

likehelpful

Non-eng... Got past the hiring committee! 🥳 does anyone know the process from now? And how long it typically takes? Thanks !

like

More Posts

Met this really cute guy at national training, exchanged phone number, but he's heading back to home office tomorrow. Advice?

like

Can’t tell if I’m developing crushes on my coworkers only because they’re the only people I interact with (on zoom) in quarantine 😬

Thoughts on what to get wife for her bday. Shes turning 30 and because of covid we cant do a big birthday bash like we were planning. She also got laid off b.c of Covid and has been in a bit of a rut and I want to make her feel better and have a great birthday. Shes an amazing wife and mom and I want her to have a great birthday. Appreciate the help fellow fish

like
like

I got an email to start onboarding using embark onboarding, but the link is not working, i am getting error on that page. HR is also not responding. Any suggestions, how to resolve this?

like

One of friend wants to join at WIPRO..
Fresher
Flexible in any shift timing
BA
Location Kolkata

like

Favorite part of being a vet?

like

Partners, directors and senior management: when giving an interview, how do you decide whether the candidate is a good fit? Are there things you look out for? I’m deciding between 2 candidates who are both equally qualified and personable. Only looking to hire one. What to do here

like

How can Prada want $1,750 for a bag that’s not even 50% leather??? Why do I want to buy one???

like

Can anyone suggest any projects in mern stack?
I joined recently and looking for mern stack projects

If you were an employment attorney in Chicago, where would you practice and why? Considering moving from the West Coast and need to know lay of the land.

like

How long before joining do we get on boarding mail?

Any good books recommendation on effective client communication/business writing?

like

Have all SC justices really been from Harvard or Yale??!

like

Not enough people understand mountain driving etiquette - if you see a conga line of cars behind you it’s because you’re slow and you should pull over at the next available turnout and let them pass.

like

have any (females) dealt with imposter syndrome in a male dominated sport? i just started jiu jitsu at a really great academy but for some of the classes I’m the only girl and it’s a little intimidating. i feel like i don’t belong/deserve to be there. the guys are all super nice, so it’s nothing against them, i just get in my head a lot about it.

like

I’m struggling. I left an agency I liked last year due to growth limitations and since then I’ve worked at 2 different agencies and can’t seem to find my footing. The first one seemed like a good fit at first but then it turned out to not be the best place for me so I left. At my current agency I feel super undervalued. I’m always raising my hand and offering to help where I can and no matter what I do, I don’t feel utilized or valued or part of the team.It’s really taken a toll on my confidence

like

Advise needed!
Relocating to Bangalore (KGS) - any good accommodations Available near by?

like

Anyone has used any Ayurbedic med or nuska to increase the s## stamina or performance ... Between 36 Married man here

like

Is it just me or do people drive like maniacs in the Denver metro? Constant tailgating no matter what the speed limit or if there’s traffic or construction. I’m appalled by how dangerous some people here drive. Relax, getting there a few seconds faster isn’t worth anyone’s life. Aren’t y’all supposed to be too high to be driving like this anyway?

like

Additional Posts in Data & Analytics Consultants

Accenture federal what’s the day to day like as a manager? Is it hands on or more review? Is there a lot of business development at the manager level?

like

Anyone have any tips or material on effective storytelling to leadership? I have to present an analysis and recommendation to a VP and really need to put together a good story. Thanks!

like

Anyone in the KPMG Lighthouse practice that would be willing to take a look at my husband’s resume and put in a referral? He’s interested in the Associate, Data Scientist position.

Meeting with a recruiter at one of the FAANG companies. I won’t be able to move jobs because of H1b /GC at least for the next year. Any idea if I should start off with that or should I just try to understand the work that they have been doing?

like

from God import pandemic
From China import coronavirus, mortality_rate

covid_19 = pandemic.coronavirus.set_mortality(mortality = 1.)

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

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

Are there RPA use cases in data work?

like

Any recommended courses or books on customer care/cust success analytics or marketing analytics in general?

like

Folks applying for Data and Analytics roles in the industry at M, SM, D Levels, what technical/functional topics do you prepare for on the Analytics side?

like

Is anyone working with Elastic at DoD?

Newish to data analytics. Have some experience in power BI, sql, and R. I wanted to get some exposure to aws and saw the AWS cloud practitioner as an available course at my job. Is this cert worth it? Or should I try one of the more advanced ones ? The data analytics one for example but wasn’t sure if it would be difficult to get through as a beginner. Will it look good on my resume?

like

Is 128k a fair base salary for Consultant in Deloitte Analytics & Cognitive. MS CS and about 3 yrs experience. In one of the fastest growing but midtier tech cities in the US.

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

I need to do a timeline with lots of information over a long period of time. I wanted to that in Tableau, but partner will not pay license and data is sensitive so I cannot use Tableau public.
Do you have suggestions?
The requirements are the following:
- No online input data upload (so local editing)
- The produced output file must be local and easily exportable and readable
-timeline must be interactive (filter/click/zoom in/out/view detals etc.)
- free

Any kind of help is really appreciated

like

Anyone here work or has interviewed for a data science role at DataRobot? Would love to get some insight. Third interview coming up.

like

1) Hypothetically if you were looking to sabotage a colleague, can you code an excel document to throw off their numbers or calculations, (if you send them that document and they download it for use)?

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

My manager continues to ask me to help other teams and do work on other billable projects. I’m sick of it .. and I’m going to explicitly say that no I can’t do it because my hours are taken by the existing project we are doing. Is this appropriate?

like

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 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