Here are the top SQL interview questions:

1. What is SQL?
2. What are the different types of SQL commands?
3. What is the difference between `WHERE` and `HAVING` clauses?
4. What is a Primary Key and Foreign Key?
6. What is a JOIN? Explain its types.
7. What is the difference between `UNION` and `UNION ALL`?
8. What is a Subquery?
9. What are Indexes in SQL?
10. What is the difference between `DELETE` and `TRUNCATE`?
If you need more join https://joinfishbowl.com/bowl_pnvg4sw5ea

BCG🐠 how long is the cool off period for a fresh application if I didn't get to the interview stage?

What are some red flags you've noticed in the hiring process? I've finally landed an interview after weeks of applying. I think it went well on my end, but something about the managers I spoke with just feels...off.

At what point is too much prep?? I think reading about how grueling the Amazon interview process is has sent me into a spiral lol. Interview is tomorrow and can someone just tell me it really isn’t as bad as everyone says it is??! 😂😭

Interviewing for jobs, are there any issues on talking about past deals or clients you’ve had? Currently in MM/Corp. banking. I know many of the big IBD deals are published but not at my level

I was recently let go by a Big 4 and I interviewed at Mid-size. I didn’t tell them I was let go and was hired and now working here. Recently realized, the partner I work with and my ex-firm practice partners are good friends. Should I communicate to my ex-firm partner not to share this with my current firm partner when they meet??? Or am I thinking it too much?

I have appeared the first round for an ui angular position in HPE. Have anyone recently appeared for similar interview. How long is the interview process? @HPE

I started interviewing early Oct with a company that reached out via recruiter. The hiring manager was very straight forward with me that I was his top candidate and I was told all other interviews were very positive incl CMO. The recruiter said they'd be making an offer but it's now been three weeks. Anyone else had the process drag on like this? Meanwhile I'm taking other interviews and was offered a promotion at current company, but was very interested in this one. What would you do?

Can anyone share the questions PwC AC Kolkata will ask for interview in assurance for CA as A2/SA1?

Hello Fishes,

looking forward to suggestions.
I am currently serving notice period. Could you please suggest some good companies i can give interviews in during my notice period to counter offer.
Tech Stack: React.js, Node.js, Rest API, javascript

Thanks

Hi Fishes,
Can anyone tell me about EY FT-GBS ? What kind of work they do and what should I expect in the interviews?
TIA

What are the best websites and youtube channels you can recommend for interview preparations ?
Tech : Java microservice developer
Yoe : 9

Thanks in advance

What % utilisation is considered good?
I know it depends on firm to firm, but in general?
Also, is it wise to put in CV or say in interviews about your utilization if its good?

Hi Fishes,

I am looking for the job change in ServiceNow profile and having a experience of 4+ yrs.

Currently I am trying to create network in linked in and naukari but still not getting the response from some companies like JP Morgan or mindtree etc.

Can u help me to understand what is the best way to create a network to some major companies.

I know applying directly to the company site mostly doesn't have any benefit or will take long time to schedule the interview.

Anyone interested in group conversation and prepration for Java 8, microservices, spring mvc and boot? Interview preparation basically.

Any suggestions on how to answer these interview questions? Thanks!

1. Tell me how you would hold the line and push back against leadership.
2. How would you increase your CLV, among e-commerce advertisers?
3. What are the biggest challenges marketers face today?

Hello people,

I have seen lot of people on this app saying Synechron is Hire and fire and mostly don't recommend to join. I just wanted to know from people working here, how true are these claims?

PPMDs, what tips you would give if your client is a Member Firm? I am an incoming project manager, lateral hired from industry. Please share your thoughts about how to make an impact from day 1.

How many times do we have to tell you, Karen, posting on 2 Instagram accounts doesn't mean you own a marketing agency 👀

Does anyone have a good lead on where to find research backed customer journeys? Either generic for an industry (like restaurant) or for major players in an industry (like chili's). I am fairly new to planning, and this keeps coming up as something and that would be helpful.
Thank you!

Isbthere any probation period for lateral?

Does FDD vary by firm or do they pretty much compete and do the same work? Like which one has the best practice in NYC from the big4?

What is a look back analysis?

20 lpa for 3yoe capgemini is it safe ?

My mom visited India for 2 months and got stuck there due to COVID. Can she apply for unemployment while she’s in India? Her company has reduced of hours due to COVID also. Please advice. Appreciate it

Anyone have any affordable case management software recommendations? I’m looking for something a bit non-traditional as I work for a small nonprofit. Ideally the software would involve document organization/access as well as like a running “log” for folks to post relevant events or work completed for the file.

How long is acceptable to ask to decide on an offer, especially when another place you really want to work at is moving a bit slower? I know this question has been asked before but I feel like 2022 has been its own beast in the legal market and would appreciate any advice. Thank you!

I have an offer from deutsche Telekom and Mckinsey and Company both for the role of Software Developer. Which should I join ? Which company has better Work culture?

I am joining on 2 November but haven’t received any onboarding details. Do I need to follow up with the HR.

Specific question for fish based in the UK.
Could you let me know what your employer contributions to your company pension scheme are?
For instance, they contribute half of your contribution up to a maximum of 3%. Before any tax incentives etc.
Interested to see the variances, it seems to be substantial from what I've seen. If it changes with level/seniority, please make that clear as well so we can differentiate between companywide averages and individual circumstances / positioning.

Hlo guys,
Which are the certifications that can add great value to our CV as An IT employee ?

Asking for my brother. Please don't ignore.

If your company has any openings for Fresher. kindly provide referral.

Skillset: HTML, CSS, JavaScript, ReactJS, Python, SQL

He has trained in above skills. If any developer position is open in your company. Kindly let me know.

Hi All

I am looking for a switch with 1.4 year of experience in Tata Consultancy Services as a Assistant System Engineer.

My Skill set are HTML5, CSS3, JavaScript, Java, C, C++, MySQL, Servlets, Spring, Git

Let me know if there are any opening position.

Thank you.

Any job openings in your company please refer.
Yoe- 1.3 yrs , tech- Java Spring Boot, serving notice period -30 days left

Hi folks,
Whats the average salary of a vlocity Developer with experience in salesforce admin, lwc, apex, vlocity Development and Trained in vlocity order management.

I am planning to switch organization.

YOE : 1.4
Current CTC : 6.8 LPA

Never feel indebted to your company coz they hired your talent and they pay for the same, neither you are doing charity nor they

Hi Fishes,
I joined my current organization 3 months back.
Didnt allocated any project yet.

Now i am looking for a change:
Can someone refer me:
YOE :8.9
Location: Bangalore
Notice period: 30days
DOB : 01/06/1991
skills: java, spring boot, hibernate.

Thanks in advance

Hiii all. Anyone working here in a Digital Transformation Project??