SQL Notes for Professionals

Chapters

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. OPENJSON
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 Aggregate 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. Index
60. Full-Text Indexing
61. Trigger
62. Cursors
63. Transaction isolation levels
64. Advanced options
65. Migration
66. Table Valued Parameters
67. DBMAIL
68. In-Memory OLTP (Hekaton)
69. Temporal Tables
70. Use of TEMP Table
71. Scheduled Task or Job
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 COLUMNSTORE
82. Parsename
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 Database
90. Transaction handling
91. Natively compiled modules (Hekaton)
92. Spatial Data
93. Dynamic SQL
94. Dynamic data masking
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. Permissions and Security
102. Database permissions
103. Row-level security
104. Encryption
105. PHANTOM read
106. Filestream
107. bcp (bulk copy program) Utility
108. SQL Server Evolution through different versions (2000 – 2016)
109. SQL Server Management Studio (SSMS)
110. Managing Azure SQL Database
111. System database – TempDb
112. Microsoft SQL Server Management Studio Shortcut Keys