I have an on-site interview coming up. it's a business intelligence analyst position that requires advance SQL skills. how do I train myself in 10 days and crack the interview? my level is around 3/5.

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

Kaggle hosted a pretty great SQL summer camp - check that out! 4-5 parts and pretty easy to digest

like

Advanced SQL skills = Different types of joins

like

Make sure you know aggregation, derived tables, temp tables, views, sub query, unions, etc. You probably have that at your current level. I would also be comfortable with stored procedures, loops/cursor, functions, automation, ODBC, and access. Some of that starts getting into more DBA area, but good information to have in your back pocket.

Which platform? Oracle, MySQL, SQL Server, Teradata? Various syntax and some capabilities difference between those.

likehelpful

Look at me momma, I know how to SELECT!

- Advanced SQL practitioner

funny

Udemy? Coursera? It might be worth taking a look. Good luck, OP! You got this 💪🏽😁

like

How advanced are we talking here? 3/5 sounds like a great base, very doable.

that's the part I'm not very clear. what advance stands for in the industry? all JD says advance SQL but not sure what they mean

Read through some complex sql queries and also read any interview book on sql if its available!

Related Posts

Hello Fishes - Have received offer from Citibank for C14 ( SVP Data Science) role. Offered comp - 220K base. No signing bonus. Bonus range -20%. Location - NY. Is this good offer? What is range generally? Citi fishes please help !!Citi

like

Any insights or tips for CMAAS senior associate interviews?

like

What is the designation and salary Societe gives to 3.4 to 3.4 years experience.I was interviewed for Python.Also let me know if we have to work in shifts?

I interviewed for an employed role and knocked my business plan pitch out the park, but could tell I disappointed them with my technical. By my own admission I’m lacking in this area as only have 1.5 years experience with a poor manager who only had me focus on biz dev.

They asked me what my salary expectations are but had already hinted my experience would knock me down a pay grade.

As it was 4 of them and 1 of me I said I would email them. How do I play this without lowballing myself?

like

I’m currently interviewing with a few top 10 firms and a couple top 100 firms for a mostly remote experienced associate/new senior role. Does anyone have any tips on virtual interviews and how to gauge the culture of the firm and if it really will be a good fit for you? I’m struggling to figure out that out because I used to gauge it on the feeling I got while in their office during interviews. Any suggestions would be helpful :)

like

Anyone here has insights on AWS business development manager role for PE clients ? A recruiter reached out and the role looks interesting. Curious if it’s all sales work ?

like

Anyone have success cold applying for VC roles and not in MBB? Just submitted an app last week and they should be reaching out this week, but I’m not sure how long to wait before giving up…

like

Hi fishes!
I have received an offer for Senior Software Engineer.
17.5 L gross salary, 3 YOE.
Can you please tell me if it's a good offer , and about SSE role in general .

like

I'm early in my career, managed to save $30K to invest, and want to get my hands dirty with a rental property without too much risk (e.g. no HML/flipping). It sounds like that's a tall order in the NY/CT area given the prices, not to mention whether I'd be able to get a mortgage on anything below $100K, but I figure I'll give it a shot anyway. Any advice on what you might do in my position? Am I being crazy with this idea?

like

Any advise on role, security, growth for 12+ yrs experience in SAP ABAP in LTI. Which band and how much CTC ( fixed and variable ) can I expect for the same ?
Current CTC : 20 (F) + 2(V)

like

I have 6.8 YOE in compliance as financial analyst. how much CTC can I expect in UBS If applying for AO level.

I have cleared interviews at UBS with tech stack SAP BW4Hana, BOBJ, Native Hana, SAC etc. And with YOE = 7yrs. What is the maximum CTC I can get at UBS; if my CCTC = 19 LPA Bosch Global Software Technologies

I’m currently in SMB insurance sales for 2 years but I want to move into AE role that has a base around 80-100K. I’ve been looking at SaaS sales but I feel under qualified, do you guys have any recommendations that meets my base I’m looking for? I prefer to get out of insurance. TIA

like

Hi friends
I have been working with Oracle since four years in a sales role my total experience is six years
I am keen to change my career and move out of sales can someone suggest what all options are available after having been selling IT solutions
Your suggestions and advices or highly appreciated

like

Hi all,
I m into QA as functional test planner for more than two years and now i m mood to change my role to automation, but after certification in selenium and Tosca my lead was not able to provide me the project based on automation so they are rolling me off from the project. Telling u will get automation project on bench.
Now i m confused what had happened and what to do on bench.
Please help me out here cause I m finding it too difficult here to change the role.
#accenture

like

Hiii All, I'm a new fish and seriously looking for a new position in HR. Can anyone please refer me in India. I'm in a crucial situation and I need a job immediately. Currently working in Allianz as an Associate.

Post Photo
like

What is a typical salary range for a HCOL consulting manager position at some of the national firms (Grant Thornton, BDO, RSM, CLA, etc.)? Anyone?

like

Hi fellow nurses! I am an Emergency Nurse with 3 years of nursing experience to include med -surg. I am looking to transition to a lower acuity position such as pre op, or honestly work remote as the work life balance is not fulfilling for me. Any recommendations on hospital jobs that are less stressful or any companies that offer competitive pay to work remote? I make 38/hr currently and would like to maintain that rate. Thank you!

like

I got my offer last year to join in Sept this year. Recently, I was made aware by people in the firm that there is an increase in salary across the board including my role. Some people joining the same role have received a new offer letters, but I didn't. How should I write to the recruiter to ask? (it's a significant increase of ~20% 🥺)

like

My company, Pegasystems, is agressively hiring for Senior Solutions Consultant (presales) positions nationwide. If you are interested in working for an amazing company with market leading products and a great culture, please message me. Happy to discuss further. Assuming you are reasonably qualified, I can provide a referral as well.

like

More Posts

Is the amazon application status of active vs archived (not in consideration) accurate?

like

How is the EY Chennai office?
I am planning to move to Chennai EY from Pune INFOSYS.

Any rough idea on the cost of living in Chennai for a bachelor?

Offered CTC by EY 11lpa + performance bonus of 10%.

like

Hi all, I joined in Ibm on August -2022, but i am still on bench, is there any maximum time limit for sitting on bench, I heard lot of people are on bench, please help me to know the details

like

Just got out of one of my final round interviews. It’s been over 8 weeks of prep. Got a little nervous and may have messed up on the case, PEI went okay. Have the other later this week. Trying to focus on that but difficult knowing how this performance would impact the outcome. Has this happened to anyone and they ended up getting offers? Searching for success stories or tips.

like

3 YOE, including 1 in consulting. what level would/should I aim to join McKinsey at? Currently a C at Deloitte.

like

Do you always need an MBA to get into MBB?

likefunny

Layoff in IQVIA?
@iqvia

like

Thanks to production, I’ve now tasted every Lacroix flavor. 🤙🏼🤗

likefunny

just got a full time graphic design job. is there any reason why using the work-provided adobe creative cloud account for personal use is a bad idea? like privacy or something? i’m thinking of canceling my personal subscription and saving some money.

like

Is there any profile which is based on purely SQL and nothing else, no excel/tableau/powerbi task.

like
like

Anyone looking to replace their Cisco Prime Collaboration Assurance tool (PCA) which is coming End of Life? What are you considering?

like

About to give Raven a drink and noticed her new growth.. So beautiful🖤💚

Post Photo
like

I would love to get this bowl/forum up and moving again!
How is everyone in the ServiceNow space doing these days with covid ?

smart

Has anyone successfully managed their ADHD without medication? Looking for homeopathic remedies or tips

like

Egg nog has hit the shelves, weight gain here i come!

likefunnyupliftingsmart

Stupid Question- We have been thinking for IVF and trying to understand with this process, is there any difference in the health and life of the child as compared to a child born without IVF. I did ask this with our doctor and he said casually its all same. This is not to question any doctor but just to really understand what is going to be different with the kid. This is not very old technology and not much studies as well.

like

Hello, I am a a23 year old who just graduated with a BA degree In Cyber Security. I have two years of cyber security experience that is mainly focused on vulnerability management and user awareness training. I have recently accepted a job as an IS engineer for 65k but am now thinking about leaving after only two weeks due to the fact that I don’t enjoy working for large companies as you are so segmented. I also realize that 65k is low for cybersecurity. What should I target for my next to role?

like

How many times is too frequent when you speak to your coach / team about manager promotions?

like

Additional Posts in Consulting Exit Opportunities

Phone screen with Accenture Federal Services this week. Recruiter found me on LinkedIn and set up 30 mins on my calendar to chat. Said camera is not required because it will be a casual chat. What should I expect here?

like

Any insight into finance manager role at Microsoft? Total comp, growth opportunities, WLB?

like

Seems like consulting is becoming less and less of an attractive field to be in, and people are leaving the industry in droves. Is this because of the pandemic? What gives?

like

Was contacted by a sourcer for a big 4 firm. Five minutes into the conversation about my background she says we can’t move forward because it would be a conflict of interest since I sub for that company. Is there a way to get around this or perhaps a cooling off period? Thanks in advance.

like

Will pay someone good $$$ to help design a PPT for me. Shouldn’t take more than an hour!

like

Interviewing for a Visualization Developer position at EY. Any tips?

like

What’s the difference between a program manager and product manager at Amazon? Is comp different?

like

I’ve been proposed an exit as Product Owner at a real company, not a consulting one. Staff seems nice, good culture, good salary (less than consulting but well), BUT I would have to move countries for that job and start a new life.

I’ve also been proposed a Manager position at a consulting company in my home city, with potential of bigger salary thanks to bonuses. Culture seems good... But I’m sure it’s gonna be a hell lot of work.

Which one would you take? Should I exit and never look back?

like

Ex-McKinsey EMs or ex-BCG PLs, at what level did you enter google? Being offered an L5 and want to make sure it’s the right level

like

Anyone from Booz Allen Hamilton willing to provide a referral?

like

Fellow 🐟 any thoughts? Received an offer from Deloitte -> Role Manager, Base 180K HCOL, YOE 8, Current Base -> 150K and may get close to 160K in 3 Months. Is it worth the jump? Pros in current role -> High Visibility due to small practice, 45 to 50 Hr work week. Will be SM in next 2 to 3 Years, Cons - TC, Brand Value, Mid Tier Clients. Any opinions?

like

People who pivoted/trying to pivot to PM - what resources did you use/do you recommend? There are some online courses or boot camps that have $1-2k tuition fees - worth it? Which ones are worth it?

like

How many YOE required to apply to Google technical program manager role?

like

When people refer to e-commerce exits they are typically referring to platforms like amazon. If I’m more interested in working for an e-commerce store/seller rather than a platform is there a better term for this so I can research better?

like

Does PwC let you use your own card for business travel?

funnylike

If you’re applying to a company that was a client of yours, how do you disclose that (if you’re even able to?) Assume I shouldn’t be mentioning their company in my resume?

like

When asked by a recruiter what your salary expectations are (5YOE, 1 in consulting) what is acceptable?

like

In a Big4 deal Analytics group that’s not premier with no path to partner... should I try to move to MBB/T2 to gain traditional consulting experience or try for tech/FAANG... I just wanna make money

likefunny

Hey Fish Fam, I am about to put in my two weeks notice at a Big4. Going to industry. Any sage advice or pointers on what to say and what not to say/do? I really enjoyed working at B4 and made amazing network of supportive colleagues however this opportunity is way too good to pass. Any help is appreciated, thanks!

like

Anyone leave before their bonus (before knowing what the amount was) and then regret it when it turned out to be a huge bonus? Got a great offer that I want to take but feeling FOMO by leaving the bonus on the table.

And yes, I tried moving the start date and asking them to cover the lost bonus but they said no and it’s still a better offer and it would be irresponsible not to take it.

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