10 ай бұрын
11 ай бұрын
Пікірлер
@reetikachoudhary7340 2 ай бұрын
Nicely explained.
@NGKannur 3 ай бұрын
Thanks bro👍🏻
@TechAndTalkConnect 3 ай бұрын
Most welcome 🤗
@vishalnikum6349 4 ай бұрын
Waste of Time 😒
@TechAndTalkConnect 4 ай бұрын
May I know what your expectations here?
@asterisk7138 5 ай бұрын
Pls make a video on sql relationship with example
@ralphmcguire7668 5 ай бұрын
😉 Promo SM
@powerbiuser 6 ай бұрын
Thank you
@TechAndTalkConnect 6 ай бұрын
You're welcome
@user-ph9nq7hj7j 6 ай бұрын
Please make Master tables View Primary kay Create Master Table or Main Tables
@radhakrishnasabbi4904 6 ай бұрын
Bro please upload sql videos more
@TechAndTalkConnect 6 ай бұрын
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 6 ай бұрын
Bro pls upload classes about stored procedure and triggers
@TechAndTalkConnect 6 ай бұрын
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 6 ай бұрын
yes we can write the user defined function create function function_name return begin end
@sooraj_sp_11 6 ай бұрын
Thanks for the video ❤ It boosts my confidence
@alladishiva593 6 ай бұрын
sir please upload stored procedure and subquery question related.
@sumitchaudhari5815 6 ай бұрын
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)
@sumitchaudhari5815 6 ай бұрын
i did able to find about performance optimization but not able to find about sub-queries@@TechAndTalkConnect
@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
@koshtinimesh8247 6 ай бұрын
what's keyword and function in sql
@uthpalabitra7855 6 ай бұрын
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 6 ай бұрын
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 6 ай бұрын
Good explanation, please one more concept stored procedure and sub query . Please sir
@Soni01-k3s 7 ай бұрын
Useful Video....thank u..
@TechAndTalkConnect 6 ай бұрын
Thank you for your kind Word ☺️
@vinaybayya2942 7 ай бұрын
what is the indexes and how to use
@TechAndTalkConnect 6 ай бұрын
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 7 ай бұрын
Please make a interview video on stores procedure
@TechAndTalkConnect 6 ай бұрын
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 6 ай бұрын
Thank you so much
@user-yp5tj2ce3s 7 ай бұрын
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 7 ай бұрын
Thanks for your insightful question. Please check out post it will help you to tackle this type of questions
@user-yp5tj2ce3s 7 ай бұрын
Awesome, Could you please make videos how to store data from front end to back end , and how works sql server database
@user-yp5tj2ce3s 7 ай бұрын
Awesome🙂
@TechAndTalkConnect 7 ай бұрын
Thank you 😊
@Mahesh_05_28 7 ай бұрын
Create view max_salary As Select dept_name,max(salary) from employee Group by dept_name;
@user-be4oc2ss6t 7 ай бұрын
Could you Plz share data set.
@TechAndTalkConnect 7 ай бұрын
thanks for comment please refer the dataset scripts from this link: drive.google.com/file/d/1Gm0qeSIqui5CK4RC0i89hRsNehSlqIhN/view?usp=drive_link
@remoashok9191 7 ай бұрын
Create view Total_Salary As Select Max(Salary),dep_name from departments group by dep_name;
@shalinisawarn8791 7 ай бұрын
Great 👍 please make a video on most asked interview questions for Fresher Data Analyst.
@sumanthbethanapalli8229 7 ай бұрын
if u provide the dataset then it is much more useful to us
@AP-tn7yh 7 ай бұрын
Create view max_dept as select dept_name ,max(salary) from emp group by dept_name;
@sagargudla1362 7 ай бұрын
Thank you bhava
@Maya.1988 7 ай бұрын
Everyone is telling basics .....but no one in youtube have guts to touch sql...performance
@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!
@Edgar-lf7bi 7 ай бұрын
Impressive work and well taught. Hope to see more advanced sql material.
@TechAndTalkConnect 7 ай бұрын
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 7 ай бұрын
please release videos every day, your explanation is good, please explain about CTE, Temp Tables, Table Variables, Temp Variables,
@TechAndTalkConnect 7 ай бұрын
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 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)
@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!
@codedtech75 7 ай бұрын
Amazing video sir,👌
@shalinisawarn8791 7 ай бұрын
Helpful, Thanks :)
@TechAndTalkConnect 7 ай бұрын
You're welcome! I'm glad you found it helpful☺️
@insidehead 7 ай бұрын
Anything for 2 3 yr exp.
@UmeshYadav-wl2dv 7 ай бұрын
Ur explanation is very clear pls upload sql interview perspective questions it's very useful for all candidates It's my request
@user-ur8ph9lj6f 7 ай бұрын
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 7 ай бұрын
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-ur8ph9lj6f 7 ай бұрын
Bhai please upload videos related to interview preparation for a Data Analyst role covering SQL, Python, Power BI and Excel .
@sudarsanrout5787 7 ай бұрын
Very informative
@TechAndTalkConnect 7 ай бұрын
Google Drive link for Scripts: drive.google.com/file/d/1Gm0qeSIqui5CK4RC0i89hRsNehSlqIhN/view?usp=drive_link
@pravinm1490 7 ай бұрын
Nice
@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!