SQL Interview Questions: Real-Time Scenarios & Aggregate Function Tips

No video

SQL Interview Questions: Real-Time Scenarios & Aggregate Function Tips

Рет қаралды 8,975

Tech And Talk

Күн бұрын

Пікірлер: 27

@TechAndTalkConnect 7 ай бұрын

Google Drive link for Scripts: drive.google.com/file/d/1Gm0qeSIqui5CK4RC0i89hRsNehSlqIhN/view?usp=drive_link

@sooraj_sp_11 6 ай бұрын

Thanks for the video ❤ It boosts my confidence

@TechAndTalkConnect 6 ай бұрын

🌟 Thank you for the support! 🌟

@1sunilento 8 ай бұрын

Good video. However, for question no. 10, finding a non-manger is tricky.. John Doe is the ultimate manager but other employees are also managers of lower-level employees. I don't think we can group all others except John Doe as non-managers. Please clarify!

@TechAndTalkConnect 8 ай бұрын

Thank you for your comment! You've brought up a valid consideration. In the scenario discussed, we treated the question by categorizing employees as 'Manager' if they are part of the managerial hierarchy, including both parent managers and those directly managing others. It's a simplified approach, and I acknowledge that the ultimate manager, like John Doe, can have a unique role. If you have further insights or questions, feel free to share! Your feedback is valuable.

@shivamthakur674 3 ай бұрын

Also the keyword should be used is not null then manager else non-manager

@aishwaryapattnaik3082 7 ай бұрын

Could you include additional SQL interview questions tailored for experienced professionals? It would be much appreciated if you could also share the DDL scripts. It's a fantastic way to enhance SQL skills!

@TechAndTalkConnect 7 ай бұрын

Thanks for the feedback! Great suggestion! I'll be adding more advanced SQL questions in future videos. Stay tuned for the link in the video description. Let me know if there's anything specific you'd like to see! Google Drive link: drive.google.com/file/d/1Gm0qeSIqui5CK4RC0i89hRsNehSlqIhN/view?usp=drive_link. Happy coding! keep Practicing!🚀

@sakshinaik05 7 ай бұрын

Thank you for the video bring more such videos

@TechAndTalkConnect 7 ай бұрын

More to come!You're welcome! I'm thrilled you enjoyed the video. More similar content is on the way. Stay tuned for upcoming videos!

@insidehead 7 ай бұрын

QUERY FOR Q 10: SELECT 'non_mgr' as avg_sal ,AVG (Salary) avg_sal FROM Employees WHERE EmployeeID NOT IN (SELECT ManagerID FROM Employees WHERE ManagerID IS NOT NULL) UNION all SELECT 'mgr' as avg_sal ,AVG (Salary) avg_sal FROM Employees WHERE EmployeeID IN (SELECT ManagerID FROM Employees WHERE ManagerID IS NOT NULL)

@TechAndTalkConnect 7 ай бұрын

Thank you for sharing your query! It's great to see different perspectives. Your approach is valid, and it's interesting to explore SQL scenarios from various angles. Appreciate your contribution to the discussion! Happy coding

@codedtech75 7 ай бұрын

Amazing video sir,👌

@TechAndTalkConnect 7 ай бұрын

Thank you for watching and expressing your appreciation 😊

@NGKannur 3 ай бұрын

Thanks bro👍🏻

@TechAndTalkConnect 3 ай бұрын

Most welcome 🤗

@ushasworld5223 8 ай бұрын

Could u please make a video of data analyst portfolio by taking real world data so that we can put that in our resumed please.....

@TechAndTalkConnect 8 ай бұрын

Thanks for the input! Exploring the idea of a data analyst portfolio video. If you have specific areas in mind or topics you'd like covered, feel free to drop your suggestions. Your feedback is key

@sagargudla1362 7 ай бұрын

Thank you bhava

@TechAndTalkConnect 7 ай бұрын

Welcome 🤗

@sumitchaudhari5815 6 ай бұрын

i have a question:- suppose i have to fetch data in my db like mysql daily at fixed time suppose at morning 7 am what kind of query should i write so it can fetch data at that time automatically i think i need to use even schedule but how to schedule it for that specific time. is it possible to do that

@TechAndTalkConnect 6 ай бұрын

please refer the post for this question. I have explained in details what steps you should have to refer for Schedule.

@TechAndTalkConnect 6 ай бұрын

@@sumitchaudhari5815 Please refer the community post URL kzfaq.info/love/rhNezSLNCAojblfC0MSihgcommunity?pvf=CAE%253D

@insidehead 7 ай бұрын

Anything for 2 3 yr exp.

@TechAndTalkConnect 7 ай бұрын

Thank you for your comment! For specific tips on interviews with 2 to 3 years of experience, you might find valuable insights in my dedicated interview playlist: [Interview Playlist](kzfaq.info/sun/PLFXSOrOKP0AreAxv3CJksu2f6_rI3LACl&si=M4246tn-h_uTSIKA). Feel free to check it out, and if you have any more questions, don't hesitate to ask!

@insidehead 7 ай бұрын

10.Calculate the average salary for managers and non-managers? THERE IS NOT ONLY ONE MANAGER, EVERY EMPLOYYE HAS A MANAGER FIRST WE HAVE TO INNER JOIN THEN TAKE AVG SALARY I THINK. .. BUT U TOOK ONLY FOR ONE MANAGER WHY? I THINK ITS WRONG QUERY.

@TechAndTalkConnect 7 ай бұрын

Thanks for pointing that out! Your observation is spot-on. When I crafted this question, my intent was to identify the 'ultimate manager' (like John Doe) and treat others as managers of lower-level employees- so it won't be the ultimate manager so we are considered as Non manager. It's more about the hierarchy in management. I appreciate your perspective, and your understanding aligns with a different interpretation, considering them as non-managers. SQL scenarios can indeed have various valid interpretations. If you have more insights or if there's anything specific you'd like to explore, feel free to share. Happy coding!