MS SQL Server Tutorial for beginners

1. Create, Alter and Drop tables

2. Primary Key and Foreign Key

3. DEFAULT constraint

4. UNIQUE Key Constraint

5. CHECK Constraint

6. Identity column

7. @@IDENTITY, SCOPE_IDENTITY() and IDENT_CURRENT('tablename') functions

8. Basics of INSERT-UPDATE-DELETE-TRUNCATE

9. Select (T-SQL) operations

10. Operators and wild cards in SQL

11. All types of SQL Joins with example

12. SELF-JOIN in SQL

13. GROUP BY Clause

14. GROUPING SETS in SQL Server

15. ROLLUP operator in SQL Server

16. CUBE operator in SQL Server

17. GROUPING function in SQL

18. How to prevent inserting duplicate records into a table 

19. Difference between UNION and UNION ALL

20. IN Operator in SQL

21. EXISTS Operator in SQL

22. Stored Procedure in SQL

23. Temporary Stored Procedures in SQL

24. Stored procedure with OUTPUT parameter