Hey guys! What are the best resources to brush up on my sql skills within 1 month? Currently I'm decent at the basics, wanna get to the level where I could easily use windows functions, CTEs etc. for interviews.

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

Datacamp, w3 schools, I think leetcode has some sql

like

Leetcode all the way.

like

Trust me, doing you a favor when I say: don't join my firm. I'm also looking for a way out.

likefunny

Related Posts

Do you still write thank you emails after interviews? A lot of the roles I interview for these days are coordinated by recruiters so I don’t see the interviewers emails

Hi, I am done with 2 rounds of interview in CGI. Waiting for second round result from past 4 days . Daily I am dropping remainders to the team. But no response. Can I consider it as negative?
CGI

like

Best podcasts, YouTube, TikTok, or um books for interview prep for consulting?

like

Hey everyone! I’m a couple months in of trying to find a SDR role. Does anyone have any advice for interviews or just to stand out from the crowd? Any advice would be much appreciated!

like

I have an interview with Korn Ferry for an associate principal role and am curious about others’ experiences have been with work-life balance here. Also, I have an idea of what I should be compensated in this type of role, but any insights on how they pay compared to others would be helpful. Are you traveling during the pandemic or have client interactions been virtual? Lastly, if you are a consultant here, are you on billable hours? My current consulting role is not - so this would be new.

like

Does anyone else balk a little bit when applying for jobs and the recruiter or job description mentions a lot of blog writing and other content like that?

like

I cleared technical interviews in Legato Health Technologies and was asked to send the documents to proceed with HR discussion. Its been a week and i didn't get any call from them. Any suggestions. I have 13LPA and asked 20LPA with YOE 6

like

I was told to apply to a hospital job by someone interested in interviewing me. The recruiter reached out. Asked for my availability but then didn’t respond when I gave her my availability. I followed up. We scheduled a phone call (she said she’d call) and then she didn’t call! At this point, I’m thinking they’re totally disorganized. Is this common practice? I’ve never dealt with a recruiter so I don’t know.

like

Just got rejected from PwC. Can I apply again after few months hitting 1 YOE?

like

I have an initial recruiter phone interview with Square Thursday. Is it it just a phone call or is it a video call and they didn’t specify. If it’s a video call what’s the dress code like? I’m coming from consulting so all my interviews were in suits. Any tips to get past the recruiter phone screen?

like
like

Hello people, how common is a Amazon to PWC move ?
I’m interviewing for a Senior Associate role and TC seems to be more competitive than role in L5.

TC $114k- Base AMZ- $73k +$38kstocks ( vesting 17k$ due next year)

TC $135k Base PWC -$81$ + Bonuses ( 50k$)

Looking for managerial skills which the PWC role avails, and L6 promo doesn’t seem to be happening soon in current role. I’m also mentally stretched. I hear WLB in PWC is just as busy but can anyone confirm if this move makes any sense. Google Amazon

likefunny

Hii Guys, Could anyone give me some clarity on the below point. I have cleared 2nd round of technical interview at Deloitte, but my candidature is still showing as interview in progress at Deloitte careers page. I had a discussion with HR on this and she told me that next process is pending from management side. It's been almost 10 days since from 2 nd round of interview. How much more time does it gonna take, any idea? Or is it normal. Please help me with this 🙏🙏 .Deloitte

like

In my application to McKinsey, do I include past unpaid internships as Work Experience?

like

As a chemical engineer, I have a lot of job opportunities, but as a recent graduate, I have had a hard time getting my first job. After my internship, I have only had 3 interviews. Does anyone know about any job bank for chemical engineers?

like

I had a job interview for a role that I really want. The hiring manager scheduled me for an interview and did not show up. Emailed me an hour later stating that he got super busy and couldn’t attend, and would like to reschedule. This is a major red flag, but I can’t help but feel that I am missing out since this role pays 50% over what I currently make. Should I let the recruiter know? What’s your take on this?

like

Folks if ur looking for referral in EY across the globe then DM me with requisition job ID.

Must not applied or attended interview in past at EY

Only above fullfilling folks DM me

like

I am working in a service based company and got selected to work for Amazon india project (which is our client) after 2 rigorous rounds of interview. How is the work there and wlb. Is it worthy. Tech stack Java, Springboot, Aws.

Hello Fishes, I have given Data Analyst test on Hackerrank for Morgan Stanley two days ago. Can anybody tell me in how many days they will revert back.Morgan Stanley

like

More Posts

Hey guys I have been in sales for a while now 2 years in real estate and about 5 months in insurance. How do I get started in tech sales?

like

Is anyone here working in Whatfix or have given interview for this company?

like

Hi folks,
Help me to choose between OpenText and Stryker with respect to job security and WLB

Does UKG provide joining bonus to new joiners ? If yes, to all joiners(2/3 month NP) or to only early joiners (1 month NP) or immediate joiners(0-15days NP) ?

like

O&M Creative: more shuffling still to come? And by shuffling, I mean layoffs too.

like

Accenture
Tata Consultancy
Infosys
Wipro
Now forgot market correction meet recession. 😂

Post Photo
likefunny

I need some new boots. What are y’all wearing these days?

Post Photo
like

Is this a good point?
When evaluating the IRR of a new project, the corporate tax rate falling from 35% to 20% really only helps by 1.5-2.5% points. Therefore, it won’t change inv decisions that much

like

I wanted to know if there is any opening for 1 yoe Java/backend developer.

Wondering if anyone here works on the technical side of blockchain that would like to serve as a speaker for university students?

like

What is a typical AVP salary + bonus structure at CitiGroup? In Mississauga, Ontario.

like

Hi
Can anyone help me how should i explain my project on which i worked in my current company to the interviewer.would be very helpful if someone can help with the basic format from start to end or else can give example of their own project.

Thanks in advance

like

Can anyone post today's mail about - No need to come office statement?

Post Photo
like

What is the expected date for Promotion news in GDS Knowledge?

like

Does anyone know of a good place online to look for UI/UX designers who specialize in Figma?

like

How much will be in hand ?

Post Photo
like

HI..I'm currently working as a analytics consultant in India and i'm about to get offer from Deloitte UK(Risk advisory). How much salary i can expect for a manger or senior manager.

Along with Salary what should i ask during salary discussion

YOE - 9.6 years

Any advise will be a great help

like

Are there any certifications or comprehensive courses for attorneys looking to break into blockchain?

like

Anyone have any favorite office decor or personal items? Trying to think of things to make my office less boring now that I'm going back in.

Feel free to share anything interesting that you've seen as well.

Currently thinking plants and potentially wall art.

like

Additional Posts in Data & Analytics Consultants

Happy middle of the week. May your pilots show lift.

Post Photo
likefunny

I have created Algorithmic Product/System for the client to take out inventory not-in-demand for long time to save storage expense and also provide an approach to prioritize Work Orders based on Market Demand. It’s more like an Manufacturing Plan. I want to get into Product Analyst/Lead role. What approach I should take? Any books to start with? Any events to attend? Any groups to join?

like

What is your best advice for moving into data science without going back to school for a masters?
I have an engineering bachelors and my mba, and want to move into the data science and analytics side of things in the long term.
I’m currently in Strategy Consulting and I find it too functional and hypothetical/theoretical/ high level. Looking for advice on resources, timelines, skillets, building connections/network, things to consider, moving forward /path of last resistance, etc etc

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

What approaches have you used to enforce data consistency for ML services? System and conf tests can be written definitively for SW applications but it becomes challenging when Data variability exists ?

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 engineers can now automate the writing of basic code, and potentially more complex tasks, by using GPT-3.

For those who are technical: If machines can write code, how are you going to upskill? And what are the best ways make yourself indispensable?

I am not embracing the notion that you shouldn't have to code to do data science. However, I think coding may soon be much less of a competitive advantage.

like

Looking for experienced Data Scientists and ML Engineers to grow my team. I’m head of Machine Learning and Data Science at one of the largest Fintechs. Shoot me a message if you’re interested. (ex consulting manager) Thanks!

like

Folks,

Any resume site / recommendations for an analytics focussed resume I could get some inspiration from?

Been on my job for 7+ years - a bit lost as to articulating my experience effectively. I have a resume, but don't think it strikes a chord with recruiters.

Please help!

like

Does anyone work at EY in their Decision Modeling team? Not asking for answers, but just wondering if someone is able to share what concepts I should be familiar with when prepping for the case study (i.e. do I need to know how to run an LBO or is a DCF sufficient)?



like

Anyone in a non-technical analytical consulting roll?

like

I'm planning to transition to Data Science. What should be the key technologies that i need to learn and add to my resume to make this work?

Thanks for your suggestions.

like

This might be a long shot ... but I have a Statistics assignment due for tonight in a few hours

Does anyone know how to do Linear Discriminant Analysis with more than one predictor - by hand? I know how to compute in R but my professor wants it done by hand .... fml

likefunny

Mεntal mαth in iηtervieωs. Thoughts, tips, rants, grievances?

like

How did you ramp up into doing actual data science work at your clients?

I am early in my career (3 YOE), but I have a masters degree, cloud data science certs, and strong Tableau/Alteryx experience. However, it seems like a lack of experience doing actual data science client work is what keeps blocking me from landing on data science projects. Any tips?

like

How advanced in SQL are users here? I feel like I’ve “plateaued” and am worried about not developing further in SQL skills.

like

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

like

Has anyone created live dashboards via Data Studio instead of Tableau? Thoughts?

Interview for a Data Analytics consultant role and have been told there will be white-boarding exercises. How would you prepare for this? I’m guessing it will mostly be SQL but don’t want to assume.

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