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
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 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.
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.
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 .
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.
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. 😊🙏🏾
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❤
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.
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.
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 .
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.🎉
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
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 👏
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!
"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
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?
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”
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
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 🙏🏼
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 all details information 🙏🙏
Your welcome 🙏🏼
Thank you for coming up with this video. It helped me to get a glance at what to expect in interviews.
You're my SQL HERO, Taufiq!! Thank you for everything you do. You've helped my understanding IMMENSELY.
So grateful for you!
This video is gold, thanks bro!
Glad you liked it buddy
Reallly so helpful and so clear
Glad it was helpful!
This video is very helpful and thank you for the blog aswell.
Glad it was helpful!
Could you please share the blog link
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 .
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 ☺️
Really hats off to you Sir. Very patiently and explained with detailed information .
Thank you :)
taufiq bhai thankyou so much
Your welcome buddy
Thankyou very much.. its really helpful ..
Glad you liked it
Loved this ❤ Just watched.. Thanks
Thank you Shawn 🙏🏼
Best video I have ever seen on SQL ....🙏👌
Thank you Rushikesh 🙏🏼
Glad you liked it ..
Thanks a lot Sir !!!
Most welcome!
Thankyou so much @sir 😇
your welcome :)
Thank you! This is a big help. Thanks for breaking it down
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 :)
what a perfect explanation alongwith cool mind , many things learned from u like sql
Glad to hear that! Thank you Ramesh :)
Spot on! You’re videos are very reliable! ❤❤
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.
thank you for the wonderful information
Your welcome 🙏🏼
It is soooo useful video. Thank you a lot
glad you liked it
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❤
Thanks for your time and Knowledge sharing.Your videos are very much helpful for serious learners.
glad this helped
Very well and detailed explaination toufiq......THnaks for your Efforts and Blog....Kep it up brother...
Thank you buddy 🙏🏼
It is very healpful for us.
Glad to hear this bro ..
@@techTFQ how to take course from you 😊
Thank you Sir, I love your helpful videos!
Your welcome bro
Glad you like them
Good explanation👌👌
Thank you Nara
Your content is great and very very helpful. Thanks from Paraguay
Thanks a lot for your Videos on SQL!!!
Great video sir. Thank you so much. 😊
Great Work!!
SQL in different sql versions is something I appreciate on your blog. 👍
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 😅
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.
It is much needed for me thanks
Your welcome Shikha :)
Very happy to know this helps you..
Thank you Bro your videos is very helpful.
Thanks for the demo and info, have a great day
Very informative , Thank you brother
Your welcome bro 🙏🏼
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
Thank you so much for this video.
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
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..
recommended video 👍👍👍👍
Thank you 🙏🏼
Thank you so much, sir
your teaching was superb
🔥🔥🔥🔥🔥🔥
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 ☺️
Thank you so much TFQ ..ur videos are more useful ❤im following ur videos and learning SQL
Great it could help
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 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
Tq u so much sir👏
Really this is very useful vedio👌👌👌
was able to answer all except 4-5 . Thnx for this.
Awesome and valuable information!!
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
your voice is so soft and clear....that is verry impressive and easy to understand......this vedio is helpfull
Thanks for sharing 🙂
It was good that you reminded me of these. Thanks a lot
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
Thank you so much. I have an interview tomorrow
Really great Sir
Thank you for this😊
Great video 🙏🏾
TQ u sir it's great job it is helpful attending the interview
Your welcome Gangadhar.. glad this helps
best content on internet. glad to find you
Thank you Isha :)
Glad you liked it.
Thanks Taufiq, you are good at explaining the concept
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
"Hi, let's read this blog together. But not really. Go read it yourself"
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
Thank you dear
Your welcome 🙏🏼
Glad this helped
It helped me a lot in my interview journey .
Thanks. Great video.
amzing sir
Thank you 🙏🏼
Thank you sir
Great video!
Thank you 🙏🏼
Great video, before interview I watched and more or less I got this questions. Tysm 😃
Great video sir thank you sir
Amazing concepts! thanks
Very Nice Taufiq.....
Thanks:)
That was awesome bhai👏🏻😊
Thank you very much 😊
What a great resource your channel is! MashaAllah love your content and your course on lighthouse.
Thank you Anas :)
Good expected questions
Thank you Krushna :)
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 ..
I discovered your channel today. excellent contents. Straight to the point with clear examples
Great vid ty
Great Video!!
Hi sir, Great video.
Please make video on Query execution plan and Optimization.
Thank you and will consider making those videos in the future 🙏🏼
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 🙏
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
Great Video as always...
Please can you make video on store procedure
Thank you 🙏🏼 and will do soon
great work....
Thank you 🙏🏼