1. Full .NET Interview Course (with PDF Book)
C# / ASP.NET Core / MVC / API - Top 500 Interview Questions
Coupon code DOTNETOFFERJUN2024 applied in below URL- 80% Off - Limited Time Offer
www.udemy.com/course/csharp-o...
Don't worry if course not helping you, Udemy has 30 days Free Refund Policy.
2. Quick Revision Book (PDF format)
Top 500 .NET Interview Questions - OOPS/ C#/ ASP .NET/ MVC/ SQL /.NET Core /Web API
imojo.in/interviewhappy
50% Off - Limited Time Offer Applied on above link.
Don't worry if book not helping you, I will return 100% of your money with in 7 days of purchase. Just mail me at anuragrawat123@gmail.com.
My best wishes are with you.
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?
Негізгі бет Top 25 SQL Server Interview Questions - .NET C#
Пікірлер: 93