SQL Server Interview Questions and Answers | SQL Interview Questions

Подписаться 204 тыс.

Просмотров 619 тыс.

50% 1

20 Plus SQL Server Interview Questions and Answers
For more SQL videos visit www.questpond.com/sql-server-...
For more such videos visit www.questpond.com
For more such videos subscribe ru-vid.com...
Syllabus covered in this video :-
00:00 Introduction
01:22 Question 1 :- Explain normalization ?
04:45 Question 2 :- How to implement normalization ?
05:44 Question 3 :- What is denormalization ?
07:07 Question 4 :- Explain OLTP vs OLAP ?
10:40 Question 5 :- Explain 1st,2nd and 3rd Normal form ?
18:02 Question 6 :- Primary Key vs Unique key ?
20:02 Question 7 :- Differentiate between Char vs Varchar ?
21:32 Question 8 :- Differentiate between Char vs NChar ?
22:25 Question 9 :- Whats the size of Char vs NChar ?
23:32 Question 10 :- What is the use of Index ?
24:03 Question 11 :- How does it make search faster?
26:36 Question 12 :- What are the two types of Indexes ?
26:51 Question 13 :- Clustered vs Non-Clustered index
29:14 Question 14 :- Function vs Stored Procedures
33:27 Question 15 :- What are triggers and why do you need it ?
34:58 Question 16 :- What are types of triggers ?
36:57 Question 17 :- Differentiate between After trigger vs Instead Of ?
37:03 Question 18 :- What is need of Identity ?
38:10 Question 19 :- Explain transactions and how to implement it ?
42:55 Question 20 :- What are inner joins ?
45:00 Question 21 :- Explain Left join ?
46:25 Question 22 :- Explain Right join ?
46:40 Question 23 :- Explain Full outer joins ?
47:34 Question 24 :- Explain Cross joins ?
SQL Interview Questions & Answers - Part 2 :-
Question 25:-Why do we need UNION ?
Question 26:-Differentiate between Union vs Union All ?
Question 27:-can we have unequal columns in Union?
Question 28:-Can column have different data types in Union ?
Question 29:- Which Aggregate function have you used ?
Question 30:- When to use Group by ?
Question 31:- Can we select column which is not part of group by ?
Question 32:- What is having clause ?
Question 33:- Having clause vs Where clause
Question 34:- How can we sort records ?
Question 35:- Whats the default sort ?
Question 36:- How can we remove duplicates ?
Question 37:- Select the first top X records ?
Question 38:- How to handle NULLS ?
Question 39:- What is use of wild cards ?
Question 40:- What is the use of Alias ?
Question 41:- How to write a case statement ?
Question 42:- What is self reference tables ?
Question 43:- What is self join ?
Question 44:- Explain the between clause ?
SQL Interview Questions & Answers - Part 3 :-
Question 45:- Explain SubQuery?
Question 46:- Can inner Subquery return multiple results?
Question 47:- What is Co-related Query?
Question 48:- Differentiate between Joins and SubQuery?
Question 49:- Performance Joins vs SubQuery?
SQL Server Interview Questions & Answers - Part 4 :-
Question 50:- Find NTH Highest Salary in SQL.
SQL Server Interview Questions & Answers - Part 5
Question 51:- Select the top nth highest salary using correlated Queries?
Question 52:- Select top nth using using TSQL
Question 53:- Performance comparison of all the methods.
See our other Step by Step video series below :-
For more such videos subscribe / questpondvideos
JavaScript Interview Questions: • JavaScript Interview Q...
Learn SQL Server Step by Step tinyurl.com/ja4zmwu
Learn Angular tutorial step by step tinyurl.com/ycd9j895
OOPS interview questions and answers:- • OOPS Interview Questio...
ASP.NET MVC Core Interview Questions with answers:- • ASP.NET MVC Interview ...
C# interview questions and answers:- • C# Interview Questions...
C# tutorial for beginners(4 hrs):- • C# Tutorial for Beginn...
Learn Azure Step by Step:- • Azure Tutorial for Beg...
Azure AZ-900 fundamentals certification :- • AZ 900 Certification |...
AZ- 204 certification Azure:- • Azure 204 Certificatio...
Learn MVC 5 step by step in 16 hours:- • Learn ASP.NET MVC 5 ( ...
Learn Design Pattern Step by Step goo.gl/eJdn0m
Learn MSBI Step by Step in 32 hours:- goo.gl/TTpFZN
Python Tutorial for Beginners:- • Python Tutorial for Be...
Learn Data Science in 1 hour :- tinyurl.com/y5o7qbau
Learn Power BI Step by Step:- tinyurl.com/y6thhkxw
PHP Interview Questions : • PHP Interview Question...
For more details contact questpond@questpond.com OR call (+91) 99675 90707, (+91) 77009 75156, 022-49786776.
Music Copyright :-
Corporate Business by Infraction
inaudio.org/
Video Link: • Infraction - Corporate...
If You want to contact the artist :-
Email: infraction.business@gmail.com
Website: inaudio.org
RU-vid: / infraction
Facebook: / inaudio.org
Spotify: open.spotify.com/artist/7qlhX...
Instagram: / infractionimhere
#SQLQuestions #SQLInterviewQuestionsandAnswers #SQLServerQuestions

Опубликовано:

6 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 268

@questpondvideos 2 года назад

ASP.NET, C# Job Market : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-H3JEWAp32-s.html SQL Step by Step - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uGlfP9o7kmY.html SQL Server Joins : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-KTvYHEntvn8.html Software Architecture Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-AtTgcbLOqMM.html 20 MSBI Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Nw_sHEKnOUE.html 10+ Power BI Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Cozc9WNBRt4.html Angular Step by Step Tutorial for Beginners : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--9VcW7MBDs8.html 25 Angular Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--jeoyDJDsSM.html 35 Important JavaScript Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Zb4dPi7CANU.html 30 Important C# Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-BKynEBPqiIM.html 25+ OOPS Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-u99wAoBjDvQ.html 25 Important ASP.NET Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-pXmMdmJUC0g.html 20 MySQL Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-9hfjC-BpY20.html 20 PHP Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-1bpNSynUrl8.html 5 MSBI Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5E815aXAwYQ.html

@ankitapanditkar3627 2 года назад

🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈😊🙈🙈🙈🙈😊🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊😊🙈🙈😊🙈🙈🙈🙈😊🙈🙈🙈🙈😊😊🙈🙈🙈🙈🙈🙈😊🙈🙈😊🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈🙈🙈😊🙈😊🙈🙈🙈🙈🙈🙈😊😊😊😊😊🙈😊🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈😊🙈🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈😊🙈🙈🙈🙈😊🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈😊🙈🙈🙈😊🙈🙈🙈😊🙈🙈😊😊😊🙈😊🙈🙈🙈🙈🙈😊😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊😊😊🙈😊🙈😊😊🙈😊🙈🙈🙈🙈😊😊🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈😊😊🙈😊😊😊😊😊🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈😊🙈🙈😊🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈😊🙈🙈🙈😊🙈🙈🙈🙈🙈😊😊😊🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈🙈😊😊

@UNVSatya Год назад

Need more interview videos on SQL DBA

@pradeepb4625 Год назад

I share this to my linked in acc but as of now i didnt get any pdf

@questpondvideos Год назад

@@pradeepb4625 PDF will be sent to you after verifying the shared post. thanks.

@pradeepb4625 Год назад

@@questpondvideos yes i got it, later i check👍

@inthumathy9075 Год назад

You are awesome. I have 6 years of experience in sql server but regarding normal forms and indexes I only knew the definition and never understood the actual concept. After watching this video I have clear understanding and I’ll never forget. You have awesome teaching skills. Thank you so much

@VisionVibesNew 2 года назад

I'm working since 3 years as a developer and i thought I'm a Superman in development. But going through this video i can say that i got very much & best technical knowledge... We implements thousands of things from theory but doesn't know their technical definitions and basic. Thank you Manish Sir for this best content. I still remember my struggling days in Mumbai before 4 years ago and at that time too I was referring your videos on C#. At that time I even don't have a money to spend on the courses. But I took benifits from your RU-vid channel. Today there are many channels on YT but at that time you was only one who were helping us... I must say that for all developers who come from middle & low class, you are super hero for all of us .... Thank You Sir!!

@rohit-gupta 2 года назад

This video is so much better than all my college lectures combined. Thanks :)

@anika7277 Год назад

So correct, Damn!!! such professors would have made me score 100% during College days. Its not about the student is dumb or intelligent, everyone is intelligent, provided Professors do their job correctly like this person. I doubt any student will ever fail in this kinda lecture.

@Victor-yn6lv Год назад

This video is amazing for SQL beginners to condense their SQL knowledge for interviews. Thank yo so much!

@balajic4684 2 года назад

great video to go through the Sql within 1 hour . Covered all the parts except functions . Thanks

@ayubmetah1558 Год назад

the instructor is very clear and audible.

@tiagosilva856 2 года назад

Very good job. Nice vid. Right to the point with clear and objective answers. Cheers from Portugal 🇵🇹

@FusionTV07 2 года назад

One of the best video Frome 2 months of my RU-vid search.. waiting for part 2..

@shivaaynamah6612 10 месяцев назад

Before watching this, I went through many videos and got a little information but this video gave a broader idea in very simple terms. It must be recommended to everyone who is going for an interview for database developer or business intelligence developer.

@divyasingh5865 Год назад

Very very well explained :) Amazing content...best video I've ever seen on SQL....13 questions were asked by my interviewer from this video.

@waqarkabir 8 месяцев назад

For quick review. char takes 1 byte per character N in char takes 2 bytes per character Index = increase search performance , balance tree structure, nodes and leaf nodes Index types = Clustered and Non-Clustered Indexes Function = For computations, Only select is allowed, can be call by select and where and from stored procedures, should have 1 input with a return value. type can be scalar and table valued Stored Procedures = CRUD ops, can not be called from select/where/other functions, can have single or multiple outputs, exec Triggers = logic which can be execture after CRUD on any table Trigger Types = after (do something on CRUD) and instead of (do some instead of CRUD or any query) Identity = Auto incremented value of a column, seed Transaction = treat series of activities as one logic unit begin try begin tran insert into table1(column) values(value) insert into table2(column) values(value) commit tran end try begin catch rollback end catch Inner join = Matching records from both tables Left join = All records from table on left side of join and only matching records from right side table of join. Right join = All records from table on right side of join and only matching records from left side table of join. full outer join = all records from both tables are extracted and in case of non matching null is shown cross join = cartesian product, every record of left table is multiplied with right table

@a2zguide216 14 дней назад

Please explain CRUD

@echo2net Год назад

so many questions for so many years have been answered here. Thanks so much!

@ebenss8997 2 года назад

I love this vidoe thanks alot I'm presently taking classes on SQL server DBA

@santoshrout3487 2 года назад

Got very much & best technical knowledge though I am into development for 2 Years. Techniques and way of presentation is superb.

@mohsinpatel5408 Год назад

The basics are very smartly explained. Good knowledge. ❤

@abrahamvincent6272 2 года назад

Good and clean explanation.with perfect examples.great job

@tikaw5336 Год назад

this is probably the best SQL video ive ever seen on youtube holy shit

@anilchaudhary9498 2 года назад

Thank u so much shiv koirala sir for share the SQL interview questions series.👍

@edge6192 2 года назад

Watched whole video....this is gold.

@tusharkantidas4622 2 года назад

wonderfull. Completely clear explanations...LOVE IT.

@sambeetofficial6464 23 дня назад

This video is such a gem ...never understood any concept rather tried to remember to give answer in interview..kudos to you Sir

@satishb9975 2 года назад

Thank you 😊sir 🙏you really understood what problems present students are facing and having and knowing partial information. Knowledge is everywhere but it's not enough and complete. Thank you very much of explaning in detail effort of each query. 🙏

@devaguru24 2 года назад

Yes!! Thank you for making this video. Very helpful to us

@dhruvkotak6220 2 года назад

Best SQL video I have ever watched

@SoniaSharma-fm8ym 2 года назад

Thanku so much sir for amazing content. You way of explanation is best I must say.

@utsavbose5746 Год назад

Concisely presented and very helpful Thanks for the upload.

@saurishroy781 Год назад

Very nice video. 💯 To the point, no nonsense.

@madhunalalavanya4522 2 года назад

this was very helpful for beginners its awesome, easy to understand. Thank you

@seanangeluasmolo1471 Год назад

awesome! thank you! and good luck to us reviewing for technical interviews xD

@thenmozhithangavel4161 2 года назад

Very good explanation.. the way you teaching is very interesting.. Thank you!!

@mabidong 2 года назад

Nepal in example made me so connected. Thank you for such a great collection.

@kathiravanjagadeesan1128 10 месяцев назад

Beautiful explanation. You are graceful.

@sonipk30 4 месяца назад

Your Way Of Explaination is very Good .....useful Video...thank u

@gopikrishna9046 2 года назад

Thank you sir for explaining in easy everyone will understand.

@alivelumangmma319 2 года назад

Superb explanation,bestvideo

@erandafernando94 Год назад

if this channel exisited when i did my bachelors, I would have gotten a first class lol.

@divinetarla3995 5 месяцев назад

❤❤

@angelthedecentgirl7181 2 года назад

Amazing explanation sir. A big Thank You! Pleasemake more videos on queries for interview as a Data Scientist and Data Analyst profile specifically.

@Fato0omaFahmy97 9 месяцев назад

I had my full stack interview today and 90% of questions were from your videos 🙏🙏 thank you very much sir your videos really helped me ❤️❤️

@_AkshitaSharma 8 месяцев назад

Hey girl where r u frm...

@maheshbilla5048 2 года назад

I have never seen such great voice and great lecture thank you so much sir

@rakeshpandey1899 2 года назад

Waiting for the next parts. Thankyou so much for the amazing video.

@karthipalanivel6345 2 года назад

No words to say you are awesome your way of presentation is very excellent!!!!!!!!!!!!!!!!

@basavaraju5888 Год назад

Great Explanation, Thank you very much.

@tonymathewjohn5958 2 года назад

very good , thank you very much for this free class.

@kondareddy5176 2 года назад

Super sir this video is very important for the interview question thank you sir

@rathnamadhuri6205 Год назад

You are an excellent teacher Sir. Thank you

@pratikmurke3314 2 года назад

If I crack interview with the help of ur questions I really Very Thankful to you...BTW nice information.

@subashvenugopal9952 2 года назад

Happy teacher's day sir. Jai Hind

@mahadevsadekar1102 Год назад

Thank you for such in depth defination it helps alot of people 🙏

@Funlearnlove Год назад

Detailed explanation sir... find it useful.. Thank you :)

@pseudofacts4356 2 года назад

Happy Teachers Day !! Shiv Sir.. Your Angular Interview Qns and Azure CI/CD are blessing.

@tejap7308 2 года назад

Can you please share Azure CI/CD videos of Shiv sir?

@iHamzaKhanzada 2 года назад

@@tejap7308 +1, please share the link of Azure CI/CD video

@nagarajsn14 Год назад

Love that motivation :) Evrything is fair in 'Getting Job' and War :)

@mohdsaad-rg8fw 2 года назад

Thank you so much, It's a gold video

@300lazio 2 года назад

Great video!! You are gifted to teach. Keep it up👍👍

@amitsingh-wu9tx Год назад

Tq this is like a revision for my interview on SQL basic part

@oganovdavid 4 месяца назад

Great tutorial! Thanks for the video! I wish you have also covered relationships in SQL. But either way, this is a gem

@JossinJax Год назад

Excellent material, thank you.

@gouriknandy5514 3 часа назад

Thank you. Very well explained

@Aparna.Ratheesh 4 месяца назад

Excellent lecture. Thankyou for this :)

@rockagain5416 2 года назад

Sir really excellent explain everything Also you motivated us in this video thankyou so much for your informative video.

@arushsingh4841 2 года назад

Excellent content as always !! Thank you :)

@c.d.premkumar6867 2 года назад

Excellent in Content and Explanation !

@dawnhuttoe7204 2 года назад

This is sooo informative. I thank you so much👍

@hamidabano2075 2 года назад

Loved your teaching methods!! Crisp and to the point ! Thankyou so very much sir❤❤❤

@user-qw3vs1gd5f 10 месяцев назад

Thank you, so much for the beautiful session

@abdullahahmed8468 Год назад

really thanks a lot, there is a lot of useful information and tip&tricks and you made them very simple 😁

@karpagammohan6605 2 года назад

Awesome Preparation sir!!!

@gokilaraja889 Год назад

Hi Sir, your sql videos are really understandable. I learnt a lot from SQL videos...Thanks a lot!!!! can you please put a video regarding Unix shell scripting..I dont have any idea on UNIX shell scripting.. I like to learn from your video for easy understanding.

@lsk1484 2 года назад

Very nice video...Thumbs Up !!!

@nicholasthompson2752 2 года назад

This is great, thanks so much.

@Blablabla-rq3to Год назад

Wow, you are really clear!

@edenmelkamu4570 9 месяцев назад

very helpful video, thank you ❤

@nikhilkamble390 6 месяцев назад

Thank you making videos like this, it is helping me alot. thank you

@uppalasowjanya7889 2 года назад

It is really helpful for me, thanks

@srinathnaidu6621 Год назад

Nice video. It's very satisfying to listening

@andreiaquino8994 2 года назад

Thank you! Very helpful bro

@user-zd5yp2hg1g 3 месяца назад

thanks for the best explanations.

@reshmarajendran9513 Год назад

Awesome and very much informative video

@sudhashahi7263 2 года назад

Thank you for this video.

@hasanmougharbel8030 Год назад

Hey there, excited to discover your channel I am a newbie sql learner with simple enquiry. What is the component of SQL Server Replication? What is it applied for, or what is its basic functionalities in the sql server? Thanks for taking care of this.

@rahulgawade5748 Год назад

This is so awesome 😎 kudos!

@vibhumaheshwari2936 2 года назад

Wow..give 5 🌟 amazing explanation

@rahulgautam511 2 года назад

Good source of knowledge.

@PrakashPatil-dw5be 2 года назад

Well explained 🙏

@shama2834 Год назад

Thanks a lot for the explaining so well sir

@poornimam5384 10 месяцев назад

Simply superb...

@MrXferns 2 года назад

Thank you for ur valuable time

@princebhardwaj5612 Год назад

Video is amazing !

@yousufanwer99 2 года назад

Amazing so Helpfull

@HelalUddinmohammad 2 года назад

Salute, Guruji!

@amit63675 Год назад

Thank you so much sir for superb video

@rasikasamith 5 месяцев назад

Good video. Thanks a lot.

@arideepchakraborty5642 2 года назад

Very good explanation

@andhratourist7081 2 года назад

ThankYou so much sir

@yasinarafat8476 6 месяцев назад

thank you sir this video was very helpful

@DipendraShekhawat 2 года назад

Great explanation 👍

@mpaudel2010 2 года назад

it is very helpfull video thank you so much for it.

@abhishekparihar1 2 года назад

Excelent work , one of the best tutorial video with very clear cut anc crisp explanation

@maishacute4491 2 года назад

Good explanation sir thanks

@nikolaybilov9539 Год назад

In my opinion you mixed there questions from so different levels of knowledge. Some of them about hard fundamentals are new for me with my fifteen years experience some are so trivial that I think everyone who worked more than half of week can answer it. Especially question 14.