SQL

Free SQL Tutorial


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


No comments :

Post a Comment

Subscribe to: Posts ( Atom )