Top 25 SQL Interview Questions and Answers(The BEST SQL Interview Questions)
Vložit
- čas přidán 17. 06. 2024
- In this video, I will share my Top 25 SQL Interview Questions and Answers which I have captured from my own experience of using SQL for the past 12 years. Learn these SQL Questions and also all the SQL concepts which are covered in these 25 questions to clear any SQL Interview.
In this video, I will go through my pick for the top 25 SQL interview questions and then provide some additional information on what the interviewer is expecting from you when he asks these questions. The answers to each of these 25 SQL questions are present in my blog. I have written a blog in my website techTFQ where I have mentioned these 25 questions along with the answers to these 25 questions.
In this video, I will go through the questions but will not explain all the answers in detail. You can find all the answers in my blog.
Link to my blog: techtfq.com/blog/top-20-sql-i...
Link to my playlist covering all SQL Interview Queries: • Playlist
Link to window function video: • Playlist
Timestamp:
00:00 Intro
02:28 SQL Interview Questions (#1 to #5)
07:05 SQL Interview Questions (#6 to #10)
11:43 SQL Interview Questions (#11 to #15)
16:52 SQL Interview Questions (#16 to #20)
22:14 SQL Interview Questions (#21 to #25)
One of the most challenging part of preparing for an SQL interview is to identify what the SQL concepts we need to learn to clear the interview. Hence in this video, I wanted to share from my experience what were the top SQL questions for clearing Interview. I have come up with these questions after taking several SQL interviews myself and also by giving several SQL interviews over the past 12 years of the work experience.
These questions are just in my opinion the most important SQL questions or SQL concepts that you need to prepare before an SQL interview.
These questions are not in any specific order and the questions are scattered for a beginner or fresher SQL developer to intermediate SQL position to a Senior level SQL position.
I hope the video and my blog would benefit you guys to clear SQL interview.
I'd be more than happy to know about your interview success stories. DO share them in the comments below if this video and my blog helped in any way.
🔴 WATCH MORE VIDEOS HERE 👇
✅ SQL Tutorial - Basic concepts:
• SQL Tutorial - Basic c...
✅ SQL Tutorial - Intermediate concepts:
• SQL Tutorial - Interme...
✅ SQL Tutorial - Advance concepts:
• SQL Tutorial - Advance...
✅ Practice Solving Basic SQL Queries:
• Practice Solving BASIC...
✅ Practice Solving Intermediate SQL Queries:
• Practice Solving INTER...
✅ Practice Solving Complex SQL Queries:
• Practice Solving COMPL...
✅ Data Analytics Career guidance:
• Data Analytics career ...
✅ SQL Course, SQL Training Platform Recommendations:
• SQL Course / Training
✅ Python Tutorial:
• Python Tutorial
THANK YOU,
Thoufiq
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
You're my SQL HERO, Taufiq!! Thank you for everything you do. You've helped my understanding IMMENSELY.
So grateful for you!
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
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
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?
Thank you for coming up with this video. It helped me to get a glance at what to expect in interviews.
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..
I discovered your channel today. excellent contents. Straight to the point with clear examples
"good question you can check the answer in my blog, next question oh you can definitely check the answer in my blog"
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 ☺️
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 🙏
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 ..
Great deal brother. I appreciate the knowledge. You the man.
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
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
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
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
Great video, always a good idea to brush up on whatever SQL instance the company will be using... In some db systems procedures that work far differently than they work for SQL Server, MySQL, Oracle. Others, like Postgress allow embedding an update in a cte... Keeping them all separate is a challenge.
That’s right .. some rdbms have certain enhancements which are very useful like the one you mentioned..
Spot on! You’re videos are very reliable! ❤❤
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
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
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 CZcamsr video best of me and unfortunately came across to taufiq sir videos and it's one of my beat decision to choose your CZcams channel. Thank you taufiq sir❤
Thank you for the valuable knowledge and guidance!
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's a great lecture. Thank you! 🥰
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
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, before interview I watched and more or less I got this questions. Tysm 😃
Hi Toufiq, i liked your videos and the way you explain concepts in simplest form. Would request to make videos on indexes as I always found it tricky to understand. Thanks in advance.😊
Thank you Rakhi and noted on the request,
It was good that you reminded me of these. Thanks a lot
Thank you once again Taufiq. This was another amazing video and much required.
Have a few suggestions here.
1.Request you to kindly make a PART 2 of this video with more new questions please?
2.A video on Triggers and Indexes
3.A video on Primary, foreign, composite keys.
I know these are simple topics but your explanations makes it very much easy like your videos on window functions,etc🙏
Thank you once again and hope you consider these suggestions.
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.
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 🙏🏼
What a great resource your channel is! MashaAllah love your content and your course on lighthouse.
Thank you Anas :)
Thanks a lot for your Videos on SQL!!!
Thanks Taufiq, you are good at explaining the concept
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
Thanks so much, TFQ. Always ditching out quality content. This will definitely go a long way for me! Thanks once again.
Also, please do will need to know all the other RDBMS in solving SQL queries? Or for example, PostgreSQL is enough? Thanks.
Thank you so much bro ..
SQL language is common across all RDBMS.. so just learning SQL in any one of the rdbms will be suffecient..
However some of the functions (like date format or substring function) may differ across different rdbms which you may have to check
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 ☺️
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 😅
Amazing concepts! thanks
Thanks for the demo and info, have a great day
Thank you Sir, I love your helpful videos!
Your welcome bro
Glad you like them
This video is very helpful and thank you for the blog aswell.
Glad it was helpful!
Could you please share the blog link
Great video sir. Thank you so much. 😊
It helped me a lot in my interview journey .
Your content is great and very very helpful. Thanks from Paraguay
Awesome and valuable information!!
This video is gold, thanks bro!
Glad you liked it buddy
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”
It is very healpful for us.
Glad to hear this bro ..
@@techTFQ how to take course from you 😊
Really hats off to you Sir. Very patiently and explained with detailed information .
Thank you :)
what a perfect explanation alongwith cool mind , many things learned from u like sql
Glad to hear that! Thank you Ramesh :)
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
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...
Thanks for your time and Knowledge sharing.Your videos are very much helpful for serious learners.
glad this helped
You're videos are helping me a lot 🙂
was able to answer all except 4-5 . Thnx for this.
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
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
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
Loved this ❤ Just watched.. Thanks
Thank you Shawn 🙏🏼
Solution to question 11 can also be done using split method, I remember I used it earlier on SQL server.
your voice is so soft and clear....that is verry impressive and easy to understand......this vedio is helpfull
Thanks. Great video.
Thank you for this😊
Great content indeed. Please make a video on index and different types of keys.
Thank you and will do in the future 🙏🏼
Very informative , Thank you brother
Your welcome bro 🙏🏼
Great lecture ! , I would you request to pleas make video on Indexing
Great video @Taufiq, Can you please create a detailed video on DDL and DML commands.
Thanks
Thank you Gajraj,
I’ll make it
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 ..☺️
Thanks for your valuable blog..
It is so benefit for students like us to clear our technical interview.
Hi Taufiq;
Please make a detailed video on indexes and types of indexes.
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.
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 the wonderful information
Your welcome 🙏🏼
Very well and detailed explaination toufiq......THnaks for your Efforts and Blog....Kep it up brother...
Thank you buddy 🙏🏼
Best video I have ever seen on SQL ....🙏👌
Thank you Rushikesh 🙏🏼
Glad you liked it ..
Very well explained bro, Thanks :)
Thanks for sharing such a good content everytime...
Your welcome bro.
Glad you like it..
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. I have an interview tomorrow
Thanks very much !
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.
Thank you so much, sir
your teaching was superb
🔥🔥🔥🔥🔥🔥
Thank you for sharing
Thank you for all details information 🙏🙏
Your welcome 🙏🏼
Reallly so helpful and so clear
Glad it was helpful!
It is much needed for me thanks
Your welcome Shikha :)
Very happy to know this helps you..
Great Video as always...
Please can you make video on store procedure
Thank you 🙏🏼 and will do soon
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
Hi sir, Great video.
Please make video on Query execution plan and Optimization.
Thank you and will consider making those videos in the future 🙏🏼
Thank you so much .... very well explained ...
Thank you Sanjana 🙏🏼
Sir , kindly suggest me any link or website to refer as I want to revise Oracle plsql in detail along with plsql database administration...
For Oracle PL/SQL, I haven’t come across any good course yet but I highly recommend doing the Oracle OCA and OCP certification which will cover everything u need to know about PL/SQL
Hi Thoufiq, your videos on SQL are really helpful, be it CTE or Window functions. Can you make a video on Regular Expressions?
Thanks Rahul 🙏🏼
I am so happy to read this ..
I have made a video on Regular Expression on python .. you can check that on my channel
Great vid ty
Great Work!!
Thankyou very much.. its really helpful ..
Glad you liked it
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 sir it's great job it is helpful attending the interview
Your welcome Gangadhar.. glad this helps