Please make Master tables View Primary kay Create Master Table or Main Tables
@radhakrishnasabbi49046 ай бұрын
Bro please upload sql videos more
@TechAndTalkConnect6 ай бұрын
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!
@radhakrishnasabbi49046 ай бұрын
Bro pls upload classes about stored procedure and triggers
@TechAndTalkConnect6 ай бұрын
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
@vinaybayya29426 ай бұрын
yes we can write the user defined function create function function_name return begin end
@sooraj_sp_116 ай бұрын
Thanks for the video ❤ It boosts my confidence
@alladishiva5936 ай бұрын
sir please upload stored procedure and subquery question related.
@sumitchaudhari58156 ай бұрын
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)
@sumitchaudhari58156 ай бұрын
i did able to find about performance optimization but not able to find about sub-queries@@TechAndTalkConnect
@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
@koshtinimesh82476 ай бұрын
what's keyword and function in sql
@uthpalabitra78556 ай бұрын
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
@TechAndTalkConnect6 ай бұрын
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!
@alladishiva5936 ай бұрын
Good explanation, please one more concept stored procedure and sub query . Please sir
@Soni01-k3s7 ай бұрын
Useful Video....thank u..
@TechAndTalkConnect6 ай бұрын
Thank you for your kind Word ☺️
@vinaybayya29427 ай бұрын
what is the indexes and how to use
@TechAndTalkConnect6 ай бұрын
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
@khalidazizi83467 ай бұрын
Please make a interview video on stores procedure
@TechAndTalkConnect6 ай бұрын
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
@khalidazizi83466 ай бұрын
Thank you so much
@user-yp5tj2ce3s7 ай бұрын
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"
@TechAndTalkConnect7 ай бұрын
Thanks for your insightful question. Please check out post it will help you to tackle this type of questions
@user-yp5tj2ce3s7 ай бұрын
Awesome, Could you please make videos how to store data from front end to back end , and how works sql server database
@user-yp5tj2ce3s7 ай бұрын
Awesome🙂
@TechAndTalkConnect7 ай бұрын
Thank you 😊
@Mahesh_05_287 ай бұрын
Create view max_salary As Select dept_name,max(salary) from employee Group by dept_name;
@user-be4oc2ss6t7 ай бұрын
Could you Plz share data set.
@TechAndTalkConnect7 ай бұрын
thanks for comment please refer the dataset scripts from this link: drive.google.com/file/d/1Gm0qeSIqui5CK4RC0i89hRsNehSlqIhN/view?usp=drive_link
@remoashok91917 ай бұрын
Create view Total_Salary As Select Max(Salary),dep_name from departments group by dep_name;
@shalinisawarn87917 ай бұрын
Great 👍 please make a video on most asked interview questions for Fresher Data Analyst.
@sumanthbethanapalli82297 ай бұрын
if u provide the dataset then it is much more useful to us
@AP-tn7yh7 ай бұрын
Create view max_dept as select dept_name ,max(salary) from emp group by dept_name;
@sagargudla13627 ай бұрын
Thank you bhava
@Maya.19887 ай бұрын
Everyone is telling basics .....but no one in youtube have guts to touch sql...performance
@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!
@Edgar-lf7bi7 ай бұрын
Impressive work and well taught. Hope to see more advanced sql material.
@TechAndTalkConnect7 ай бұрын
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!
@muralidharkanithi34367 ай бұрын
please release videos every day, your explanation is good, please explain about CTE, Temp Tables, Table Variables, Temp Variables,
@TechAndTalkConnect7 ай бұрын
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!
@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)
@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!
@codedtech757 ай бұрын
Amazing video sir,👌
@shalinisawarn87917 ай бұрын
Helpful, Thanks :)
@TechAndTalkConnect7 ай бұрын
You're welcome! I'm glad you found it helpful☺️
@insidehead7 ай бұрын
Anything for 2 3 yr exp.
@UmeshYadav-wl2dv7 ай бұрын
Ur explanation is very clear pls upload sql interview perspective questions it's very useful for all candidates It's my request
@user-ur8ph9lj6f7 ай бұрын
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
@TechAndTalkConnect7 ай бұрын
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!
@user-ur8ph9lj6f7 ай бұрын
Bhai please upload videos related to interview preparation for a Data Analyst role covering SQL, Python, Power BI and Excel .
@sudarsanrout57877 ай бұрын
Very informative
@TechAndTalkConnect7 ай бұрын
Google Drive link for Scripts: drive.google.com/file/d/1Gm0qeSIqui5CK4RC0i89hRsNehSlqIhN/view?usp=drive_link
@pravinm14907 ай бұрын
Nice
@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!