Index SQL Server Video Tutorial Slides

SQL Server Video Tutorial Slides

1. Introduction to SQL Server
2. Creating Altering and Dropping Database
3. Create Table and Insert Update Data into Table
4. Primary Key and Foreign Key
5. Select Statement in SQL
6. Relational Database Design Tips
7. Identity Column in SQL
8. Retrieve Last Identity Value in SQL
9. Default Constraint in SQL
10. Unique Constraint in SQL
11. Check Constraint in SQL
12. Cascading Referential Integrity in SQL
13. Union and Union All
14. Alias, Aggregate, Group by and Having in SQL
15. Joins
16. Self Join
17. Stored Procedures
18. Stored Procedures with Output Parameter and Return Values
19. Practical Use of Stored Procedures
20. Stored Procedure Optional Parameter
21. Indexes
22. Clustered Non Clustered and Unique Index
23. Paging in SQL
24. View
25. Transaction
26. DML After Trigger
27. DML After Update Trigger
28. Round, Floor, Rand, Ceiling and Rand Functions
29. Cursors
30. DDL Triggers
31. Server Scope Trigger Example
32. CTE in SQL
33. Replace Null Values, Coalesce Function
34. Date Time Datatype