SQL Server Tutorial for Beginners

If you can, let's support Kud Venkat to gift education to those who cannot afford
https://www.pragimtech.com/support-us/

The image version of the slides are free. The images may appear blurred, but if you click on one of the images they get enlarged and will be crystal clear. You can then use left and right arrows on the keyboard to navigate from one slide to another. Use Google chrome browser for best experience.

If you want to download all the PPTs, you can order them from the following link.
https://www.pragimtech.com/downloadcourses/download-all-slides/

Click here to watch the complete SQL course on YouTube

Subscribe to receive an email, when new videos are uploaded

Download and Install SQL Server 2019 Developer Edition from the following link.
https://www.microsoft.com/en-us/sql-server/sql-server-downloads

Download and Install (SQL Server Management Studio) SSMS from the following link
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?redirectedfrom=MSDN&view=sql-server-ver15

How to install SQL Server & SQL Server Management Studio (SSMS)

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

SQL Server Performance Tuning and Query Optimization

1. Text | How is data stored in SQL database
2. Text | How do SQL Indexes Work
3. Text | What is heap table