Top 25 SQL Interview Questions and Answers(The BEST SQL Interview Questions)

Рет қаралды 778,795

Күн бұрын

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

Пікірлер: 600

@dany21tr Ай бұрын

"good question you can check the answer in my blog, next question oh you can definitely check the answer in my blog"

@igloo211 8 ай бұрын

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

@ft_peakhd2921 Жыл бұрын

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 .

@enshk79 Жыл бұрын

You're my SQL HERO, Taufiq!! Thank you for everything you do. You've helped my understanding IMMENSELY. So grateful for you!

@priyankadevi-zl9jx 2 жыл бұрын

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!

@honestreview4670 2 жыл бұрын

you are right

@DarrellWolfe Жыл бұрын

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. 🎉🎉🎉

@explodev2550 3 ай бұрын

Hello are you working now?

@gparvez6695 2 жыл бұрын

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.

@techTFQ 2 жыл бұрын

Thank you for sharing these parvez.. it’s good to know

@TheVishalrockstar 2 жыл бұрын

hi buddy can u help me to search good company

@suneetha11697 2 жыл бұрын

Thanks

@LAKSHITBHATNAGAR Жыл бұрын

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 .

@Sesquipedaliofobia 7 ай бұрын

Hi, how did it go?

@jsmithers. 3 ай бұрын

@@SesquipedaliofobiaHe didn't get it..

@anjalipandey3730 Жыл бұрын

Thank you for coming up with this video. It helped me to get a glance at what to expect in interviews.

@scarefacearinze5981 Жыл бұрын

I discovered your channel today. excellent contents. Straight to the point with clear examples

@girijashamak9142 2 жыл бұрын

Happy to see the growth of your channel young man. Very much deserved . Appreciate your time and efforts . God bless 🙏

@techTFQ 2 жыл бұрын

Thank you so much Girija :) Truly appreciate the blessings 🙏

@selectstation6827 3 ай бұрын

Great deal brother. I appreciate the knowledge. You the man.

@akshaykumarsingh9770 2 жыл бұрын

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.

@techTFQ 2 жыл бұрын

Thank you Akshay for such kind words 🙏🏼 Truly appreciate the support ☺️

@rick2591 2 жыл бұрын

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.

@techTFQ 2 жыл бұрын

That’s right .. some rdbms have certain enhancements which are very useful like the one you mentioned..

@laurak5196 2 жыл бұрын

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! 🙏🏻😀

@techTFQ 2 жыл бұрын

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 🙏🏼🙏🏼

@laurak5196 2 жыл бұрын

@@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 2 жыл бұрын

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..

@laurak5196 2 жыл бұрын

@@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 🙏🏻

@techTFQ 2 жыл бұрын

Glad to hear this Laura.. I wish this helps you to clear any SQL interview in the future

@hopecelebre3083 Жыл бұрын

Spot on! You’re videos are very reliable! ❤❤

@johnpg3055 2 жыл бұрын

Great content Thoufiq.. Your videos are really helpful. Waiting for your complete SQL tutorial series.. Functions, Stored Procedures, Triggers, etc. Thanks a lot.

@techTFQ 2 жыл бұрын

Thank you John 🙏🏼 Will make those soon ..

@RamzanAnsari-eo4hs 3 ай бұрын

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 KZfaqr video best of me and unfortunately came across to taufiq sir videos and it's one of my beat decision to choose your KZfaq channel. Thank you taufiq sir❤

@arulvishwakarma007 Ай бұрын

I am a DA and i can say that all these questions are very common and are asked alot ! whereas these questions are only limited till interviews and are of no use in day to day activities... therefore whatever is told in the video is more than enough to crack SQL questions and answers. But I highly suggest DATA LEMUR to practice your SQL coding skills

@rakesh_bangla 2 жыл бұрын

Thank you for the valuable knowledge and guidance!

@devendraraghuwanshi3136 2 жыл бұрын

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

@techTFQ 2 жыл бұрын

Thank you for the blessings buddy 🙏🏼🙏🏼 Happy to know you liked it

@SagarKumar-db2xy 2 жыл бұрын

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.

@techTFQ 2 жыл бұрын

Your welcome bro.. glad this helps

@sabhrang4013 2 жыл бұрын

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.

@techTFQ 2 жыл бұрын

Awesome Sabhrang and thank you for liking my contents ☺️ Happy to read this comment

@BipinKumar-ou7tj Жыл бұрын

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...

@pio024 2 жыл бұрын

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!

@techTFQ 2 жыл бұрын

I am so glad that even an experience professional like you too found this helpful 🙏🏼🙏🏼 All the best with your interview 👍

@johnetim5274 Жыл бұрын

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.

@mohammedshahil4898 2 жыл бұрын

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🙌🏻

@techTFQ 2 жыл бұрын

Your welcome hero ❤️❤️ Will do JOINS video soon

@SQL Жыл бұрын

It's a great lecture. Thank you! 🥰

@Ragima001 5 ай бұрын

It was good that you reminded me of these. Thanks a lot

@iceberg1490 8 ай бұрын

Thanks Taufiq, you are good at explaining the concept

@mohammedshabaaz9625 Жыл бұрын

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.

@merlinevinter3766 7 ай бұрын

Thanks a lot for your Videos on SQL!!!

@sonalilagnajita8740 2 жыл бұрын

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.

@techTFQ 2 жыл бұрын

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

@chithrac9600 2 жыл бұрын

Thank you. Those are very good questions and you have explained them very well. Great tutorials. Definitely would be helpful for everyone.

@techTFQ 2 жыл бұрын

Glad you liked it

@pujashree2402 2 жыл бұрын

Great video, before interview I watched and more or less I got this questions. Tysm 😃

@Blessed_SDP 8 ай бұрын

Great video sir. Thank you so much. 😊

@gauravmathur56 Жыл бұрын

It helped me a lot in my interview journey .

@deepakgauba3592 Ай бұрын

Sir for Q.11 you can also simply do it by writing SUBSTRING_INDEX(FULL_NAME, " ", -1)

@rakhiyadav7977 Жыл бұрын

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.😊

@techTFQ Жыл бұрын

Thank you Rakhi and noted on the request,

@songsfortheking1 5 ай бұрын

Thank you for sharing

@SHIBIYAYA 2 ай бұрын

Thanks very much !

@nishantchauhan6164 Жыл бұрын

Solution to question 11 can also be done using split method, I remember I used it earlier on SQL server.

@a.adegboyega Жыл бұрын

Amazing concepts! thanks

@ganeshvlogs6016 Ай бұрын

nice video ...Thank you so much ..

@chrisumali9841 Жыл бұрын

Thanks for the demo and info, have a great day

@krishnabathula4104 2 жыл бұрын

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. 😊🙏🏾

@techTFQ 2 жыл бұрын

Thank you Krishna :) I am glad this helped 🙏

@krishnabathula4104 2 жыл бұрын

@@techTFQ pleasure is mine sir.

@laurak5196 Жыл бұрын

I just came here to say look at you fly with 166K!!! And you deserve it, Thoufiq, content always right on point. Thank you 🙏🏻

@techTFQ Жыл бұрын

Thanks Laura 🙏🏼 As always very kind of you ☺️

@sribastavrajguru304 2 жыл бұрын

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

@techTFQ 2 жыл бұрын

Thank you Sribastav 🙏🏼 Glad to know you liked it

@okedeborah4568 9 ай бұрын

Thank you for this😊

@robalarcon Жыл бұрын

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 😅

@harshshah9006 10 ай бұрын

was able to answer all except 4-5 . Thnx for this.

@balajivijaykumargoli3114 5 ай бұрын

Really hats off to you Sir. Very patiently and explained with detailed information .

@techTFQ 5 ай бұрын

Thank you :)

@tonyjinca 2 жыл бұрын

Thank you Sir, I love your helpful videos!

@techTFQ 2 жыл бұрын

Your welcome bro Glad you like them

@mathieudager4234 2 жыл бұрын

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

@techTFQ 2 жыл бұрын

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..

@thomaspfanstiehl6156 2 жыл бұрын

Great idea I was thinking of the same thing !

@techTFQ 2 жыл бұрын

May be will consider it for the future contents

@anaskhan4841 2 жыл бұрын

What a great resource your channel is! MashaAllah love your content and your course on lighthouse.

@techTFQ 2 жыл бұрын

Thank you Anas :)

@RameshCh-me8jm Жыл бұрын

You're videos are helping me a lot 🙂

@martinfernandezcean Жыл бұрын

Your content is great and very very helpful. Thanks from Paraguay

@sanketshambharkar3687 Жыл бұрын

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

@carnivorecommando9617 3 ай бұрын

thanks taufiq

@saudahmed9962 7 ай бұрын

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.

@santoshsable1 2 жыл бұрын

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.

@techTFQ 2 жыл бұрын

Thank you for liking my contents and yes I plan to make a complete SQL tutorial series covering all SQL concepts soon

@bhaskarkotini4894 2 жыл бұрын

@@techTFQ even I am waiting for your SQL complete video series

@techTFQ 2 жыл бұрын

Thank you 🙏🏼

@9242224526 Жыл бұрын

Thanks for your time and Knowledge sharing.Your videos are very much helpful for serious learners.

@techTFQ Жыл бұрын

glad this helped

@debapriyabehera7146 6 ай бұрын

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.🎉

@techTFQ 5 ай бұрын

You're welcome ☺️ All the best

@tarakrama Жыл бұрын

Awesome and valuable information!!

@ladysay3 2 жыл бұрын

Thanks. Great video.

@kandulasujith1206 9 ай бұрын

Thank you.

@deepthirayala6055 8 ай бұрын

Thank you so much, sir your teaching was superb 🔥🔥🔥🔥🔥🔥

@minalwaman8629 Жыл бұрын

Thankyou very much.. its really helpful ..

@techTFQ Жыл бұрын

Glad you liked it

@gparvez6695 2 жыл бұрын

This video is very helpful and thank you for the blog aswell.

@techTFQ 2 жыл бұрын

Glad it was helpful!

@maruthimadhu2250 2 жыл бұрын

Could you please share the blog link

@-VAISHNAVID 10 ай бұрын

Thanks for your valuable blog.. It is so benefit for students like us to clear our technical interview.

@abdulsamadibrahim4929 2 жыл бұрын

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.

@techTFQ 2 жыл бұрын

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

@jaggu_90 9 ай бұрын

your voice is so soft and clear....that is verry impressive and easy to understand......this vedio is helpfull

@rameshchavda4117 2 жыл бұрын

what a perfect explanation alongwith cool mind , many things learned from u like sql

@techTFQ 2 жыл бұрын

Glad to hear that! Thank you Ramesh :)

@HenrryWith2Rs Жыл бұрын

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”

@RameshCh-me8jm Жыл бұрын

Thanks for sharing 🙂

@AkashDeep-ux1ig 2 жыл бұрын

Thanks a lot for your efforts

@vijayalaxmi648 Жыл бұрын

Hello, I am also preparing for sql beginners level interview. I hope this videos make me successful in my interview ✌

@an_ugly_girl 2 ай бұрын

Jazakallahu khairan🎉

@dhemanth7437 3 ай бұрын

Hi Tofique your videos are really valuble thank you

@manuvats523 2 жыл бұрын

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 !

@techTFQ 2 жыл бұрын

Thanks Manu , Sure will cover procedure soon

@teeks4geeks Жыл бұрын

Thanks!

@sourabhbhandary1181 2 жыл бұрын

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.

@shivajikakad5098 10 ай бұрын

Very well explained bro, Thanks :)

@poojabiradar3832 8 ай бұрын

Great video sir thank you sir

@srt5806 2 жыл бұрын

Great article & Video on SQL Interview Questions! Please make videos on Sql query performance tuning.

@techTFQ 2 жыл бұрын

Thanks bro.. will make video on performance tuning in the near future

@dhirendratripathi891 Жыл бұрын

Great lecture ! , I would you request to pleas make video on Indexing

@shawnmendoza3321 2 жыл бұрын

Loved this ❤ Just watched.. Thanks

@techTFQ 2 жыл бұрын

Thank you Shawn 🙏🏼

@buvaneshb423 2 жыл бұрын

thank you for the wonderful information

@techTFQ 2 жыл бұрын

Your welcome 🙏🏼

@meenupanwar7561 Жыл бұрын

Hi Taufiq; Please make a detailed video on indexes and types of indexes.

@Kushbukush 7 ай бұрын

Thank you so much TFQ ..ur videos are more useful ❤im following ur videos and learning SQL

@techTFQ 5 ай бұрын

Great it could help

@giovannymartinez1147 Жыл бұрын

This video is gold, thanks bro!

@techTFQ Жыл бұрын

Glad you liked it buddy

@madhusmitatripathy8767 2 жыл бұрын

@techTFQ your content is rich and crisp but one observation "Whereas the below query will return the maximum salary for each department in the employee table" in the blog should be count of employees in the 2nd part. seems like a typo.

@dattatrayarathi1014 Жыл бұрын

Thank you for all details information 🙏🙏

@techTFQ Жыл бұрын

Your welcome 🙏🏼

@srishtidixitsd 9 ай бұрын

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.

@sanjanasanju5995 2 жыл бұрын

Thank you so much .... very well explained ...

@techTFQ 2 жыл бұрын

Thank you Sanjana 🙏🏼

@sanjanasanju5995 2 жыл бұрын

Sir , kindly suggest me any link or website to refer as I want to revise Oracle plsql in detail along with plsql database administration...

@techTFQ 2 жыл бұрын

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

@abhisheksinghrajput2611 2 жыл бұрын

It is very healpful for us.

@techTFQ 2 жыл бұрын

Glad to hear this bro ..

@naveensriram9866 Жыл бұрын

@@techTFQ how to take course from you 😊

@healthboostup44 Жыл бұрын

Reallly so helpful and so clear

@techTFQ Жыл бұрын

Glad it was helpful!

@MyTravelingJourney 2 жыл бұрын

Great content indeed. Please make a video on index and different types of keys.

@techTFQ 2 жыл бұрын

Thank you and will do in the future 🙏🏼

@jayantnayak4034 2 жыл бұрын

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

@techTFQ 2 жыл бұрын

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