A SQL interview coming up. Any resources or suggestions?

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

How in depth are we getting here? At a bare minimum I would recommend that you know about types of joins, grouping commands (count, average, sum), difference between primary and foreign keys, and what an index is

What ET said... That's probably the bare minimum.. another bare minimum I'd think of would be problems such as Cartesian jobs etc if join not identified correctly, etc..

Btw, what Fin/S&T/IBD role has you interviewing for SQL?

Related Posts

I cleared my technical round, after that they gave me an assignment, which I also completed.
Now they send me an invite for product manager round. What will be the questions asked in this round?
Stack - Software Test Engineer (Automation and Manual)
Exp: 3.8 Years
This one for startup.

Looking to venture an opportunity with Nike anyone has a timeline of how their hiring processes are like for corporate roles? (eg. from point of 1st interaction to offer)

Thanks in advance everyone!

like

Any tips on how to approach a life story interview at Shopify? I heard it's a one hour long conversation that touches upon personal and professional experience.

like

Hello Everyone I've been shortlisted for Knowledge Analyst Healthcare role in BCG. I'm told there will be two Case Study Interviews. Can someone tell me if they know about the types of Case Studies i can expect in these two interviews. Thanks in Advance.

like
like

Anyone got any advice on recruiters? Do they actually add much value, or are you better off going direct to the big consultancies?

like

Wondering what people think about my situation. I’ve been offered a role with a company. The job description didn’t mention college degree as a requirement. On my CV I have a section listed as “Education” and under it I have “Business Studies” with the university name and the 3 years that I attended the course (2.5 to be exact). It’s a 4 year degree and under this I have my High School equivalent with the years I attended there. The education wasn’t mentioned in the interviews. Continued below.

like

I am an email marketing specialist. I am approaching my one year at my new job. I have been going above & beyond. I have been recognized by my boss that I have been doing great as well. I have been implementing new strategies, completing all assignments on time, and I do the most in all of our meetings, interviews and business events. How much can I ask for a raise?

like

Has anyone attended DevOps Engineer interview with TheMathCompany

like

For the people who earned the SHRM-CP, did you feel it was worth it? I have an indirect HR position, been applying for more HR focused positions and wondering if this would help. I got the CAPM (certified associate of project management) in December, but that hasn’t really changed things. Would love some opinions before working on another certification!

like
like

Hello! I am interviewing for a new position with my current employer. It is for a senior contract compliance audit manager position. Any tips on what types of questions I should be expecting? Anything I can do to set myself above the rest? Thanks!

like
like

How do people get interview call from Accenture Strategy & Consulting? I am an MBA from tier 2, 5 YoE post MBA in Financial Risk. Currently working with a Big 4.

like

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

like

How is Delta Airlines client interview questions?
I am a Java + Aws developer

like

Hi Fishes,

Anyone here from
Tiger Analytics can guide how much salary can i ask in HR discussion round fro Java, SQL developer (Analyst) having 1 yr 10 month of experience in Java background?

Tiger Analytics Accenture Cognizant Infosys

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

How many days does it take to receive the offer letter?
Last Thursday HR confirmed my selection.

like

I’m interviewing for a solutions architect role and I was invited for a 2nd phone interview. Is this standard practice or is it like Google when the 1st interview has mixed results and they need another one to say go/no go?

like

More Posts

What kind of role is CFO Advisory? I'm context to US GAAP. Please suggest. A captive center is offering this role.

like

Hi all , can anyone please tell me where pwc hyd is allowing employes to work from office voluntarly ? At present

If you’re a fourth year in biglaw, what responsibilities are you given in m&a? I feel like I still haven’t had a ton of opportunities working on purchase agreements (and mostly just take the lead on ancillary work streams) and I’m afraid I’m falling behind others in my class year.

like

Any recommendations for an affordable tailor? I have some cheap pants that I need hemmed and it doesn’t seem worth it to pay $30+ for each pair. Ideally looking for Williamsburg area but open to other neighborhoods for a cheaper price!

like

Hello hive mind. I am currently interviewing with three agencies. Pretty far along with two of them. One of the positions is a Jr. copywriter position while the other two are just for a copywriter. How important would it be to not have the “Jr” before the title? Personally, I don’t care about the title, but wonder about future employer’s?

like

Considering a move to UAE and Inhave to major questions:
- How is the SC work life balance?
- I am coming from Europe, is there a big cultural shock?

Thanks!

like

Seeking base salary and commission structure information.
Title: Inside sales manager
Territory size: Half of the USA
Team size: 5-10 and growing
Industry: Renewables/Solar Power

like

Been thinking about doing freelancing for a while. Anyone have any experience on freelancing for digital media sup/manager roles? How do you go about getting gigs or calculating rates? Pros/cons?

Hi Fishes
Is there any vacancy for Company Secretary professionals in any company for 3+ years of experience.

Any lead would be helpful.

Thanks in Advance

like
like

Anyone here in TRS at PWC? How do you like it? What do you do? Thanks!

like

Hi,

I have cleared all rounds in KPMG GS for Assistant Manager position and due for HR discussion, how much should I ask for ?

Current CTC : 21LPA

Other offer CTC: 26LPA

YOE : 11 year

like

Hi. Looking for info reg how log in and log out card swipe data is monitored at TCS. Who can access this data ... managers and team members? Do HR conduct an audit of the log in details of associates?

like

What is the percentage annual appraisal hike given for CTC of 32 to 35 LPA at TCS? Grade: C3B

likefunny

Does Barclays provide pick and drop for Pune location (Baner)??

like
like

Can somebody from Amazon refer me for training Coordinator position if it's open.

Please help!

like

How long does Amazon take to release offer letter? It has been a week since the recruiter called and told me I was selected. I also have the salary breakup and date of joining given. Only offer letter is not yet released. How many days does it usually take for Amazon to release offer letter. Waiting so I can give resignation to my current organization. Thanks. Amazon Amazon India

like
like

Additional Posts in Finance

what happens if you don’t pay back sign on bonus and leave before clawback period?

like

When people ask how I handle this job... HAHAHA, I don't.

like

Why does Morgan Stanley have manager and senior manager positions after associate? Makes it difficult and longer to reach VP compared to other bulge bracket banks.

like

Can someone please for the love of god help me figure out how I can pay less income taxes? I only make 88k and I put the 12k standard deduction but I’m still getting taxed 27% of my paychecks! My sign on bonus (20 even) a few months ago was taxed nearly 45%! Excuse my ignorance, but am I doing something wrong? Will increasing deductions help or should I increase the withholdings? Is this normal?! Thanks for any help/advice, it’s greatly appreciated.

like

What's a controversial opinion you have?
Just state it as you think and don't insult anyone.

like

Interviewing for a risk role when I’ve barely ever done any risk or ERM lol Please let me know what the heck I can say to be chosen cuz this role is interesting!

Entry level business analyst/ product manager?

Dm me

like

MD: "Why the fuck does he have to stay home and watch the kids? If your wife works at a nonprofit, you definitely make more than her."

like

Has anyone done the GARP Financial Risk and Regulation course? Was it educational? Did you do the FRM after?

like

Why do they have to destroy anyone that work in M&A? Really missing the coverage lifestyle right about now..

like

Do I even want to become VP? MD? Not sure if I want to become a slave to banking.

like
like

I just received a verbal offer as a program manager at vp level from a US BB in London. Unfortunately the number was a round down of my current pay. I’m currently a business manager in banking and thinking to move to the program manager role as a step towards more broader opportunities in the future (COO, consulting type of roles).
Should I accept the offer?
The HR told me that there will be opportunities for promotion in the next 12 to 24 months.

like

Who would you rather have dinner with, Janet or Hillary?

like

I need a new hobby or something to channel my energy and emotions into. Something that won't require much of a time commitment. Ideas?

like

I am investing as a beginner. What is a good company to start a brokerage account with ? Fidelity, Ameri E Trade, ML? I’m looking to put my money in index funds.

like

Two missed calls from our fearless leader. Either this is social engineering or I’m more important than I thought I was

Post Photo
like

People interested in B-school: what are your top schools and why?

like

I love that my 401k gets $200 in dividends every quarter

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