MS SQL Server Course Index – Dataplexa

MS SQL Server Course Index

Complete MS SQL Server learning roadmap — 40 structured lessons covering SQL fundamentals, querying, performance tuning, security, and enterprise database management.

Open MS SQL Course Back to Learning Hub

I. Foundations Level (10 Lessons)

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 Operations (12 Lessons)

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. Relationships, Joins & Performance (10 Lessons)

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 & Administration (8 Lessons)

33. Stored Procedures 34. User-Defined Functions 35. Triggers 36. SQL Server Security & Roles 37. Backup & Restore 38. SQL Server Monitoring 39. SQL Server in Cloud (Azure SQL) 40. Mini Project