SQL Server Interview Questions and Answers

SQL Server Interview Questions with Answers

Created by: Shivprasad Koirala
We love recording Step by Step tutorials

What Will I Learn?

• How to answer basic SQL Server interview questions around Normalization,De-normalization,First/Second/Third Normal forms,OLTP and OLAP.
• Comparison SQL Server interview questions around Primary key vs Unique key,Char vs Nchar,Char vs Varchar,Clustered vs Non-clustered,Insteadof vs After triggers
• SQL Query writing questions around Inner joins,Left joins,Right joins,Outer joins , Cross joins ,Union vs Union All,Subqueries & Co-related Queries
• Tricky Questions around Join vs Subquery,Group by,Having vs Where,Identity columns,Transactions, Aggregate functions, Sorting and Distinct keyword
• Extensive explanation of tricky questions like Select top nth Salary,joins vs Subquery,Self joins,Nulls,Wild cards,Alias & Top keyword
• One complete chapter dedicates to CTE(Common table expression) which covers definitions,recursive CTE,CTE scenarios,Temp tables vs CTE and CTE performance

Requirements

• Basic SQL Server knowledge

Target audience

• Developers who are looking to crack SQL Server interviews