techTFQ - the main difference between delete and truncate statements besides removing the data from the table, truncate resets the id to 0 whereas delete doesn't do that. let's say if a table has 100 records. if you use delete statement and delete all 100 records and try to insert a new record. Your new record will have the id starting from 101 whereas with truncate it will start from 1. I think this isn't on your differences. Basically, truncate removes the memory allocation along with the data whereas delete doesn't. Thanks!
Im in this field and I can tell you that typically the people that ask you these questions don’t know the answers until they looked them up to hit you with them during the interview
exactly, many actually don't. they wouldn't even recognize other approaches used while solving questions. sadly thats what most candidates have to deal with.
You are right about this questions. My recent interview with one of the MNC in France asked few of this questions. here are the questions that I was asked. 1. Do you know window functions? Can you name few? 2. Have you ever used CTE table? 3. Diffrence btw where, Having , Group by.
What I have found fascinating about learning SQL is this: After doing a LOT of queries to the database with Microsoft Excel Power Query function, I came to SQL understanding almost all the concepts already and I only needed to learn the syntax. I would say I could answer about half these questions and I'm only three weeks into SQL but a year and a half into Power Query. This was a really helpful video! I'll check out the blog. 🎉🎉🎉
From Madhya Pradesh, !!May the grace of Mahakal always be upon you!! TFQ Thanking for helping people to get in IT at no cost, really your teaching style and content is priceless ,, Thank you for offering Data analyst skills FREE
I am very new to SQL. I have been studying for less than two months.Your videos are so easy to follow. Good command on English language. Keep up the good work. I will be watching more often. Thank you.
You are doing great job Thowfiq. And I mean it. I'll tell all of my students to follow you. I have been following you for a while and I got you and your work. Very strong, real and tough content you provide. That's awesome.
This was definitely Helpful. As a fresher we r often confused on what and how much to study.. Please make few videos on Stored Procedures and Functions as well. Thank you for everything you are doing.
A few months ago I had decided to learn sql to prepared for the interview and to unskilled myself after searching through out the day to confirm who RUclipsr video best of me and unfortunately came across to taufiq sir videos and it's one of my beat decision to choose your RUclips channel. Thank you taufiq sir❤
I am a beginner in SQL and want to know if you will be creating any learning videos for absolute beginners. I like the way you teach. Looking forward for videos on SQL basics.
thanks very much for creating this video and even someone like myself with 20 years of Oracle Experience found it very useful and was asked so many of these questions which have been mentioned in this video when I was attending interviews in the UK, so would recommend to watch it before your interview!
Nice... Someone with minimal IQ like me is really loving the comments.. I crave to understand sql at 56years old despite some of the complexities in learning code et al. I CAN DO IT.
I am Subscriber when watching your first video.... It's just waooo concept clear.... And feeling myself self confidence in SQL ....thanks... After watching every video... And saying it's truly after learning SQL from you .... interest in learning and making career in data field more only on in SQL.... Thanks a lot.🎉
Hi Taufiq, Small change for question 11, In mYSQL you could even write it as Select substring_index(full name,' ',1) from table_name this will give you the required o/p. This query makes it simple to understand and gives the result much faster .
Thank you, your video helped me a lot, If yes, can you please make a video on how to improve query performance, again thanks for all of your time so far.
A quick analysis of the video. Actually, I was looking for an explanation of the answers or a brief answer to the questions, but you just advertised your blog in this video. The questions are authentic and reasonable but what I was looking for was not to visit any blog, that's why I searched on youtube.
You are helping to all SQL folks alot by making these kind videos as well as your blog which are having great contents. I can not thank you enough. 😊🙏🏾
Truely amazin gcontent. No waste of time, right to the point, precise, nd most importantly valuable content. Waiting for a detailed practical session on different types of joine(intermediate and advanced).Thanks
Hi Taufiq , Thank you for all the videos on SQL and Python .YT also helped me found this gem channel and now I am preparing for my upcoming interview for an IT senior analyst from your channel .My SQL fundamental has improved in a week .I hope to learn from channel through my Data engineering and Business analytics journey .Thanks again for the awesome content .Appreciate your great work to the people .
Hello Toufiq thanks for this Video you are really good Educator ...few Questions 1. I am using MS SQL > What is Commit function ? As you mention in Delete VS Truncate difference statement.(Reference Question 2)
Commit function is used to save the changes in database. So if we deleted some records using delete command(dml) ,we can undo it. If we deleted records using truncate command(ddl) and commit then further we can't able to undo it as truncate will remove the space occupied by the the fields.
@@rajn2155 "If we deleted records using truncate command(ddl) and commit" - commit is not require for truncate command. it is auto commit. rest is correct. Truncate will reset the High water mark.
I'm following your videos for all my sql concepts. And guess what I'm struggling with JOINS bcoz you didn't cover it yet. That's a level of dependency I have on you...😂😂 Plz upload JOINS !! In the same way you explain with help of complex questions (that's matching with my way of learning ). Many many thanks 👏
Thanks Thoufiq. I've been following you for a while and this is my favorite SQL channel. Regarding question 11, would a Like operator with the % wildcard in MySQL work: select * from table_name where full_name like "Elon%"
Thanks Wael for liking my contents 🙏🏼 Appreciate your kind feedback. As for question 11, you need to just fetch the first name from full name field so using % u cannot do it. U can use % (as u mentioned above) to filter records to fetch all records that start with Elon
@@techTFQ Because you are being exptected to filter the first name for all the rows in a specific column. By using "Elon%" you can not filter Jeff Bezos.
Hey Thoufiq, your videos on SQL are really great. They are easy to understand and fun to practice. Your videos helped in shaping my basics. Thanks a ton. Lucky that i found your channel. Got a request. Please make a video on join & Regular Expressions.
As an experienced person, I get asked on below questions - 1. materialized view 2. difference between temp table/ table variable/ CTE 3. Union vs Union all 4. table statistics 5. execution plan 6. isnull() vs coalesce() 7. table partitioning
Thank you for Sql video. Could you make videos on nested joins .In real time organizations are using big joins .It challenging to understand while got stuck or error.
Another great video and so much preparation and work went into this. This is going to help so many people. I’ve watched a lot of videos about SQL interviews but this one is the most detailed and I love the supplementary information on your blog too. As a beginner in SQL, there are definitely concepts here that are brand new to me. Because this video is good for all skill levels, I would find it helpful to have a note on the blog as to which concepts are important for beginners to know vs intermediate vs advanced. You explained it well here but I think it would be good to see it there as well. Thank you again for all of your help, Thoufiq. One thing I can guarantee is that anyone who interviews me will hear about you because I have learned so much from you! 🙏🏻😀
Thank you Laura 🙏🏼 You are the best .. That’s a good suggestion.. I’ll try to edit the blog once I get some free time this week.. Nothing makes me more happier than to know that these videos have helped you and so many others to learn SQL 🙏🏼🙏🏼
@@techTFQ I am sure you are so busy and I hate to ask for anything, to be honest, because you’ve shared so much, but I think if the goal is to help as many people as fast as possible that from an efficiency standpoint, it’d be good to either have them categorized for difficulty level or have a note at the beginning as to which ones beginners etc should focus on. Again, I want to thank you for your time and for doing such detailed and thorough work.
@@techTFQ I’m really glad you made this video because without it, I may not have prepared for some concepts in here that I had never heard of. I haven’t even had a chance to go review your blog post yet, but you can be sure I will be doing that as well. Thanks again for your help 🙏🏻
Hi Taufiq, Great Video but I would suggest including all the details of your blog in this video instead of referring blog to read more details. It's just a suggestion but a blog is also great. Thanks again.
Once again, great content here. Would you consider turning these questions into a downloadable Pdf ? That would really be much appreciated and helpful. Thanks in advance
Is there a way to pull all table names where a particular record exist in db 2 ? For example if record is there in particular column then i need to pull that tables
Q11. We can solve this problem in Postgres DB by using Split_Part function. Select split_part(full_name,' ',1) Note: use 1 for first part of string separated by a character, in this case we have space ' '. 2 will give the 2nd part of string and so on...
IN THE 11 th Quation we will use a concate function not a substring or instring bcoz substring-used to return a requierd string like ('varun',2,4) output-arun instring- return a location of a string like ('varun','u') output-4
Great content Thoufiq.. Your videos are really helpful. Waiting for your complete SQL tutorial series.. Functions, Stored Procedures, Triggers, etc. Thanks a lot.
we have a situation in oracle where we have a public synonym and a private synonym for the same objects. By default the private synonyms as accessed or used. Is there any way we add some hint or anything that will allow to prefer Public synonym over Private synonym?
Indeed the best video out there regarding SQL interview questions👌🏻👏🏻 It was truly helpful. Thanks a lot brother🙏🏻 As you have mentioned, Looking forward for the detailed JOINS video🙌🏻
Answer of all questions "i explained in my blog"💁, although blog is written very good you should explain main points instead of just pointing towards blog. Thanks for question bank.
Hey buddy, you are super good.. your way of teaching along with examples is amazing. My concepts are very clear now..... Do you have any video exclusively on INDEXING... If yes please share the link and if not, could you please make one. Thanks a lot.. You are doing great. All the best
Thank you Jayant 🙏🏼 Very happy to read such positive comments :) Related to indexes , I do not have a video as of now but will plan to make one in the near future
Hey hi... could you make a video on.... how to validate the data using sql in different databases as part of ETL Also If you cover a real time scenario it would be helpful.
techTFQ - the main difference between delete and truncate statements besides removing the data from the table, truncate resets the id to 0 whereas delete doesn't do that. let's say if a table has 100 records. if you use delete statement and delete all 100 records and try to insert a new record. Your new record will have the id starting from 101 whereas with truncate it will start from 1. I think this isn't on your differences. Basically, truncate removes the memory allocation along with the data whereas delete doesn't.
Thanks!
you are right
@@honestreview4670 That´s correct
Im in this field and I can tell you that typically the people that ask you these questions don’t know the answers until they looked them up to hit you with them during the interview
exactly, many actually don't. they wouldn't even recognize other approaches used while solving questions. sadly thats what most candidates have to deal with.
You are right about this questions. My recent interview with one of the MNC in France asked few of this questions.
here are the questions that I was asked.
1. Do you know window functions? Can you name few?
2. Have you ever used CTE table?
3. Diffrence btw where, Having , Group by.
Thank you for sharing these parvez.. it’s good to know
hi buddy can u help me to search good company
Thanks
What I have found fascinating about learning SQL is this: After doing a LOT of queries to the database with Microsoft Excel Power Query function, I came to SQL understanding almost all the concepts already and I only needed to learn the syntax. I would say I could answer about half these questions and I'm only three weeks into SQL but a year and a half into Power Query.
This was a really helpful video! I'll check out the blog. 🎉🎉🎉
Hello are you working now?
Thanks!
From Madhya Pradesh, !!May the grace of Mahakal always be upon you!! TFQ Thanking for helping people to get in IT at no cost, really your teaching style and content is priceless ,, Thank you for offering Data analyst skills FREE
Thank you for the blessings buddy 🙏🏼🙏🏼
Happy to know you liked it
I’m going to your blog and I respect your hustle, but ITS HILARIOUS that most of your answers on the video are “yeah just check my blog”
You're my SQL HERO, Taufiq!! Thank you for everything you do. You've helped my understanding IMMENSELY.
So grateful for you!
I am very new to SQL. I have been studying for less than two months.Your videos are so easy to follow. Good command on English language. Keep up the good work. I will be watching more often. Thank you.
Awesome Sabhrang and thank you for liking my contents ☺️
Happy to read this comment
Thank you for coming up with this video. It helped me to get a glance at what to expect in interviews.
You are doing great job Thowfiq.
And I mean it.
I'll tell all of my students to follow you. I have been following you for a while and I got you and your work.
Very strong, real and tough content you provide. That's awesome.
Thank you Akshay for such kind words 🙏🏼
Truly appreciate the support ☺️
This was definitely Helpful. As a fresher we r often confused on what and how much to study.. Please make few videos on Stored Procedures and Functions as well. Thank you for everything you are doing.
Your welcome bro.. glad this helps
Where can I find the blog
A few months ago I had decided to learn sql to prepared for the interview and to unskilled myself after searching through out the day to confirm who RUclipsr video best of me and unfortunately came across to taufiq sir videos and it's one of my beat decision to choose your RUclips channel. Thank you taufiq sir❤
"good question you can check the answer in my blog, next question oh you can definitely check the answer in my blog"
its so irritating
I am a beginner in SQL and want to know if you will be creating any learning videos for absolute beginners. I like the way you teach. Looking forward for videos on SQL basics.
Thank you for liking my contents and yes I plan to make a complete SQL tutorial series covering all SQL concepts soon
@@techTFQ even I am waiting for your SQL complete video series
Thank you 🙏🏼
Really hats off to you Sir. Very patiently and explained with detailed information .
Thank you :)
thanks very much for creating this video and even someone like myself with 20 years of Oracle Experience found it very useful and was asked so many of these questions which have been mentioned in this video when I was attending interviews in the UK, so would recommend to watch it before your interview!
I am so glad that even an experience professional like you too found this helpful 🙏🏼🙏🏼
All the best with your interview 👍
Nice... Someone with minimal IQ like me is really loving the comments.. I crave to understand sql at 56years old despite some of the complexities in learning code et al. I CAN DO IT.
I am Subscriber when watching your first video.... It's just waooo concept clear.... And feeling myself self confidence in SQL ....thanks... After watching every video... And saying it's truly after learning SQL from you .... interest in learning and making career in data field more only on in SQL.... Thanks a lot.🎉
You're welcome ☺️ All the best
That’s a gem! I thank you on behalf of all the people who watched this video but didn’t give a thumbs up. 👏🏻
Thank you ☺️
Hi Taufiq,
Small change for question 11,
In mYSQL you could even write it as
Select substring_index(full name,' ',1) from table_name this will give you the required o/p.
This query makes it simple to understand and gives the result much faster .
Thank you. Those are very good questions and you have explained them very well. Great tutorials. Definitely would be helpful for everyone.
Glad you liked it
I just came here to say look at you fly with 166K!!! And you deserve it, Thoufiq, content always right on point. Thank you 🙏🏻
Thanks Laura 🙏🏼
As always very kind of you ☺️
your voice is so soft and clear....that is verry impressive and easy to understand......this vedio is helpfull
Very well and detailed explaination toufiq......THnaks for your Efforts and Blog....Kep it up brother...
Thank you buddy 🙏🏼
I discovered your channel today. excellent contents. Straight to the point with clear examples
Haii Thofiqq
Great Explaination
about SQL
really crystal Clear and Awesome
keep Going...
Thank you Keerthi
SQL in different sql versions is something I appreciate on your blog. 👍
Thank you, your video helped me a lot, If yes, can you please make a video on how to improve query performance, again thanks for all of your time so far.
glad it helped and noted on the request
A quick analysis of the video. Actually, I was looking for an explanation of the answers or a brief answer to the questions, but you just advertised your blog in this video. The questions are authentic and reasonable but what I was looking for was not to visit any blog, that's why I searched on youtube.
what a perfect explanation alongwith cool mind , many things learned from u like sql
Glad to hear that! Thank you Ramesh :)
This video is very helpful and thank you for the blog aswell.
Glad it was helpful!
Could you please share the blog link
Thanks for your time and Knowledge sharing.Your videos are very much helpful for serious learners.
glad this helped
You are helping to all SQL folks alot by making these kind videos as well as your blog which are having great contents. I can not thank you enough. 😊🙏🏾
Thank you Krishna :)
I am glad this helped 🙏
@@techTFQ pleasure is mine sir.
Truely amazin gcontent. No waste of time, right to the point, precise, nd most importantly valuable content. Waiting for a detailed practical session on different types of joine(intermediate and advanced).Thanks
Thank you Sribastav 🙏🏼
Glad to know you liked it
Hi Taufiq , Thank you for all the videos on SQL and Python .YT also helped me found this gem channel and now I am preparing for my upcoming interview for an IT senior analyst from your channel .My SQL fundamental has improved in a week .I hope to learn from channel through my Data engineering and Business analytics journey .Thanks again for the awesome content .Appreciate your great work to the people .
Hi, how did it go?
@@SesquipedaliofobiaHe didn't get it..
Great article & Video on SQL Interview Questions! Please make videos on Sql query performance tuning.
Thanks bro.. will make video on performance tuning in the near future
Thanks for the awesome video on SQL .. please keep it up...the way you explain is really great... thank you so much Bhai...
glad you liked it
best content on internet. glad to find you
Thank you Isha :)
Glad you liked it.
Hello Toufiq thanks for this Video you are really good Educator ...few Questions
1. I am using MS SQL > What is Commit function ? As you mention in Delete VS Truncate difference statement.(Reference Question 2)
Commit function is used to save the changes in database.
So if we deleted some records using delete command(dml) ,we can undo it.
If we deleted records using truncate command(ddl) and commit then further we can't able to undo it as truncate will remove the space occupied by the the fields.
@@rajn2155 Sorry for Followup question how to Undo it if already deleted ?
@@rajn2155 "If we deleted records using truncate command(ddl) and commit" - commit is not require for truncate command. it is auto commit. rest is correct. Truncate will reset the High water mark.
@@samarthkulkarni5069 use rollback; to Undo
@@samarthkulkarni5069 using rollback command
This video is gold, thanks bro!
Glad you liked it buddy
Can you please answer, as asked Google interview, amongst DISTINCT and GROUP BY, which is better?
Happy to see the growth of your channel young man. Very much deserved . Appreciate your time and efforts . God bless 🙏
Thank you so much Girija :)
Truly appreciate the blessings 🙏
What a great resource your channel is! MashaAllah love your content and your course on lighthouse.
Thank you Anas :)
Best video I have ever seen on SQL ....🙏👌
Thank you Rushikesh 🙏🏼
Glad you liked it ..
I'm following your videos for all my sql concepts.
And guess what I'm struggling with JOINS bcoz you didn't cover it yet.
That's a level of dependency I have on you...😂😂
Plz upload JOINS !! In the same way you explain with help of complex questions (that's matching with my way of learning ).
Many many thanks 👏
Haha this is a big dependency bro 😬😃
But I’ll definitely consider making the joins video soon ..
Hi sir, Great video.
Please make video on Query execution plan and Optimization.
Thank you and will consider making those videos in the future 🙏🏼
Thanks Thoufiq. I've been following you for a while and this is my favorite SQL channel.
Regarding question 11, would a Like operator with the % wildcard in MySQL work:
select *
from table_name
where full_name like "Elon%"
Thanks Wael for liking my contents 🙏🏼
Appreciate your kind feedback.
As for question 11, you need to just fetch the first name from full name field so using % u cannot do it.
U can use % (as u mentioned above) to filter records to fetch all records that start with Elon
@@techTFQ Makes sense. Thanks for replying and for the amazing content man!
Your welcome buddy
@@techTFQ Because you are being exptected to filter the first name for all the rows in a specific column. By using "Elon%" you can not filter Jeff Bezos.
Hey Thoufiq, your videos on SQL are really great. They are easy to understand and fun to practice. Your videos helped in shaping my basics. Thanks a ton. Lucky that i found your channel. Got a request. Please make a video on join & Regular Expressions.
Thank you Sonali 🙏🏼
Glad to know you contents have helped you ☺️
Will make video on Joins soon and regular expression may be a little later
If RUclips allows me to subscribe again and again.I will subscribe more than 100 times. You are amazing. Thank you so much.
Haha thank you so much Behailu 😃🙏🏼
Very helpful.. 👍
Please make a video for those who are switching there career in database
Because it's difficult to get a job as a fresher..
Thank you Dhiraj 🙏🏼
Will consider the suggestion for a future video
As an experienced person, I get asked on below questions -
1. materialized view
2. difference between temp table/ table variable/ CTE
3. Union vs Union all
4. table statistics
5. execution plan
6. isnull() vs coalesce()
7. table partitioning
How many years of experience you have sir
Thanks for your valuable blog..
It is so benefit for students like us to clear our technical interview.
Followed most of your videos. Amazing content. I would request you to make videos on Packages, Functions, Stored Procedures, Triggers
Thank you so much 🙏🏼
Sure will do
@@techTFQ yeah I second that, can you please make videos on PLSQL concepts, it would really help lots of folks considering the way you explain!!
Noted Satya , will plan it for the future
@@techTFQ Thank you !! If I'm not asking for too much, Can also please make one on query plan ?
Performance tuning is something I will do in the future
Thank you for the video and the blog post, I did not remember that Triggers are a thing I haven't used one in a decade 😅
Thank you for Sql video. Could you make videos on nested joins .In real time organizations are using big joins .It challenging to understand while got stuck or error.
Your welcome 🙏🏼
Yes will cover joins soon
Another great video and so much preparation and work went into this. This is going to help so many people. I’ve watched a lot of videos about SQL interviews but this one is the most detailed and I love the supplementary information on your blog too. As a beginner in SQL, there are definitely concepts here that are brand new to me. Because this video is good for all skill levels, I would find it helpful to have a note on the blog as to which concepts are important for beginners to know vs intermediate vs advanced. You explained it well here but I think it would be good to see it there as well. Thank you again for all of your help, Thoufiq. One thing I can guarantee is that anyone who interviews me will hear about you because I have learned so much from you! 🙏🏻😀
Thank you Laura 🙏🏼
You are the best ..
That’s a good suggestion.. I’ll try to edit the blog once I get some free time this week..
Nothing makes me more happier than to know that these videos have helped you and so many others to learn SQL 🙏🏼🙏🏼
@@techTFQ I am sure you are so busy and I hate to ask for anything, to be honest, because you’ve shared so much, but I think if the goal is to help as many people as fast as possible that from an efficiency standpoint, it’d be good to either have them categorized for difficulty level or have a note at the beginning as to which ones beginners etc should focus on. Again, I want to thank you for your time and for doing such detailed and thorough work.
No problem Laura .. I am always open to suggestions so I can improve my contents ..
It’s a valid point you make so will definitely consider it..
@@techTFQ I’m really glad you made this video because without it, I may not have prepared for some concepts in here that I had never heard of. I haven’t even had a chance to go review your blog post yet, but you can be sure I will be doing that as well. Thanks again for your help 🙏🏻
Glad to hear this Laura..
I wish this helps you to clear any SQL interview in the future
was able to answer all except 4-5 . Thnx for this.
Loved this ❤ Just watched.. Thanks
Thank you Shawn 🙏🏼
Thank you so much TFQ ..ur videos are more useful ❤im following ur videos and learning SQL
Great it could help
Hi Taufiq, Great Video but I would suggest including all the details of your blog in this video instead of referring blog to read more details. It's just a suggestion but a blog is also great. Thanks again.
Great content mate. Can you please provide one video on how to learn writing stored procedure. Its a mental block for me. A tutorial will be great !
Thanks Manu ,
Sure will cover procedure soon
Your content is great and very very helpful. Thanks from Paraguay
All your courses are clear, easy to understand and very interactive.
thank you for your time and effort.
Thank you Naod 🙏🏼
So glad to read this ..☺️
Spot on! You’re videos are very reliable! ❤❤
Once again, great content here. Would you consider turning these questions into a downloadable Pdf ? That would really be much appreciated and helpful.
Thanks in advance
Hi Mathieu,
I’ve posted all these questions on my blog but making them as pdf is not something I am considering as of now..
Great idea I was thinking of the same thing !
May be will consider it for the future contents
Great Video as always...
Please can you make video on store procedure
Thank you 🙏🏼 and will do soon
Thank you! This is a big help. Thanks for breaking it down
Is there a way to pull all table names where a particular record exist in db 2 ? For example if record is there in particular column then i need to pull that tables
Your tutorials helping a lot, please explain pivot in mysql
MySQL does not have PIVOT but we can do same thing in mysql using CASE statement.
I have explained it in my leetcode video
Reallly so helpful and so clear
Glad it was helpful!
Q11. We can solve this problem in Postgres DB by using Split_Part function.
Select split_part(full_name,' ',1)
Note: use 1 for first part of string separated by a character, in this case we have space ' '.
2 will give the 2nd part of string and
so on...
Great deal brother. I appreciate the knowledge. You the man.
Thank you so much sir ❤️☺️ really helpful .. i appreciate your hard work .. u did a great job .. your blog is just awesome 👍😎😎❤️
Thank you Adarsh. glad you liked it :)
Thank you for all details information 🙏🙏
Your welcome 🙏🏼
IN THE 11 th Quation we will use a concate function not a substring or instring
bcoz
substring-used to return a requierd string like ('varun',2,4)
output-arun
instring- return a location of a string like ('varun','u')
output-4
Great content Thoufiq.. Your videos are really helpful. Waiting for your complete SQL tutorial series.. Functions, Stored Procedures, Triggers, etc. Thanks a lot.
Thank you John 🙏🏼
Will make those soon ..
So happy to have you kind of teacher ❤️❤️❤️❤️ thanks Afghanistan 🇦🇫🇦🇫🇦🇫
we have a situation in oracle where we have a public synonym and a private synonym for the same objects. By default the private synonyms as accessed or used. Is there any way we add some hint or anything that will allow to prefer Public synonym over Private synonym?
Indeed the best video out there regarding SQL interview questions👌🏻👏🏻 It was truly helpful. Thanks a lot brother🙏🏻 As you have mentioned, Looking forward for the detailed JOINS video🙌🏻
Your welcome hero ❤️❤️
Will do JOINS video soon
Good content, really helpful✌🏻
The reference picture given for left join and right join are misplaced in the blog. kindly do correct it.
if u give like this with clear intensions and right guidance sure you will be great in data analytcis roles in you tube channel kudos to you bhai.
Thank you Sangamesh 🙏🏼
Glad you liked it
the questions are very nice and well managed , I have a question sir which SQL server to learn first as a beginner
Great content indeed. Please make a video on index and different types of keys.
Thank you and will do in the future 🙏🏼
taufiq bhai thankyou so much
Your welcome buddy
Answer of all questions "i explained in my blog"💁, although blog is written very good you should explain main points instead of just pointing towards blog. Thanks for question bank.
Hi, I have doubt----a procedure can call from select query.i have done so mainy procs and called through select query used postgreSQL RDBMS
Great video @Taufiq, Can you please create a detailed video on DDL and DML commands.
Thanks
Thank you Gajraj,
I’ll make it
Thank you Sir, I love your helpful videos!
Your welcome bro
Glad you like them
Great video, before interview I watched and more or less I got this questions. Tysm 😃
It was good that you reminded me of these. Thanks a lot
Hey buddy, you are super good.. your way of teaching along with examples is amazing. My concepts are very clear now..... Do you have any video exclusively on INDEXING... If yes please share the link and if not, could you please make one. Thanks a lot.. You are doing great. All the best
Thank you Jayant 🙏🏼
Very happy to read such positive comments :)
Related to indexes , I do not have a video as of now but will plan to make one in the near future
Toufiq bro ur videos on SQL r very helpful and we'll xplained bro🤘
Hi Taufiq;
Please make a detailed video on indexes and types of indexes.
Thankyou very much.. its really helpful ..
Glad you liked it
Very good sir.... please make video on SQL constraints
Thank you.. I’ll cover constraints when I make the sql tutorial series
@@techTFQ when u cover SQL tutorial series?
Hi taufiq, great videos. Kudos for the content. Would like to see really good and elaborated vedio on triggers and its type when to use etc.
Thoufiq your videos helped a lot for interviews thanks for that and can you make videos on PLSQL
Glad to hear that Venky and will cover PL/SQL in near future
Hey hi...
could you make a video on.... how to validate the data using sql in different databases as part of ETL
Also If you cover a real time scenario it would be helpful.
Not really planning on ETL videos any time soon but will consider it for the future
Hello,
I am also preparing for sql beginners level interview.
I hope this videos make me successful in my interview ✌
That was awesome bhai👏🏻😊
Thank you very much 😊