Google Drive link for Scripts: drive.google.com/file/d/1Gm0qeSIqui5CK4RC0i89hRsNehSlqIhN/view?usp=drive_link
@sooraj_sp_116 ай бұрын
Thanks for the video ❤ It boosts my confidence
@TechAndTalkConnect6 ай бұрын
🌟 Thank you for the support! 🌟
@1sunilento8 ай бұрын
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!
@TechAndTalkConnect8 ай бұрын
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.
@shivamthakur6743 ай бұрын
Also the keyword should be used is not null then manager else non-manager
@aishwaryapattnaik30827 ай бұрын
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!
@TechAndTalkConnect7 ай бұрын
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!🚀
@sakshinaik057 ай бұрын
Thank you for the video bring more such videos
@TechAndTalkConnect7 ай бұрын
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!
@insidehead7 ай бұрын
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)
@TechAndTalkConnect7 ай бұрын
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
@codedtech757 ай бұрын
Amazing video sir,👌
@TechAndTalkConnect7 ай бұрын
Thank you for watching and expressing your appreciation 😊
@NGKannur3 ай бұрын
Thanks bro👍🏻
@TechAndTalkConnect3 ай бұрын
Most welcome 🤗
@ushasworld52238 ай бұрын
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.....
@TechAndTalkConnect8 ай бұрын
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
@sagargudla13627 ай бұрын
Thank you bhava
@TechAndTalkConnect7 ай бұрын
Welcome 🤗
@sumitchaudhari58156 ай бұрын
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
@TechAndTalkConnect6 ай бұрын
please refer the post for this question. I have explained in details what steps you should have to refer for Schedule.
@TechAndTalkConnect6 ай бұрын
@@sumitchaudhari5815 Please refer the community post URL kzfaq.info/love/rhNezSLNCAojblfC0MSihgcommunity?pvf=CAE%253D
@insidehead7 ай бұрын
Anything for 2 3 yr exp.
@TechAndTalkConnect7 ай бұрын
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!
@insidehead7 ай бұрын
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.
@TechAndTalkConnect7 ай бұрын
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!