I have a technical skill interview where I need to show an interviewer my knowledge of SQL. Can anyone help let me know what kind of questions I should prepare for? I want to make sure I’m as ready as possible and never had to do one before

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

Windows, date time, CTE functions, joins

like

Try practicing with statascratch or interview query. They have real examples of questions asked

like

Don’t forget to understand the flow of execution of SELECT, FROM, WHERE, ORDER BY, GROUB BY, HAVING, in any given query which would execute first and which would later and the whole sequence of execution.

likehelpful

Join types( left join, cross join, outer join) window functions, type handling, temp tables, CTE functions, RANK() vs DenseRank() vs Row_Num() , for and while loops, object declarations, case when statements

like

As you're applying for insights manager, I would assume you have enough SQL knowledge as a prerequisite to application..

like

What’s the level of the role? (Entry,mid,senior) I think the most important ones would be Windows, CTEs, Joins, and Case statements. I used datalemur to practice

Insights manager

You may want to sprinkle in understanding of PARTITION BY as an insights manager

Related Posts

Anyone here from EY ? How’s interviewing there? Help EY

likefunny

Does ibm GBS send hacker rank test for recent candidates(java)?I joined 2 years back at that time there was no test at that time.Any one has an idea?

like

Anyone had good multiple offers and had one the hiring managers pressure you into taking the offer after asking for additional time to think about it?

like
like

I had very positive feedback on my interviews for a S&O role but the team hired someone internally. If I interview again for a differenr role, would I have to do all the interviews again or can I use some of the scores from previous interviews. I understand doing RRK again makes sense but what about GCA, googlyness or leadership . Thank you

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

Small law firm in Westchester, NY looking to bring on 2 associates (1 litigation 1 transactional). having difficulty finding the right candidates and interested in engaging a recruiter. Just looking for some direction or recommendations. Appreciate any guidance- thank you,

like

Anyone else feels that the Talent team at @Mindtree is sshiittyy? They don't give us updates after interviews and hang us in limbo. They don't have the courtesy to respond to messages, calls or emails. Can someone suggest how to highlight this?

likehelpfulfunny

Hi Guys I have joined Publicis Sapient with interview on .Net Core and Cloud but now doing support legeacy job any suggestions what to do? anyone else in similar boat Publicis Sapient

Is “Hacking the Case Interview” any good?

like

I’m interviewing for a marketing manager role at a company based in SF. I’m genuinely excited about the role and the company but we’ve yet to discuss salary. I expect to be asked at some point, but my research has given me a VERY broad range. So I’m here to do a bit more research. I’ve got 5 very relevant years of experience and will have an associate manager directly reporting to me. Are there any marketers out there who can share their salaries in similar regions and experience levels?

like

Hello Deloitte 🐠 20 YOE. Have referral for a content and marketing M role in cybersecurity -- the focus of my career pivot. Submitted my application today, but my referrer isn't in Cyber. Interested to widen my Deloitte Cyber network to get my resume in front of a human, since ATS has no vision or imagination. If you're willing to connect, please DM. So far, made it several interview rounds into roles with EY and Accenture. Optimistic, but want to be as proactive as possible. Thanks!

like

Hello there. I have been interviewing with Okta and got through all 5 rounds of interviews. They say they want to offer me the job but there is a global freeze for all marketing roles at the company. They want to offer me a contractor role instead. Does anyone here know if that is the case? I haven't heard anything as they seem be on wellness week. Thanks for any guidance :)

like

Recruiter shared post on-site feedback and she mentioned that she would like to do the team match and do 1-2 additional rounds of interviews because the feedbacks now are borderline and have a very low chance of HC. Any team here who's hiring SAP Program Manager role? Please kindly keep in contact with me :)

like

Hello! Would anyone be able to help me with a referral within @Lumen? I have my preliminary HireVue interview submitted and am so excited for the potential opportunity. Thanks!

uplifting

How much can Gartner can pay me if my current CTC is around 14 No offer in hand Tech Stack - Java , Spring Boot , Microservices YOE -5.6 Position i am getting interviewed for - Senior Software Engineer

like

Interview lined up with Flipkart for business finance manager role what's the salary band in this role. Am a qualified CA currently working with swiggy YOE:3.5 Flipkart Swiggy

Hi Friends, Hope you are doing well ,
I am interested in Operation Manager at
AWS ( Cloud support / premium support side ).
Is there anyone who can help me for interview prep. Am happy to take paid trainings if necessary Amazon AWS Amazon Web Services

like

Hi everyone ,
Actually i have been interviewed in Accenture .
Everything has been done even salary discussion is also .
1-assessment and i got the completion message and confirmation
2-after that interview went very well
3 - hr discussion with salary , ready to initiate my offer in 2 hr
But she called me in a minute on Friday and told me that you need to give the test again.


After 3 days on monday -today
Someone called me from hr and told me you have to appear for all the things again.

like

Did anyone get interviewed for enterprise architect position at Collibra. Would like to know the experience and the process.

like

More Posts

Does Oracle Cover Dental Insurance? What's the coverage and limits?

like

Hi all,
Any suggestions or advice will be really helpful.

Post Photo

How long does it take to create a business on paper, officially?

like

I am a ft interior designer, full time mom that also does part time photography on the side. I currently make 90K as a designer and bring in around 20K as a photographer/yr. My design job allows for me to work 100% remotely which helps with daycare pick up and drop off. I feel like I am not making as much as I should as an interior designer PM, and I have spoken to my higher ups about a pay raise with no luck since the pandemic hit the coliving residential market hard. *Continued below*

like

Accurate description of how most folks here view themselves

Post Photo
like

I’m looking for a Roche referral for a DC based policy role. My previous experience is global policy at WHO/PAHO & Executive Branch.

like

I’m sure this is a noob question, but I want to buy my first luxury watch... what should I go for?

like

Hi guys,
I have 2 years and 6 months of experience in Manual, Automation and API testing.I have a couple of interviews coming up. What is the package that I can ask for ? Any help would be appreciated.
Thank you.

like

Exempt Salaried employees, do you get paid overtime? How many hours do you typically work?

like

Would you report a neighbor that hit another neighbor's car or mind your business? New to Seattle and not sure what the code of conduct is around here - mind your business or be a good neighbor 😅

like

Any big law associates looking to transfer out of Texas in light of the new laws repressing women's rights? My firm has an office in Colorado and a group of 4-5 of us have been discussing transferring today. Rent/Housing is roughly the same in the two states.

likesmarthelpful

I’m struggling with the automation tasks I’m given (primarily Excel) but don’t exactly know what programming skills I’m missing to go learn them.

like

I just found out how we can solve all the "supply chain problems." Maybe people could... like... order things a week BEFORE they needed them? SMH

likefunny

Social media managers — can I see your portfolios? Or any advice on how to showcase a portfolio in terms of what platforms to use etc.? I’m looking to create mine!

like

Need advice and help.

I have realized I grew up in a household where my dad did not treat my mom as an equal. He belittles her, is rude and convinced his way is the only way.

It is painful to say, but some of this shows up in me and in my relationship. I am starting to catch myself, and it to me seems to be more of a reaction than anythjng that is ever intentional.

Wondering if anyone has dealt with something similar, and any success in making changes besides therapy. Cont. in comments

helpful

Hiya! I was wondering if anyone here has any good recommendations in terms of books or learning material that I can pick up to learn about sales and marketing relevant to the consulting industry?

like

Notice there are so many people with debate experience in consulting. Kinda impressed. Any highly recommended books related to debate or communication in general?

like

Hi everyone, applied for an investment consulting internship few weeks back.
It's a client facing job, but it might come at a later stage of a job, maybe after finishing my internship and getting a job offer.
I'm interested to know what is the must develop skills, must take courses or must read books to get insight, develop the required knowledge and skills for the position. I majored in business management finance and currently preparing for CFA level 1. Thanks in advance ☺️

like

Has anyone ever asked to renegotiate their salary after starting a job? I’m 2 months into my new job and I have far more responsibilities than what I was told. It’s a lot different than what was relayed in the posting and during the interviews. Additionally, they hired my counter part in as a senior manager which is at least $30k more than what I make. My peer has more experience so I expect that but I feel that I should be paid more, however I don’t want to leave a bad impression… any advice?

like

Additional Posts in Data & Analytics Consultants

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.

Can anyone at Ford Motor Company tell me more about the “Learning Analytics and Engagement Specialist” remote position? Very curious and would love a referral!

like
like

Could anyone recommend a set of indices that are publicly available and is a good predictor for consumer spend in home renovations ?

like

Noob question - I want to consolidate the dates into a single dates column. Would numpy or pandas help me reorganize this dataset effectively or should I do it within excel?

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

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

What’s so good about the Georgia Tech OMSC and OMSA? Is it just the cost? Seems to be recommended by most of reddit

likehelpful

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

like

Have you ever failed to deliver? What was it and why?

like

What is Accenture’s data scientist interview process like?

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

McKinsey & Company Does somebody have experience regarding
compensation differences between
QuantumBlack & McKinsey? I am in the process at
QB and disappointed with the salary that's
proposed. (New grad Data science from top
university applying for London) McKinsey & Company QuantumBlack

like

Hello, Anyone here from Deloitte Omnia AI who could refer me for an open opportunity.

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

Looking for an entry-level data analyst position in the DC area. Have a BA in economics & certification in Computer Science. Also 3 years of professional work experience as a full time marketing manager which I performed while attending school full time. I’m a self-starter and extremely driven. I also have a passion for data and statistics, and plan on pursuing my MS in data science within the next year. Please let me know if you know of any positions! Thank you.

like

I was hired a few months ago by D to do data science. I am not doing data science currently, is there a way I can switch roles internally? Should I talk to my coach? Or should I just start looking for a new job. I’m starting to feel that the field is so hot rn my small stint at D won’t be a big deal to other firms.

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

Anyone use Cloudera? What has your experience been like?

When industries refer to business intelligence engineers, are they looking at a senior level or entry level? Some of these job descriptions seem rather outlandish in terms of years of experience required like 5+

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