MS SQL Server
I. Foundations
1. Introduction to Databases
2. SQL vs NoSQL Databases
3. What is MS SQL Server
4. SQL Server Editions & Use Cases
5. Installing SQL Server & SSMS
6. SQL Server Architecture
7. Databases & File Structure
8. Tables, Rows & Columns
9. SQL Server Data Types
10. Creating Databases & Tables
II. Core SQL & Data Ops
11. Constraints & Keys
12. Identity Columns
13. INSERT Data
14. SELECT Queries
15. WHERE & Filtering
16. ORDER BY, OFFSET & FETCH
17. UPDATE Data
18. DELETE Data
19. Aggregate Functions
20. GROUP BY
21. HAVING Clause
22. NULL Handling
III. Joins & Performance
23. Table Relationships
24. INNER JOIN
25. LEFT, RIGHT & FULL JOIN
26. Subqueries
27. Views
28. Indexes
29. Transactions & ACID
30. Locks & Concurrency
31. Query Optimization
32. Execution Plans
IV. Enterprise & Admin