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

Has anyone had an offer rescinded due to lay offs/hiring freeze?

like

Anyone here who has rescheduled several times their visa interview appointment w/ embassy outside US. Allowed to schedule twice w/o penalty. On the 3rd time, it needs to be cancelled. Does yours say to wait 90 days to rebook and were you able to book immediately on the 91st day? Just wanted to know what you’ve went through ie, if there are other requirement needed when you cancel and then use the MRV fee.

like
likefunny

I graduated in 2016, did a state court clerkship, and then was hired as a hearing officer. I’m looking to apply for an attorney advisor position but wonder if my lack of ‘traditional’ legal work will harm my chances. Thoughts?

Hey Guys,

Do you face any discrimination at your workplace if you reveal your identity. Or during interviews if they ask about your marital status post 30s?

like

What is a fair compensation for a Disney cruise line Digital Product Manager with 4+ YOE? Currently in the interview process.

like

Any openings for SAP ABAP ,YOE -2 ??

like

Hello fishes

Being Scrum Master what are the requirements from
Capgemini or Clients to put me to Onsite role? (Either it may be Certifications, Qualifications, External factors or any challenges anybody faced surprisingly)

Please help me here to understand, as there's discussions going on and I don't want to let go this opportunity!Capgemini

Hi All,
Iam Military veteran, served 15 yrs in Armed forces. Unfortunately laid down by current company in Aug 22. Friends if any relevant openings available please suggest.

Skill- Administration/ Healthcare Management /non technical/support team

Industry - Healthcare/ Wells Fargo/Citi bank

YOE- 18yrs

Location - Open

Thank you!

like

Considering a move from capital markets investment banking at a bulge bracket to a distribution role in PE private fundraising at a US boutique. Questioning whether this is a good move or not… Any advice or insight on this would be really helpful!

like

Hi Fishes,

Any openings for WMS Consultant (Experience in WMS flow and Manhattan WMOS versions)?
YOE :3.5
Kindly please refer
Thanks in Advance 😊

like

Looking for your career advice! I currently work as a Content Marketing Manager but would love to move into a Head of Marketing/Marketing Director role. What would be your best tips to make that move? I assume it will take time of course, but I'm wondering what/where I should invest in terms of my training and next career steps. Thanks!

like

Johnson & Johnson Hey Fishes, Need referral for MSC in Chemistry( for fresher). DM me if any openings available for this qualification. Biocon Johnson & Johnson Pfizer Sanofi GSK
Novartis
Nestle
Roche
BASF
Abbott

Hi all I'm looking for a referral to work for Thermo Fisher as a Project Manager. I have 13 years experience. Is there anyone who could help me out?

Hey Fishes,

Joined LTI recently in P3 band. However not allocated any project. Got a call from the resource management team to relocate, which I rejected upfront as I was promised a role in the location I am posted. It has been over 2 weeks since I am in bench. What shall be the next steps, shall I wait for some days or start looking for other jobs as getting a project looks difficult as there are minimalist responses.

like

Anyone looking to exit PA? I have a great and exciting new role where you could decide what you want to do in your career and work PA type roles if you want for more money and less hours. DM for referral.

like

I've been reached out to for a position in the CIOs Office (reporting to head of investment). Can anyone explain the difference between this type of role and a role in the deals/ops teams?

Key tasks mentioned; investment process oversight; fund strategy/ portfolio construction and post-investment monitoring

Thank you

Anyone thought of applying for the campaign in florida with Pascale?

Anyone working at USAA as a data analyst? I have an interview coming up and I was curious what you felt was the key to getting the offer USAA

like

More Posts

Hi Fishes, I am a RPA DEVELOPER with 3.3YOE in Blueprism, UiPath and python looking for opportunity.

Please help me with referrals.

Thanks in advance.

Accenture Tata Consultancy Infosys IBM Deloitte EY

like

What's your next best source of income outside of your job?

like

Where are the good non-agency places to work in NYC? I want a break from the rat race but not so much a break from the dough. Is that possible?

like

What is the interview process for Front end Developer experienced ?Do they ask DSA too ?

like

My husband yells at me in front of my 2 years old, even when he is scared. He needs to express his anger out before he can shut down. I am planning to leave him but I am hesitant because I am afraid this would negatively impact my son more, not having a father figure around much.... not the first time, my husband promises multiple time that at least he would control his anger in front of kid but never Lee up the promise...sometimes he would even throw stuff (not at me and my child)...

like

I believe in the philosophy of learning from other's experiences, success stories, mistakes and regrets while keeping in mind that similar set of life events may unfold into totally different ways/outcomes for others as there are always too many variables in the equation called LIFE. People may arrive at different destinations at different times while being on the almost similar path.

That being said-

If given a chance to RELIVE your life again, what would you do differently and why?

like

Please help me with In-hand salary :

Post Photo
like

I’ve just started my second warehouse job and I’ve noticed the same toxic resentment between warehouse and office staff. Is this the norm?

like

8/26 check in

Active rest day today. Need to hit 10147 dynamic step goal on garmin to maintain my streak - 6 days done, earlier best was 21 days, todays day 7

like

Has anybody's Job confirmed without having a project (in bench for 6 months) in the Probation period in Infosys for laterals??

Trying for a job in the big 4 as a senior associate. No luck yet. Any suggestions 🐠. Close to 5 years experience and a Masters Degree. Looking for jobs in Data & Analytics - DW & BI.

Is a basic understanding of Big O needed for Google PM interviews? ( Not technical PM roles)

like

Any thoughts/insights on the KPMG investment banking practice?

like

Wanted to check regarding Deloitte Change Management team -

1. Is the clientele better than that of EY HR consulting?
2. Is it easy to move between teams (Deloitte workforce strategy team) - or does one get stuck with Change team?

like

Hi I am in ESG field with a potential offer from Australia- what is the competitive salary? I am getting 110 as a response from google searches but would it be safe to push for 140-150?

like

What inspired you to join this industry?

like

How does one declare investments regarding ppf and HRA, i joined UST on 11 april and my payroll portal is still not active ( HR told post first salary it will be active ) .
I want to avoid getting alot of tax deducted in my forst salary, could anyone suggest the same.

UST

Countdown... beginning now

like

Anyone know which firms currently sponsor green cards for tax people? I had to switch firms with an approved I-140 and had my H-1B transferred to the current firm but they likely won’t help with my green card application. It’s a tough situation and I really want to get to the finish line with all the time spent waiting. Any tips or advice is appreciated. Thanks in advance!

like

Hello everyone, I wanted to ask about pay ranges for Cloud Infrastructure engineers or Devops in Toronto/Vancouver for a mid-senior position, especially if anyone has an idea about Telus pay ranges.

Also, if they have a good culture or not.

likesmart

Additional Posts in Data & Analytics Consultants

What are some large open source structured datasets for our experimenting pleasure?

like

Anybody looking for data strategy or technical PM for analytics projects?

likehelpful

I am a beginner DA user and trying to gain experience. I am trying to do a project on ESG for fun, and having some difficulty coming up with a hypothesis. Want to pick your brains and see if I can get started. I have data about CO2 emisiones, electricity usage, air quality, and that’s pretty much it. Using alteryx and powerbi (to visualize results) as I don’t have any other programs. Thanks so much!

like

Vibe check - do you also feel often times that you are a wizard who pulls a rabbit out of his hat on each project, with unrealistic timelines, no data, understaffing and lack of clear requirements?

like

What’s the coolest data solution you have delivered? The industry is getting a little predictable and some inspiration is always welcome.

like

Wanting to get out of fed space. I am a data scientist with 5YOE. What are good companies to look for in DC area that’d hire someone with gov consulting experience?

like

Hey all. Question regarding Presto SQL and Arrays.

I’m working within a Presto DB and the column contains a nested array. I need to pull out the 3rd item of each array. Does anyone got any info on how to approach this?

like

what do you talk about in your 1:1s?

I got lucky and now have leadership that seems to care about my career growth, but I'm 1. a little overwhelmed taking over a new role from someone who went on parental leave earlier than expected and 2. not used to thinking outside my day to day job, happy to keep my head down and just produce good work.

most of what I bring up in these meetings are logistical or prioritization concerns but I feel like my manager is expecting a lot more from me.

like

What's the expected pay bump from leaving big4 to the industry with 2.5 years experience and senior consultant?

like

If you’re hiring for sr analyst roles , what tradeoff would you be comfortable ? Business acumen and prior knowledge of industry/ function or core data analytics skills ? Need both at end of day but candidates are strong in only one of the two areas. Assume candidates are coachable and willing to learn.

like

Hi All,
I have a question about replicating an Alteryx model in python. Basically the Alteryx model used to clean, combine, prep, run some business rules and spit out a formatted file ready for running further analysis/viz. Can this same process be automated using a python script? I’m new to python and would like to know what packages to learn to do this.
Thanks!

like

I interviewed for a product analytics DS role at Fb/Meta last week and haven't heard back since. Not sure if I event want to take up the role but nevertheless wondering if I am already rejected? Been about a week.

like

Does anyone work for a company that is paying for them to get an MS in Data Science or Business Analytics? If so, where?

like

I need a new laptop. Not sure what to look for other than a SSD, 16 GB Ram, and an i7 processor. Fine with Apple or Windows. What else should I look for if I want to do a lot of my own kaggle and

Can someone explain what’s the difference between EDM technology/tool and DWH?

like

Need some recommendations for resources/papers/blogs/podcasts that focus on data management. Really want to immerse myself in the space but content seems hard to come by.

like

AWS big data specialty exam worth taking? Does it involve any coding?

What’s the best company for machine learning projects?

like

My first 2 years was developing algorithms. Since last year I started business development, project management with outperforming achievement. What could be the next step if I don’t want to code?

like

Considering a data and analytics role for a data migration project. What kinds of SQL queries will I be expected to know?

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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