Any advice on learning enough SQL in two weeks to pass a big tech Analytics role interview? Only know basic commands up to group by. Past roles I’ve only used Python exclusively and basic select queries to get data and have been doing horribly in SQL interviews which seem to be everywhere

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

Nested queries, window functions.

Try to get involved in SQL coding within the context of your work. Taking these dumb online quizzes kind of encourage short-term, rote memorization. As an interviewer, it becomes immediately apparent that somebody hasn't used this professionally.

Honestly, if you're looking to grow within this industry, you need to look beyond that interview and realize that SQL is a core skill that you need to develop. Nobody is really interested in data scientists that can't obtain data correctly and efficiently. Having to support a >$130k/year employee with additional team members to query data is a losing proposition as well.

Honestly, the algorithmic coding is extremely easy nowadays with so many point-and-click frameworks, code samples and forums, and the general availability of libraries. SQL is probably going to occupy half your time.

like

Aggregate functions. Focus on them and know them. That is the key divider I have found in SQL. Those that can do and understand aggregate functions and those that can’t. After learning those, you can learn anything by looking it up (CTEs, loops, etc.)

like

Practice practice practice. Then practice more. The concepts are basic once you list them all out and think through them, but getting relations and syntax you never use quickly and right is basically muscle memory. People don't naturally think in self-joins.

Related Posts

How confident were you that you landed a job after the second interview? My friends tell me the fact that I had a second interview is pretty much a guarantee that I will be selected. I am not so sure. So I thought I would check with the fish bowl.

Need Infosys referral urgently for java or AWS Devops..any help will be nice

like

I am currently 100% remote and went through training and onboarding 100% remote. I am now looking for a new job and I have found remote work is really competitive. Any tips for how/where to apply? I am applying for content and copy writing roles all around the US as long as the are remote.

like

Hi Fishes, how much does the post-graduation college matter while applying for Bain & Co.? when one has the relevant experience, skills, and certifications mentioned in JD. Also, any leads on referrals for Supply Chain Consulting jobs would help.

like

Hey everybody. Got laid off at D. BTA within strategy and analytics. Mostly LS/HC experience. Anybody can help out with a referral anywhere? Thank you!

like

Accenture India I have an offer from Accenture, but my company matched the offer. I wanted to revise my offer letter from Accenture.

How should I reached to HR, call or email? What will be better to get quick response, my joining is 1st of November.Accenture India

like

Hi all,

Can anyone share some insights on the Associate managing consultant role at Mastercard? I am curious to understand the culture, the projects and the salary as well.

I can't DM yet as I am new so please feel free to DM me.

like

I am an experienced CNA/MA (17yrs) trying to break into ER tech role. Previous company wouldn’t pay for phlebotomy class, and when I took a position with a company that would train me, there was so much drama and b.s.
I was out of there so fast because of the toxic environment. Should I just forget it and do my best to finish my RN?

like

Hi everyone,

After working for 12+hrs on a regular basis I've finally resigned in infosys for better or for worst.
And I'm looking out for other opportunities.

LWD- Feb 2nd

YoE- 2 years

Skills- AWS, postgreSQL, Ruby on rails, node.js, HTML/CSS, python

Offer in hand 6lpa

Please let me know if there are any job openings in your organization to which i can add values.

like

Does studying for top consulting firms’ case interviews help in any way for interviews with other firms (e.g., FAANG case interviews) ?

like

How difficult is it to break into Bain Ny from a school on the west coast (non Stanford)? If i do well on the first round and get past it, will there still be a possibility I get turned down for an interview for my final round?

like

Any good recs on resources / practice interview questions / learning materials on Alternatives?

like
like

Hi, currently i am working with icici bank in backend operations in CIB team as Deputy manager but i am looking for an opportunity in Accenture can anyone help with the openings or referral??

At what age as an EA did you marry, if at all? I find myself devoted to my career which leaves little time for a romantic relationship, especially during Covid. Hoping there is some balance to be found in this role!

like

Looking to leave a govt job for a junior attorney role in a small workers comp defense firm. I have no experience in workers comp. How easy is it to learn the work and make 1850 billable hours? What future opportunities does this experience give?

like

Can anyone refer me for Payment BA opening within BNYM

So Google reached out to me for the
role of a cloud data engineer. Could
anyone shed light on the interview
process?
Any added insights/tips would be
appreciated!

More Posts

Can we open New Salary bank account in Optum for lateral? Or its mandatory to provide last company's salary account details and continue with same bank?

like

Producers, how do you handle malfunctioning FX, location problems-demos that won’t work as planned. Car shoot snafu’s, talent problems etc. What are your best problem solving episodes?

Hi fishes,
from Rpa learning prospective which one is better. Coforge EY . please help me.I have joining on tuesday.

like

Can anybody tell me does BOSCH support buyout option? Should a candidate serve 3 months of notice period strictly?

like

Any way of being in Ey s&o and being local? As in, is there a team that mostly does projects that are local (NYC)

Playing my first round of the year tomorrow. For those living in places with snow, golf season is finally here!

like

What kind of role is CFO Advisory? I'm context to US GAAP. Please suggest. A captive center is offering this role.

like

Anybody have any interesting articles on Marijuana & COVID-19?

like

Hi ,
If I will opt for Zs accomodation for 2 weeks, then will that be deducted from relocation bonus??

Please assist.

like

Is TCS still postponing/delaying joining date for Lateral joiners? Please provide your inputs. TIA :)

like

Would you take a 15% pay cut to work for MBB vs. getting a 20% raise from FAANG?

I am now working in middle management for a retail product company.

likefunny

Weekend Drive(Virtual) 17-18 Sept for Below Technologies in LTI-Larsen and Toubro Infotech.
*For Registration, Dm your Email with JobName*

Post Photo
like

Favourite sleeping spot? Right over daddy’s junk 😂 man that sounds so wrong. Yes she knows what she’s doing, there has been the delicate but threatening application of “don’t move” claws.

Post Photo
likefunny

My coworker always takes a super long lunch. How does he have the time to get anything done?

like

How confident were you that you landed a job after the second interview? My friends tell me the fact that I had a second interview is pretty much a guarantee that I will be selected. I am not so sure. So I thought I would check with the fish bowl.

Hi there anybody here work with influencers & creators often? Would love to network and pick your brain on the legal side/contract clauses to include 🙏🙏🙏 as I'm trying to propose an influencer strategy at my company. Thanks

like

Larsen & Toubro Infotech Received an offer from LTI as SPECIALIST -data science ? How are the projects , learning opportunities and WLB ? Can somebody please share their experience as Data science specialist at LTI?Larsen & Toubro InfotechEY DeloitteZS Associates PwC

like

Need Infosys referral urgently for java or AWS Devops..any help will be nice

like

Kith x nonnative UB mid w/ Kith x adidas cobras sideline jacket

Post Photo
like

I am working at ZS on an MDM project for a pharma company
I plan to leave zs in next 6 month
I have 2 questions
What companies can I target ?
How should I prepare ?

like

Additional Posts in Data & Analytics Consultants

Are there RPA use cases in data work?

like

I am currently working mostly in Data Analytics, but I want to transition into Data Engineering. I've applied to a couple Data engineer positions but it seems I don't have the qualifications for them. Should I maybe look for Jr. Data Engineer positions to get experience and try to move up from there? If so anybody know of any Jr. Data Engineer positions available?

like

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

like

If you were to hang your own shingle as a consultant what BI tool would you use to deliver dashboarding to clients?

Assume that you aren’t plugging in to source systems as I primarily work in CDD.

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.

What are the top sales & marketing metrics that tech companies track? I have an interview for a Data architect role and the data aspect is my strength but need to brush up on the business insight part

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

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

In the most unnecessarily complicated phrasing worthy a dissertation, what are you working on this week?

like

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

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

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

Quick survey: Do you guys think having a template package to envelope an ML model as an application would be helpful. The package could contain boiler plate template for unit test, docker image, CI/CD, database connectors etc and act as a starting point for doing that. Tech firms usually have that internally but limited options in open source.

like

Learning cloud architecture right now so apologies if these are obvious questions: Best ways to store video metadata to perform analysis on it? I'm looking at AWS and GCP. Saw that Cassandra would be good for it, but not sure what the GCP equivalent is? But also I'm a bit confused on if Cassandra is just a DB and storage would need to be elsewhere? All help is welcome! I've been spinning my wheels on Google trying to understand

like

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

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

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

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