11 ай бұрын
Пікірлер
@M.kesavanM.kesavan-vt5md 5 күн бұрын
Broo if there is each keyword We also use inner join Yes or No broo
@ManaliPatil-k2t 5 күн бұрын
very good information shared
@reetikachoudhary7340 3 ай бұрын
Nicely explained.
@NGKannur 4 ай бұрын
Thanks bro👍🏻
@TechAndTalkConnect 4 ай бұрын
Most welcome 🤗
@vishalnikum6349 5 ай бұрын
Waste of Time 😒
@TechAndTalkConnect 5 ай бұрын
May I know what your expectations here?
@asterisk7138 6 ай бұрын
Pls make a video on sql relationship with example
@ralphmcguire7668 7 ай бұрын
😉 Promo SM
@powerbiuser 7 ай бұрын
Thank you
@TechAndTalkConnect 7 ай бұрын
You're welcome
@AghAAwais-c8t 7 ай бұрын
Please make Master tables View Primary kay Create Master Table or Main Tables
@radhakrishnasabbi4904 7 ай бұрын
Bro please upload sql videos more
@TechAndTalkConnect 7 ай бұрын
Thanks for the suggestion! It sounds like you're interested in learning how to create a master table with primary keys. I'll make sure to cover that topic in an upcoming video tutorial. Stay tuned for more content!
@radhakrishnasabbi4904 7 ай бұрын
Bro pls upload classes about stored procedure and triggers
@TechAndTalkConnect 7 ай бұрын
Hey there! Thanks for your interest in learning about stored procedures and triggers. I appreciate your support! I'm currently working on creating classes on these topics, and I'll be uploading the video very soon. Stay tuned and thank you for your patience
@vinaybayya2942 8 ай бұрын
yes we can write the user defined function create function function_name return begin end
@sooraj_sp_11 8 ай бұрын
Thanks for the video ❤ It boosts my confidence
@TechAndTalkConnect 8 ай бұрын
🌟 Thank you for the support! 🌟
@alladishiva593 8 ай бұрын
sir please upload stored procedure and subquery question related.
@TechAndTalkConnect 8 ай бұрын
Thank you for your suggestion! I appreciate your interest. I'm currently working on creating a detailed video covering stored procedures and addressing various query questions. Stay tuned, as I'll be uploading it very soon 😊
@sumitchaudhari5815 8 ай бұрын
can you please make video on sub-queries by writing complex sub-queries and tell us how does it get executed i mean way of execution of subqueries or sequence of execution in subqueries and performance optimization (regarding performance optimization i have no idea)
@TechAndTalkConnect 8 ай бұрын
Please check out the post I have answered in the post section with details
@sumitchaudhari5815 8 ай бұрын
i did able to find about performance optimization but not able to find about sub-queries@@TechAndTalkConnect
@sumitchaudhari5815 8 ай бұрын
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 8 ай бұрын
please refer the post for this question. I have explained in details what steps you should have to refer for Schedule.
@TechAndTalkConnect 8 ай бұрын
@@sumitchaudhari5815 Please refer the community post URL kzbin.info/door/rhNezSLNCAojblfC0MSihgcommunity?pvf=CAE%253D
@koshtinimesh8247 8 ай бұрын
what's keyword and function in sql
@uthpalabitra7855 8 ай бұрын
I am glad that i found your channel. plz do more videos on sql, like how to write queries , interview questions on topic wise sql. queries asked in interview, how to learn query writing with logics. plz . Thank you
@TechAndTalkConnect 8 ай бұрын
Thank you so much for your kind words and support! I'm thrilled to hear that you're finding value in the content. I'll definitely take your suggestions to heart and work on more SQL-related videos, including topics like query writing, interview questions, and logical approaches. Stay tuned for exciting and informative content ahead!
@alladishiva593 8 ай бұрын
Good explanation, please one more concept stored procedure and sub query . Please sir
@TechAndTalkConnect 8 ай бұрын
Thank you so much for your positive feedback! I'm thrilled to hear you found the explanation helpful. I appreciate your suggestion and I'm working on creating content about stored procedures and subqueries. Stay tuned to Tech and Talk for more exciting content! Your patience is much appreciated
@alladishiva593 8 ай бұрын
@@TechAndTalkConnect Tq u Sir
@Nalini08888 8 ай бұрын
Useful Video....thank u..
@TechAndTalkConnect 8 ай бұрын
Thank you for your kind Word ☺️
@vinaybayya2942 8 ай бұрын
what is the indexes and how to use
@TechAndTalkConnect 8 ай бұрын
I appreciate your suggestion and I'm working on creating content about index and how we can effectively use them. Stay tuned to Tech and Talk for more exciting content! Your patience is much appreciated
@khalidazizi8346 8 ай бұрын
Please make a interview video on stores procedure
@TechAndTalkConnect 8 ай бұрын
I appreciate your suggestion and I'm working on creating content about stored procedures. Stay tuned to Tech and Talk for more exciting content! Your patience is much appreciated
@khalidazizi8346 8 ай бұрын
Thank you so much
@gowrikm-n5u 8 ай бұрын
thank you, i had question in interview could you please solve this issue, "as a sql developer if you will face the issue on front end to get the data takes lot of time , but in backend sql code, indexes and performance all is good, then how you will solve the issue as a sql developer"
@TechAndTalkConnect 8 ай бұрын
Thanks for your insightful question. Please check out post it will help you to tackle this type of questions
@gowrikm-n5u 8 ай бұрын
Awesome, Could you please make videos how to store data from front end to back end , and how works sql server database
@TechAndTalkConnect 8 ай бұрын
Thank you for the awesome feedback! I'm glad you're interested in a video on storing data from frontend to backend and understanding SQL Server Database. I'm already working on creating a detailed tutorial for you. It might take a bit of time to ensure it's comprehensive and clear. Stay tuned to Tech and Talk for the upcoming video! Your patience is greatly appreciated.
@gowrikm-n5u 8 ай бұрын
Awesome🙂
@TechAndTalkConnect 8 ай бұрын
Thank you 😊
@Mahesh_05_28 8 ай бұрын
Create view max_salary As Select dept_name,max(salary) from employee Group by dept_name;
@Surya-r9v 8 ай бұрын
Could you Plz share data set.
@TechAndTalkConnect 8 ай бұрын
thanks for comment please refer the dataset scripts from this link: drive.google.com/file/d/1Gm0qeSIqui5CK4RC0i89hRsNehSlqIhN/view?usp=drive_link
@remoashok9191 8 ай бұрын
Create view Total_Salary As Select Max(Salary),dep_name from departments group by dep_name;
@shalinisawarn8791 8 ай бұрын
Great 👍 please make a video on most asked interview questions for Fresher Data Analyst.
@TechAndTalkConnect 8 ай бұрын
Thank you! I appreciate your suggestion. I'll work on a video covering the most asked interview questions for fresher data analysts. Stay tuned!
@sumanthbethanapalli8229 8 ай бұрын
if u provide the dataset then it is much more useful to us
@TechAndTalkConnect 8 ай бұрын
thanks for comment please refer the dataset scripts from this link: drive.google.com/file/d/1Gm0qeSIqui5CK4RC0i89hRsNehSlqIhN/view?usp=drive_link
@AP-tn7yh 8 ай бұрын
Create view max_dept as select dept_name ,max(salary) from emp group by dept_name;
@sagargudla1362 8 ай бұрын
Thank you bhava
@TechAndTalkConnect 8 ай бұрын
Welcome 🤗
@Maya.1988 8 ай бұрын
Everyone is telling basics .....but no one in youtube have guts to touch sql...performance
@TechAndTalkConnect 8 ай бұрын
Thanks for the comment! Get ready for some exciting videos showcasing skill performances!
@sakshinaik05 8 ай бұрын
Thank you for the video bring more such videos
@TechAndTalkConnect 8 ай бұрын
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!
@Edgar-lf7bi 8 ай бұрын
Impressive work and well taught. Hope to see more advanced sql material.
@TechAndTalkConnect 8 ай бұрын
Thank you for your positive feedback! I'm glad you found the content helpful. I appreciate your suggestion for more advanced SQL material. Stay tuned for upcoming videos!
@muralidharkanithi3436 8 ай бұрын
please release videos every day, your explanation is good, please explain about CTE, Temp Tables, Table Variables, Temp Variables,
@TechAndTalkConnect 8 ай бұрын
Thank you so much for your kind words and encouragement! I truly appreciate your support. I'm glad you find the explanations helpful. Creating videos on CT, temp tables, table variables, and temp variables sounds like a great idea, and I'll definitely add them to my content plan. While I may not be able to release videos every day due to work commitments, I'll do my best to bring you valuable content as frequently as possible. Stay tuned, and thanks again for being a part of the community!
@insidehead 8 ай бұрын
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 8 ай бұрын
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
@insidehead 8 ай бұрын
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 8 ай бұрын
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!
@codedtech75 8 ай бұрын
Amazing video sir,👌
@TechAndTalkConnect 8 ай бұрын
Thank you for watching and expressing your appreciation 😊
@shalinisawarn8791 8 ай бұрын
Helpful, Thanks :)
@TechAndTalkConnect 8 ай бұрын
You're welcome! I'm glad you found it helpful☺️
@insidehead 8 ай бұрын
Anything for 2 3 yr exp.
@TechAndTalkConnect 8 ай бұрын
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](kzbin.info/aero/PLFXSOrOKP0AreAxv3CJksu2f6_rI3LACl&si=M4246tn-h_uTSIKA). Feel free to check it out, and if you have any more questions, don't hesitate to ask!
@UmeshYadav-wl2dv 8 ай бұрын
Ur explanation is very clear pls upload sql interview perspective questions it's very useful for all candidates It's my request
@TechAndTalkConnect 8 ай бұрын
Thank you for your kind words! I appreciate your support. If you're interested in more interview-related content, check out my interview playlist where I regularly upload SQL interview questions. Here's the link: kzbin.info/aero/PLFXSOrOKP0AreAxv3CJksu2f6_rI3LACl&si=ccwk-I7O9VRwYsUc
@CarlosVolpe-w1n 8 ай бұрын
Can you share the important SQL must do questions from platforms like leetcode, stratascratch, data lemur etc in one video to watch before every interview
@TechAndTalkConnect 8 ай бұрын
Thanks for your suggestion! Creating a video on important SQL questions from platforms like LeetCode, Startscratch, Data, and Lemur is a great idea. I'll definitely work on that and share it soon. Stay tuned for the comprehensive video to boost your SQL interview preparation!
@CarlosVolpe-w1n 8 ай бұрын
Bhai please upload videos related to interview preparation for a Data Analyst role covering SQL, Python, Power BI and Excel .
@TechAndTalkConnect 8 ай бұрын
Thank you for your feedback! I appreciate your suggestion for interview preparation videos for a data analyst role covering SQL, Python, Power BI, and Excel. I'll prioritize creating content that caters to your needs. Stay tuned for detailed tutorials, and feel free to ask specific questions on any topic you'd like more guidance on. Happy learning!
@sudarsanrout5787 8 ай бұрын
Very informative
@TechAndTalkConnect 8 ай бұрын
Thank you 😊
@TechAndTalkConnect 9 ай бұрын
Google Drive link for Scripts: drive.google.com/file/d/1Gm0qeSIqui5CK4RC0i89hRsNehSlqIhN/view?usp=drive_link
@pravinm1490 9 ай бұрын
Nice
@TechAndTalkConnect 9 ай бұрын
Thanks for your comments ☺️