Top 25 SQL Server Interview Questions

Full .NET Interview Course (500 Interview Questions)

Topics Covered (with PDF Book) :
OOPS-C# / .Net Framework / ASP.NET MVC / EF /
ADO.NET / SQL / SOLID / Design Patterns / .Net Core / Web API

https://www.udemy.com/course/csharp-oops-mvc-asp-dotnet-core-webapi-sql-questions-mock-interviews/?referralCode=6922C9482CFE5A11B863

This video contains the top 25 interview questions asked from SQL Server topic:
00:00 – Introduction
00.56 – Q1. What is the difference between DBMS and RDBMS?
02:23 – Q2. What is a Constraint is SQL? What are its types.
06:45 – Q3. What is the difference between Primary key and Unique key?
08:36 – Q4. What are Triggers and types of triggers?
13:34 – Q5. What is a View?
16:58 – Q6. What is the difference between Having clause and Where clause?
18:23 – Q7. What is Sub query or Nested query or Inner query in SQL?
19:27 – Q8. What is Auto Increment/ Identity column in SQL Server?
21:12 – Q9. What are Joins in SQL?
21:49 – Q10. What are the types of Joins in SQL Server?
24:23 – Q11. What is Self-Join?
27:06 – Q12. Write a SQL query to fetch all the Employees who are also Managers.
30:22 – Q13. What are Indexes in SQL Server?
31:18 – Q14. What is Clustered index?
33:10 – Q15. What is Non-Clustered index?
34:53 – Q16. What is the difference between Clustered and Non-Clustered index?
36:49 – Q17. How to create Clustered and Non-Clustered index in a table?
38:00 – Q18. In which column you will apply the indexing to optimize this query. “select id, class from student where name=”happy””?
39:47 – Q19. What is the difference between Stored Procedure and Functions (at least 3)?
43:30 – Q20. How to optimize a Stored Procedure or SQL Query?
47:12 – Q21. What is a Cursor? Why to avoid them?
49:40 – Q22. What is the difference between scope_identity and @@identity?
51:46 – Q23. What is CTE in SQL Server?
53:41 – Q24. What is the difference between Delete, Truncate and Drop commands?
57:36 – Q25. How to get the Nth highest salary of an employee?
01:00:49 – (Bonus Question) What are ACID properties?
01:03:07 – (Bonus Question) What are Magic Tables in SQL Server?