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 know onboarding url for tech Mahindra and where can I find an offer letter.. yesterday i called HR for my offer letter status they said url is not working .. can i trust that statement or they put my offer on hold?

like

Hi! Anyone gave google’s backend developer interview ?

like

I have got an email from IBM regarding Compensation Discussion Documents after completing technical discussion. I've competed PDM discussion as well. Does this mail mean I'm shortlisted?

like

If a recruiter keeps ghosting me & I have to keep reaching out to get a status. does this mean I’m not being considered & I should move on?

like

Hi Fishes... I have cleared interview with Infosys technical round, filled application & uploaded and there was managerial telephonic round scheduled on Friday... What wil be the expectations... My skill is SAP SD with 5 years of experience... Your inputs will be valuable and helpful... TIA..

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

Received a verbal offer but Microsoft contacted me for an interview. How likely is it that they would expedite the process for me if I asked? Any tips or thoughts from Microsoft 🐠 is much appreciated. Thanks!

like

It's appalling how bad new associate excel/ppt skills are. There needs to be a way of judging 'readiness' during the interview process.

like

What is the chance of getting cerner offer letter after clearing 2 technical rounds? Notice period is 3 months. Documents shared with HR. Waiting for offer letter.

smart

RECRUITER (when you post a creative job opening on LinkedIn for a friend's agency): HEYYYY, old friend! Do you know if this agency is using an outside recruiter for this position and if not, could you connect me to them?? Thanks! XOXO! OWE YA ONE! :)

THAT SAME RECRUITER (when you contact them about a creative job opening that *they* themselves posted):

like

Hi,

I Got opportunity to give exam for PWC for 1-2 YOE Java Developer for Cyber Security. I can see rounds mentioned as Hirepro Test, Technical Interview and Partner round.Can anyone suggest what topics should i prepare for?TIA

Guys if you don't feel jealous then can anyone share the definition of coding questions which are being asked for reactjs developer assessment exam in these days ??

funny

Has anyone attended DevOps Engineer interview with TheMathCompany

like

When the recruiter from the big four asks how much I’m looking to be paid being how much should I ask for when negotiating and what is a number that I can get away with? I’m currently a senior audit associate with 3.5+ years experience. I’d be applying for a senior associate position.

like
like

What are the chances of Amazon (or FAANG in general) allowing you to apply/interview again for a position that you did not get in the past?

like

Accepted a new job at competing Big 4 but got a message from a recruiter from MBB. How do I respond to the recruiter? Is it worth it to take the call and be honest with them?

like

Can anyone provide a link or resources for best recommended resume templates for product managers trying to get into FAANG companies? Thank you!! 🙏🙏

like

Hi guys :) Glad to join fishbowl and this community. Guys I have an offer of 14.41 ctc from a big 4 (11 is fixed).
Technology-Microsoft Dynamics 365(I am a functional consultant in SCM and HR; Relevant exp: 3 yrs & Total exp: 4 yrs).
My interviews in
IBM are done and I am waiting for the salary discussion with HR.
What is the likely offer that I am going to get? Any idea? (My expectation is 16.5 lpa ctc). I will adjust my expectations as per replies here.
Any response is highly appreciated :)

like

Hi, how much can Barclays offer for a BA4 Data analyst position with 8 YoE and current fixed at 13LPA? Have an interview round this week, what questions can I expect? Please pour in some suggestions, thanks guys!Barclays

like

More Posts

YM Update: The 8 AM selloff was impressive. It went right to the 61.8% line . . . admittedly my last add after taking two other shots in between the 50-61.8% line. Weakness into close, see rebounds.

Post Photo

Anyone at Google willing to give out a referral? I’m looking at some Product/Strategy roles. DM me.

likefunny

Is Huron hiring right now?

like

Medicaid plans are so dysfunctional. Has anyone else experienced this? I feel like I’m being gas lighted after working for big commercial enterprises and now working on a Medicaid plan. I’ve never seen so much resistance to change or legit resistance to doing anything to improve operations.

like

Has anyone here know what is like working at the Mayo Clinic?

like

Where in Healthcare Consulting can a registered nurse succeed? I read about healthcare consulting companies and the services they offer and they appear heavy IT/comp-sci based. What are healthcare consulting specialties where an RN can leverage their clinical background?

like

What’s a “science fact” that gets shared around that is very much not true?

like

Hello everyone, I have 8 years and 3 months of experience. I am working at TIAA GBS PVT. LTD as network security engineer from past 2.5 years. I got an opportunity in Silicon Valley Bank in Banglore. Got an offer of 30 lakh pa ( all inclusive). Just wanted to know the review about this organisation. Hows is the work culture? Need your valuable opinion about Silicon Valley.

I have an offers of 25 lakh from BT noida. Thanks you all.

If your doing Creative Curriculum here is a cool clothing study activity

Post Photo
like
like

Will we not get any diwali gifts from Mindtree?

Mindtree vs Infosys , which one to chose.. same package. Job security and work life balance are main.

like

How is the Change Management Analyst L2 work, role and responsibilities?

Do Nooglers receive salary increases? And if so when do you find out?

like

Please suggest what is the work exposure like in KGS - FDD consultant role?

like

Planning to buy a condo in 451 W Huron - Yay or Nay? Will live for a year and then rent it out. Don’t want to renew lease another year.

like

Received a verbal offer but Microsoft contacted me for an interview. How likely is it that they would expedite the process for me if I asked? Any tips or thoughts from Microsoft 🐠 is much appreciated. Thanks!

like

Relocating to NYC. Lived in crappy FiDi, Gramercy and UES apartments at beginning of my career. I have been away from NY for a good while and would like to know what’s the downside of living in Jersey City? Now that I am able to afford Manhattan, the price and space you get in JC is weirdly becoming appealing. Thoughts on the location? Will likely be working from home 3 to 4 days a week.

like

Anyone have had any luck buying a diamond (for an engagement ring) directly from a wholesaler in NYC? If so, which one did you go to and what was that process like?

As a new product manager what books should I be reading? I’ve already read Inspired but looking or more. For context, I’ve joined a series A start up and as expected there’s a lot to do and it’s very fluid. I want to be able to help the head of product as much as possible as well as provide some structure to how we work.

like

Additional Posts in Data & Analytics Consultants

Has anyone else begun to resent data science?

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

Anyone have any suggestions for front end guis for users to run python code? I’ve created a few tools for webscraping data, automation, and modeling but non technical users freak out when they try to run the code themselves. Any suggestions? (Have tried Juypter Notebooks and a few other IDEs)

like

The longer I do this job, the more I want to accept a tech job... no travel, same / better pay, no annoying clients...

like

Big 4 Data Scientists, how did you exit to big tech firms? I’ve been unlucky with online applications and even referrals. I think it might be my resume or how I present myself. Can any free birds please give guidance?

like

How should I move to tech as a ML Engineer? How did people here make the transition?

likehelpful

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

What is a data lake in basic terms?

like

Hi! Does anyone know what kind of knowledge is needed to crack the Data Scientist interview at Google?

I'm currently working in Marketing Analytics (primarily using SQL and a bit of pyspark). Apart from mastering SQL, I wanted to know from people working at Google what does it take to get there as a Data Scientist? (I'm very interested in Strategy Ops)

I plan to another 6-8 months in preparation and upskilling myself before I even apply.
Any help and guidance is appreciated! Thanks :)

like

Anyone know of an alternative to StackOverflow for asking tech questions? The community is super toxic and I'm looking for a place I can casually ask questions that might seem dumb without being hrangued for not providing an essay proof of the research I've already done. Or some sort of buddy system where I can ping a person of relevant experience those questions. It's better to poke someone's brain for a minute than to spin in circles reading docs/dead end articles sometimes.

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

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

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

Single book recommendation for user research?

Goal is interview prep. Ideally focused on applications in tech.

like

Anyone here work or has interviewed for a data science role at DataRobot? Would love to get some insight. Third interview coming up.

like

Anyone who has done masters in business analytics Singapore? Could you help on courses, Scholarships and careers and jobs. Looking for help.

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

1) Hypothetically if you were looking to sabotage a colleague, can you code an excel document to throw off their numbers or calculations, (if you send them that document and they download it for use)?

like

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

like

Anybody interviewed for a data engineer role for Facebook? I have a SQL and Python coding interview next, any idea on what to expect?

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