Part I: Basic Concepts
1. Relational Database Systems: An Introduction
2. Installation of SQL Server
3. SQL Server Management Studio
Part II: Transact-SQL Language
4. SQL Components
5. Data Definition Language
6. Queries
7. Modification of a Table's Contents
8. Stored Procedures
9. System Catalog
10. Indices
11. Views
12. SQL Server Security
13. Triggers
14. Concurrency Control
Part III: System Administration
15. System Environment of the Database Engine
16. Backup, Recovery and System Availability
17. Automating System Administration
18. Data Replication
19. Query Optimizer
20. Performance Tuning
21. In-Memory OLTP
Part IV: SQL Server and Business Intelligence
22. Business Intelligence (BI): An Introduction
23. SQL Server Analysis Services
24. BI and Transact-SQL
25. SQL Server Reporting Services
26. Optimizing Techniques for ROLAP Technique
Part V: Beyond Relational Data
27. XML and JSON Support
28. Spatial and Temporal Data
29. SQL Server Full-Text Search
Instructor's Manual