فهرست مطالب

• Cover
• Title Page
• Copyright Page
• About the Author
• Contents at a Glance
• Contents
• Introduction
• Part I. Basic Concepts and Installation
• Chapter 1. Relational Database Systems: An Introduction
• Chapter 2. Planning the Installation and Installing SQL Server
• Chapter 3. Front-End Tools for the Database Engine
• Part II. Transact-SQL Language
• Chapter 4. SQL Components
• Chapter 5. Data Definition Language
• Chapter 6. Queries
• Chapter 7. Modification of a Table’s Contents
• Chapter 8. Stored Procedures and User-Defined Functions
• Chapter 9. System Catalog
• Chapter 10. Indices
• Chapter 11. Views
• Chapter 12. Security System of the Database Engine
• Chapter 13. Concurrency Control
• Chapter 14. Triggers
• Part III. SQL Server: System Administration
• Chapter 15. System Environment of the Database Engine
• Chapter 16. Backup, Recovery, and System Availability
• Chapter 17. Automating System Administration Tasks
• Chapter 18. Data Replication
• Chapter 19. Query Optimizer
• Chapter 20. Performance Tuning
• Chapter 21. In-Memory OLTP
• Part IV. SQL Server and Business Intelligence
• Chapter 22. Business Intelligence: An Introduction
• Chapter 23. SQL Server Analysis Services
• Chapter 24. Business Intelligence and Transact-SQL
• Chapter 25. SQL Server Reporting Services
• Chapter 26. Optimizing Techniques for Data Warehousing
• Chapter 27. Columnstore Indices
• Chapter 28. Intelligent Query Processing
• Part V. Beyond Relational Data
• Chapter 29. JSON Integration in the Database Engine
• Chapter 30. Spatial and Temporal Data
• Chapter 31. SQL Server Graph Databases
• Part VI. Machine Learning
• Chapter 32. SQL Server Machine Learning Services: R Support
• Chapter 33. SQL Server Machine Learning Services: Python Support
• Appendix. Exercise Solutions
• Index