microsoft sql server pdf book notes free download

About Book

This book has 200+ pages that cover the basic to advanced topic of Microsoft SQL with practical program and code examples and developed by www.goalkicker.com. if you want to learn Microsoft SQL then this book is for you. this book is developed by professional programmers for educational purposes.



Book contents

  1. Getting started with Microsoft SQL server
  2. data types
  3. converting data types
  4. user-defined table types
  5. SELECT statement
  6. alias names in SQL server
  7. NULLs
  8. variables
  9. dates
  10. generating a range of dates
  11. database snapshots
  12. COALESCE
  13. if-else
  14. case statement
  15. insert into
  16. merge
  17. create view
  18. views
  19. union
  20. try-catch
  21. while loop
  22. over clause
  23. group by
  24. order by
  25. the stuff function
  26. JSON in SQL server
  27. open JSON
  28. for JSON
  29. queries with JSON data
  30. storing JSON in SQL tables
  31. modify JSON text
  32. for XML path
  33. join
  34. cross apply
  35. computed columns
  36. common table expressions
  37. move and copy data around tables
  38. limit result set
  39. retrieve information about your instance
  40. with ties option
  41. string functions
  42. logical functions
  43. aggregate functions
  44. string aggreated functions in SQL server
  45. ranking functions
  46. window functions
  47. PIVOT UNPIVOT
  48. dynamic SQL pivot
  49. partitioning
  50. stored procedures
  51. retrieve information about the database
  52. split string function in SQL server
  53. insert
  54. primary keys
  55. foreign keys
  56. last inserted identity
  57. scope identity
  58. sequences
  59. inde
  60. full tet indexing
  61. trigger
  62. cursors
  63. transaction isolation levels
  64. advanced options
  65. migration
  66. table-valued parameters
  67. DBMAIL
  68. in-memory OLTP
  69. temporal tables
  70. use of temp table
  71. scheduled task or jo
  72. isolation levels and locking
  73. sorting ordering rows
  74. privileges or permissions
  75. SQLCMD
  76. resource governor
  77. file-group
  78. basic DDL operations in MS SQL server
  79. subqueries
  80. pagination
  81. clustered column store
  82. parse name
  83. installing SQL server on windows
  84. analyzing a query
  85. query hints
  86. query store
  87. querying results by page
  88. schemas
  89. backup and restore the database
  90. transaction handling
  91. natively compiled modules
  92. spatial data
  93. dynamic SQL
  94. dynamic data asking
  95. export data in txt file by using sqlcmd
  96. common language runtime integration
  97. delimiting special characters and reserved words
  98. dbcc
  99. bulk import
  100. service broker
  101. permission and security
  102. database permission
  103. row-level security
  104. encryption
  105. phantom read
  106. ilestream
  107. BCP utility
  108. SQL server evolution through different versions
  109. SQL server management studio
  110. managing azure SQL database
  111. system database
  112. Microsoft SQL server management studio shortcut keys