SQL Server & SQL Server Interview Questions & Answers

Download SQL Server Videos & Slides (Price – $50)

What does the download contain

• • SQL Server Interview Questions & Answers(16 Videos & Slides – 2 Hours 1 Minute)
    1. How to find nth highest salary in sql | Text | Slides
    2. SQL query to get organization hierarchy | Text | Slides
    3. How does a recursive CTE work | Text | Slides
    4. Delete duplicate rows in SQL | Text | Slides
    5. SQL query to find employees hired in last n months | Text | Slides
    6. Transform rows into columns in sql server | Text | Slides
    7. SQL query to find rows that contain only numerical data | Text | Slides
    8. SQL Query to find department with highest number of employees | Text | Slides
    9. Difference between inner join and left join | Text | Slides
    10. Join 3 tables in sql server | Text | Slides
    11. Real time example for right join | Text | Slides
    12. Can we join two tables without primary foreign key relation | Text | Slides
    13. Difference between blocking and deadlocking | Text | Slides
    14. Sql query to select all names that start with a given letter without like operator | Text | Slides
    15. SQL script to insert into many to many table | Text | Slides
    16. Sql date interview questions | Text | Slides

• SQL Server (149 Videos & Slides – 26 Hours 57 Minutes)
  1. Connecting to SQL Server | Text | Slides
  2. Working with databases | Text | Slides
  3. Creating and working with tables | Text | Slides
  4. Default Constraint | Text | Slides
  5. Cascading referential integrity | Text | Slides
  6. Check Constraint | Text | Slides
  7. Identity Column | Text | Slides
  8. Retrieving identity column value | Text | Slides
  9. Unique key constraint | Text | Slides
  10. All about select statement | Text | Slides
  11. Group By | Text | Slides
  12. Basic Joins | Text | Slides
  13. Advanced Joins | Text | Slides
  14. Self join | Text | Slides
  15. Different ways to replace NULL | Text | Slides
  16. Coalesce function | Text | Slides
  17. Union and Union All | Text | Slides
  18. Stored Procedures | Text | Slides
  19. Stored Procedures with output parameters | Text | Slides
  20. Difference between output parameters and return values | Text | Slides
  21. Advantages of stored procedures | Text | Slides
  22. Built in string functions | Text | Slides
  23. Left, Reight, Charindex and Substring functions | Text | Slides
  24. Replicate, Space, Patindex, Replace and Stuff functions | Text | Slides
  25. DateTime functions | Text | Slides
  26. IsDate, Day, Month, Year and DateName functions | Text | Slides
  27. DatePart, DateAdd and DateDiff functions | Text | Slides
  28. Convert and Cast functions | Text | Slides
  29. Mathematical functions | Text | Slides
  30. Scalar User Defined functions | Text | Slides
  31. Inline Table Valued functions | Text | Slides
  32. Multi-Statement Table Valued functions | Text | Slides
  33. Important concepts related to functions in sql server | Text | Slides
  34. Temporary tables | Text | Slides
  35. Indexes | Text | Slides
  36. Clustered and NonClustered Indexes | Text | Slides
  37. Unique and Non-Unique Indexes | Text | Slides
  38. Advantages and disadvantages of indexes | Text | Slides
  39. Views | Text | Slides
  40. Updateable Views | Text | Slides
  41. Indexed Views | Text | Slides
  42. View Limitations | Text | Slides
  43. DML Triggers | Text | Slides
  44. DML After Update Trigger | Text | Slides
  45. Instead of insert trigger | Text | Slides
  46. Instead of update trigger | Text | Slides
  47. Instead of delete trigger | Text | Slides
  48. Derived table and CTE’s | Text | Slides
  49. Common Table Expressions | Text | Slides
  50. Updatable CTE | Text | Slides
  51. Recursive CTE | Text | Slides
  52. Normalization & First Normal Form | Text | Slides
  53. 2NF and 3NF | Text | Slides
  54. Pivot Operator | Text | Slides
  55. Error handling in SQL Server 2000 | Text | Slides
  56. Error handling in SQL Server 2005 and later versions | Text | Slides
  57. Transactions in SQL Server | Text | Slides
  58. Transaction ACID Tests | Text | Slides
  59. Subqueries in sql | Text | Slides
  60. Correlated subquery | Text | Slides
  61. Creating a large table with random data for performance testing | Text | Slides
  62. What to choose for performance – SubQuery or Joins | Text | Slides
  63. Cursors in sql server | Text | Slides
  64. Replacing cursors using joins | Text | Slides
  65. List all tables in a sql server database using a query | Text | Slides
  66. Writing re-runnable sql server scripts | Text | Slides
  67. Alter database table columns without dropping table | Text | Slides
  68. Optional parameters in sql server stored procedures | Text | Slides
  69. Merge in SQL Server | Text | Slides
  70. SQL Server concurrent transactions | Text | Slides
  71. SQL Server dirty read example | Text | Slides
  72. SQL Server lost update problem | Text | Slides
  73. Non repeatable read example in sql server | Text | Slides
  74. Phantom reads example in sql server | Text | Slides
  75. Snapshot isolation level in sql server | Text | Slides
  76. Read committed snapshot isolation level in sql server | Text | Slides
  77. Difference between snapshot isolation and read committed snapshot | Text | Slides
  78. SQL Server deadlock example | Text | Slides
  79. SQL Server deadlock victim selection | Text | Slides
  80. Logging deadlocks in sql server | Text | Slides
  81. SQL Server deadlock analysis and prevention | Text | Slides
  82. Capturing deadlocks in sql profiler | Text | Slides
  83. SQL Server deadlock error handling | Text | Slides
  84. Handling deadlocks in ado.net | Text | Slides
  85. Retry logic for deadlock exceptions | Text | Slides
  86. How to find blocking queries in sql server | Text | Slides
  87. SQL Server except operator | Text | Slides
  88. Difference between except and not in sql server | Text | Slides
  89. Intersect operator in sql server | Text | Slides
  90. Difference between union intersect and except in sql server | Text | Slides
  91. Cross apply and outer apply in sql server | Text | Slides
  92. DDL Triggers in sql server | Text | Slides
  93. Server-scoped ddl triggers | Text | Slides
  94. SQL Server trigger execution order | Text | Slides
  95. Audit table changes in sql server | Text | Slides
  96. Logon triggers in sql server | Text | Slides
  97. Select into in sql server | Text | Slides
  98. Difference between where and having in sql server | Text | Slides
  99. Table valued parameters in SQL Server | Text | Slides
  100. Send datatable as parameter to stored procedure | Text | Slides
  101. Grouping Sets in SQL Server | Text | Slides
  102. Rollup in SQL Server | Text | Slides
  103. Cube in SQL Server | Text | Slides
  104. Difference between cube and rollup in SQL Server | Text | Slides
  105. Grouping function in SQL Server | Text | Slides
  106. GROUPING_ID function in SQL Server | Text | Slides
  107. Debugging sql server stored procedures | Text | Slides
  108. Over clause in SQL Server | Text | Slides
  109. Row_Number function in SQL Server | Text | Slides
  110. Rank and Dense_Rank in SQL Server | Text | Slides
  111. Difference between rank dense_rank and row_number in SQL | Text | Slides
  112. Calculate running total in SQL Server 2012 | Text | Slides
  113. NTILE function in SQL Server | Text | Slides
  114. Lead and Lag functions in SQL Server 2012 | Text | Slides
  115. FIRST_VALUE function in SQL Server | Text | Slides
  116. Window functions in SQL Server | Text | Slides
  117. Difference between rows and range | Text | Slides
  118. LAST_VALUE function in SQL Server | Text | Slides
  119. UNPIVOT in SQL Server | Text | Slides
  120. Reverse PIVOT table in SQL Server | Text | Slides
  121. Choose function in SQL Server | Text | Slides
  122. IIF function in SQL Server | Text | Slides
  123. TRY_PARSE function in SQL Server 2012 | Text | Slides
  124. TRY_CONVERT function in SQL Server 2012 | Text | Slides
  125. EOMONTH function in SQL Server 2012 | Text | Slides
  126. DATEFROMPARTS function | Text | Slides
  127. Difference between DateTime and SmallDateTime in SQL Server | Text | Slides
  128. DateTime2FromParts function in SQL Server 2012 | Text | Slides
  129. Difference between DateTime and DateTime2 in SQL Server | Text | Slides
  130. Offset fetch next in SQL Server 2012 | Text | Slides
  131. Identifying object dependencies in SQL Server | Text | Slides
  132. sys.dm_sql_referencing_entities in SQL Server | Text | Slides
  133. sp_depends in SQL Server | Text | Slides
  134. Sequence object in SQL Server 2012 | Text | Slides
  135. Difference between sequence and identity in SQL Server | Text | Slides
  136. Guid in SQL Server | Text | Slides
  137. How to check GUID is null or empty in SQL Server | Text | Slides
  138. Dynamic SQL in SQL Server | Text | Slides
  139. Implement search web page using ASP.NET and Stored Procedure | Text | Slides
  140. Implement search web page using ASP.NET and Dynamic SQL | Text | Slides
  141. Prevent sql injection with dynamic sql | Text | Slides
  142. Dynamic SQL in Stored Procedure | Text | Slides
  143. Sql server query plan cache | Text | Slides
  144. exec vs sp_executesql in sql server | Text | Slides
  145. Dynamic sql table name variable | Text | Slides
  146. Quotename function in SQL Server | Text | Slides
  147. Dynamic SQL vs Stored Procedure | Text | Slides
  148. Dynamic sql output parameter | Text | Slides
  149. Temp tables in dynamic sql | Text | Slides