SQL Server Interview Questions and Answers | SQL Interview Questions
Vložit
- čas přidán 14. 06. 2024
- 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 czcams.com/users/questpondvide...
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
CZcams: / infraction
Facebook: / inaudio.org
Spotify: open.spotify.com/artist/7qlhX...
Instagram: / infractionimhere
#SQLQuestions #SQLInterviewQuestionsandAnswers #SQLServerQuestions
ASP.NET, C# Job Market : czcams.com/video/H3JEWAp32-s/video.html
SQL Step by Step - czcams.com/video/uGlfP9o7kmY/video.html
SQL Server Joins : czcams.com/video/KTvYHEntvn8/video.html
Software Architecture Interview Questions : czcams.com/video/AtTgcbLOqMM/video.html
20 MSBI Interview Questions : czcams.com/video/Nw_sHEKnOUE/video.html
10+ Power BI Interview Questions : czcams.com/video/Cozc9WNBRt4/video.html
Angular Step by Step Tutorial for Beginners : czcams.com/video/-9VcW7MBDs8/video.html
25 Angular Interview Questions : czcams.com/video/-jeoyDJDsSM/video.html
35 Important JavaScript Interview Questions : czcams.com/video/Zb4dPi7CANU/video.html
30 Important C# Interview Questions : czcams.com/video/BKynEBPqiIM/video.html
25+ OOPS Interview Questions : czcams.com/video/u99wAoBjDvQ/video.html
25 Important ASP.NET Interview Questions : czcams.com/video/pXmMdmJUC0g/video.html
20 MySQL Interview Questions : czcams.com/video/9hfjC-BpY20/video.html
20 PHP Interview Questions : czcams.com/video/1bpNSynUrl8/video.html
5 MSBI Interview Questions : czcams.com/video/5E815aXAwYQ/video.html
🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈😊🙈🙈🙈🙈😊🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊😊🙈🙈😊🙈🙈🙈🙈😊🙈🙈🙈🙈😊😊🙈🙈🙈🙈🙈🙈😊🙈🙈😊🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈🙈🙈😊🙈😊🙈🙈🙈🙈🙈🙈😊😊😊😊😊🙈😊🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈😊🙈🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈😊🙈🙈🙈🙈😊🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈😊🙈🙈🙈😊🙈🙈🙈😊🙈🙈😊😊😊🙈😊🙈🙈🙈🙈🙈😊😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊😊😊🙈😊🙈😊😊🙈😊🙈🙈🙈🙈😊😊🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈😊😊🙈😊😊😊😊😊🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈😊🙈🙈😊🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈😊🙈🙈🙈😊🙈🙈🙈🙈🙈😊😊😊🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈🙈😊😊
Need more interview videos on SQL DBA
I share this to my linked in acc but as of now i didnt get any pdf
@@pradeepb4625 PDF will be sent to you after verifying the shared post. thanks.
@@questpondvideos yes i got it, later i check👍
This video is so much better than all my college lectures combined. Thanks :)
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.
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 CZcams 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!!
This video is amazing for SQL beginners to condense their SQL knowledge for interviews. Thank yo so much!
if this channel exisited when i did my bachelors, I would have gotten a first class lol.
❤❤
great video to go through the Sql within 1 hour . Covered all the parts except functions . Thanks
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
Please explain CRUD
thanks bhai
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
the instructor is very clear and audible.
Very good job. Nice vid. Right to the point with clear and objective answers. Cheers from Portugal 🇵🇹
so many questions for so many years have been answered here. Thanks so much!
Good and clean explanation.with perfect examples.great job
The basics are very smartly explained. Good knowledge. ❤
One of the best video Frome 2 months of my CZcams search.. waiting for part 2..
wonderfull. Completely clear explanations...LOVE IT.
Concisely presented and very helpful
Thanks for the upload.
Thank u so much shiv koirala sir for share the SQL interview questions series.👍
this is probably the best SQL video ive ever seen on youtube holy shit
Very nice video. 💯 To the point, no nonsense.
I love this vidoe thanks alot I'm presently taking classes on SQL server DBA
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 ❤️❤️
Hey girl where r u frm...
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.
this was very helpful for beginners its awesome, easy to understand. Thank you
Very very well explained :)
Amazing content...best video I've ever seen on SQL....13 questions were asked by my interviewer from this video.
Watched whole video....this is gold.
Very good explanation.. the way you teaching is very interesting.. Thank you!!
Beautiful explanation. You are graceful.
This video is such a gem ...never understood any concept rather tried to remember to give answer in interview..kudos to you Sir
Got very much & best technical knowledge though I am into development for 2 Years. Techniques and way of presentation is superb.
Your Way Of Explaination is very Good .....useful Video...thank u
very good , thank you very much for this free class.
Best SQL video I have ever watched
Thank you sir for explaining in easy everyone will understand.
Thank you for such in depth defination it helps alot of people 🙏
Thank you. Very well explained
No words to say you are awesome your way of presentation is very excellent!!!!!!!!!!!!!!!!
You are an excellent teacher Sir. Thank you
Excellent in Content and Explanation !
Great Explanation, Thank you very much.
Thanku so much sir for amazing content. You way of explanation is best I must say.
Great video!! You are gifted to teach. Keep it up👍👍
Happy Teachers Day !! Shiv Sir.. Your Angular Interview Qns and Azure CI/CD are blessing.
Can you please share Azure CI/CD videos of Shiv sir?
@@tejap7308 +1, please share the link of Azure CI/CD video
Excellent content as always !! Thank you :)
awesome! thank you! and good luck to us reviewing for technical interviews xD
Amazing explanation sir. A big Thank You! Pleasemake more videos on queries for interview as a Data Scientist and Data Analyst profile specifically.
Nepal in example made me so connected. Thank you for such a great collection.
Excellent material, thank you.
Great tutorial! Thanks for the video! I wish you have also covered relationships in SQL. But either way, this is a gem
Detailed explanation sir... find it useful.. Thank you :)
Thank you so much, It's a gold video
I have never seen such great voice and great lecture thank you so much sir
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. 🙏
Yes!! Thank you for making this video. Very helpful to us
This is sooo informative. I thank you so much👍
Superb explanation,bestvideo
Love that motivation :) Evrything is fair in 'Getting Job' and War :)
This is great, thanks so much.
Waiting for the next parts. Thankyou so much for the amazing video.
thanks for the best explanations.
Awesome Preparation sir!!!
Excellent lecture. Thankyou for this :)
Thank you! Very helpful bro
It is really helpful for me, thanks
Happy teacher's day sir. Jai Hind
Tq this is like a revision for my interview on SQL basic part
Thank you, so much for the beautiful session
Thank you making videos like this, it is helping me alot. thank you
Super sir this video is very important for the interview question thank you sir
really thanks a lot, there is a lot of useful information and tip&tricks and you made them very simple 😁
Sir really excellent explain everything Also you motivated us in this video thankyou so much for your informative video.
Wow, you are really clear!
Loved your teaching methods!! Crisp and to the point ! Thankyou so very much sir❤❤❤
Thank you for this video.
Thank you for ur valuable time
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.
very helpful video, thank you ❤
Very nice video...Thumbs Up !!!
Great explanation 👍
ThankYou so much sir
Good source of knowledge.
Thanks a lot for the explaining so well sir
Well explained 🙏
Nice video. It's very satisfying to listening
Awesome and very much informative video
it is very helpfull video thank you so much for it.
GOOD REVISION ~
Hi sir, Can you please explain how non clustered index depends on clustered index?
This is so awesome 😎 kudos!
Good explanation sir thanks
Salute, Guruji!
If I crack interview with the help of ur questions I really Very Thankful to you...BTW nice information.
very nice brother; thanks
Many thanks 🙏
Amazing
so Helpfull
Good video. Thanks a lot.
Is CQRS a form of OLAP and OLTP and is there a link between these?
thank you sir this video was very helpful
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.
Very good explanation
Thank you so much sir for superb video
Nicely explained