Table of Contents

PART 1: Basic Concepts
Chapter 1: Relational Database Systems: An Introduction
Chapter 2: Installation of SQL Server
Chapter 3: Front-end Systems of SQL Server

PART 2: 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 3: System Administration
Chapter 15: System Environment of the Database Engine
Chapter 16: Backup, Recovery and System Availability
Chapter 17: Automating System Administration
Chapter 18: Data Replication
Chapter 19: Query Optimizer
Chapter 20: Performance Tuning
Chapter 21: In-Memory OLTP

PART 4: 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 ROLAP
Chapter 27: Columnstore Indices
Chapter 28: Intelligent Query Processing

PART 5: Beyond Relational Data
Chapter 29: SQL/JSON Support
Chapter 30: Spatial and Temporal Data
Chapter 31: Graph Databases

PART 6: Machine Learning
Chapter 31: Support for R
Chapter 32: Support for the Python Language

About the Author

Dusan Petkovic (Germany) is a professor in the Department of Computer Science at the Polytechnic in Rosenheim, Germany. He frequently contributes to SQL Server Magazine and has published 8 other computer books in Germany for Addison Wesley and McGraw-Hill.