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. 🎉🎉🎉
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 TH-camr video best of me and unfortunately came across to taufiq sir videos and it's one of my beat decision to choose your TH-cam channel. Thank you taufiq sir❤
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.
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.🎉
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.
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 .
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.
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.
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, 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.
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 👏
Q.11)> select substring(full_name,1,instr(full_name,' ')) as first_name from dual; select left(full_name,instr(full_name,' ')) as first_name from dual;
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 .
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
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. 😊🙏🏾
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.
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...
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
every answer to his question is his blog guys. in the video, his answer for every question is check my blog, so don't waste your time and skip this video.
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.
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 🙏🏻
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.
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🙌🏻
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.
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
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?
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 TH-camr video best of me and unfortunately came across to taufiq sir videos and it's one of my beat decision to choose your TH-cam channel. Thank you taufiq sir❤
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
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
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 ☺️
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”
"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
Thank you for coming up with this video. It helped me to get a glance at what to expect in interviews.
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
Really hats off to you Sir. Very patiently and explained with detailed information .
Thank you :)
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
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 🙏🏼
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 .
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 ☺️
SQL in different sql versions is something I appreciate on your blog. 👍
This video is gold, thanks bro!
Glad you liked it buddy
Thank you for all details information 🙏🙏
Your welcome 🙏🏼
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.
your voice is so soft and clear....that is verry impressive and easy to understand......this vedio is helpfull
what a perfect explanation alongwith cool mind , many things learned from u like sql
Glad to hear that! Thank you Ramesh :)
Very well and detailed explaination toufiq......THnaks for your Efforts and Blog....Kep it up brother...
Thank you buddy 🙏🏼
Reallly so helpful and so clear
Glad it was helpful!
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.
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
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
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
Best video I have ever seen on SQL ....🙏👌
Thank you Rushikesh 🙏🏼
Glad you liked it ..
So happy to have you kind of teacher ❤️❤️❤️❤️ thanks Afghanistan 🇦🇫🇦🇫🇦🇫
Thankyou very much.. its really helpful ..
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 ..
was able to answer all except 4-5 . Thnx for this.
Q.11)> select substring(full_name,1,instr(full_name,' ')) as first_name from dual;
select left(full_name,instr(full_name,' ')) as first_name from dual;
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
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..
best content on internet. glad to find you
Thank you Isha :)
Glad you liked it.
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
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
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.
Haii Thofiqq
Great Explaination
about SQL
really crystal Clear and Awesome
keep Going...
Thank you Keerthi
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
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 sir, Great video.
Please make video on Query execution plan and Optimization.
Thank you and will consider making those videos in the future 🙏🏼
If TH-cam 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 😃🙏🏼
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
Your content is great and very very helpful. Thanks from Paraguay
Thank you so much TFQ ..ur videos are more useful ❤im following ur videos and learning SQL
Great it could help
Toufiq bro ur videos on SQL r very helpful and we'll xplained bro🤘
Thank you so much, sir
your teaching was superb
🔥🔥🔥🔥🔥🔥
Thanks for your valuable blog..
It is so benefit for students like us to clear our technical interview.
Loved this ❤ Just watched.. Thanks
Thank you Shawn 🙏🏼
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...
Thank you Bro your videos is very helpful.
It is very healpful for us.
Glad to hear this bro ..
@@techTFQ how to take course from you 😊
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 😅
TQ u sir it's great job it is helpful attending the interview
Your welcome Gangadhar.. glad this helps
Hello,
I am also preparing for sql beginners level interview.
I hope this videos make me successful in my interview ✌
I discovered your channel today. excellent contents. Straight to the point with clear examples
Thank you Sir, I love your helpful videos!
Your welcome bro
Glad you like them
It is soooo useful video. Thank you a lot
glad you liked it
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 🙏
thank you for the wonderful information
Your welcome 🙏🏼
Thank you! This is a big help. Thanks for breaking it down
taufiq bhai thankyou so much
Your welcome buddy
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 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 :)
Very informative , Thank you brother
Your welcome bro 🙏🏼
Great Video as always...
Please can you make video on store procedure
Thank you 🙏🏼 and will do soon
Thanks a lot for your Videos on SQL!!!
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
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
What a great resource your channel is! MashaAllah love your content and your course on lighthouse.
Thank you Anas :)
Great deal brother. I appreciate the knowledge. You the man.
Very well explained bro, Thanks :)
Spot on! You’re videos are very reliable! ❤❤
Tq u so much sir👏
Really this is very useful vedio👌👌👌
It was good that you reminded me of these. Thanks a lot
Thankyou so much @sir 😇
your welcome :)
every answer to his question is his blog guys. in the video, his answer for every question is check my blog, so don't waste your time and skip this video.
Thanks for the demo and info, have a great day
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.
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
Great video, before interview I watched and more or less I got this questions. Tysm 😃
It helped me a lot in my interview journey .
Thanks Taufiq, you are good at explaining the concept
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
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 ..☺️
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
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
Great content indeed. Please make a video on index and different types of keys.
Thank you and will do in the future 🙏🏼
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
Great video sir. Thank you so much. 😊
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?
Great Work!!