Microsoft SQL Server for beginners
Zeedup SQL Course
1. Introduction
2. Different RDBMS Tools
3. Installation of MS SQL Server
4. Basic Concepts – What is a Table, DB, Rows, Columns, Keys, etc.
5. Create Database objects
6. Data Types in SQL
7. Create Table in SQL
8. Alter, Drop and Truncate Tables and Databases
9. Operators in SQL
10. Insert and Select Queries in SQL
11. Where Clause in SQL
12. Like Clause in SQL
13. Alter Statements in SQL
14. Update Statements in SQL
15. Constraints in SQL
16. Creating a Foreign Key in SQL
17. Dropping Constraints and Check Constraints
18. Alias, Top, Top Percent, Min, Max
19. Count, Sum, Average, Second Max, Max
20. Having, Exists and Any Operator
21. Select Into, Insert Into and Case Statements
22. Is Null statement and Backup Database
23. Views in SQL
24. Functions in SQL
25. Stored Procedures in SQL
26. Triggers in SQL
27. After and Instead of Triggers in SQL
28. Normalization in DB Part 01
29. Normalization in DB Part 02
30. Joins in SQL
www.zeedup.com
@MicrosoftSQLServer