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
What is included with this book?
The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.
Please wait while the item is added to your bag...