Contents at a Glance

Part I      Basic Concepts and Installation

1       Relational Database Systems: An Introduction

2       Planning the Installation and Installing SQL Server

3       Front-End Tools for the Database Engine

Part II     Transact-SQL Language

4      SQL Components

5      Data Definition Language

6      Queries

7      Modification of a Table’s Contents

8      Stored Procedures and User-Defined Functions

9      System Catalog

10      Indices

11      Views

12      Security System of the Database Engine

13      Concurrency Control

14      Triggers

Part III   SQL Server: System Administration

15      System Environment of the Database Engine

16      Backup, Recovery, and System Availability

17      Automating System Administration Tasks

18      Data Replication

19      Query Optimizer

20      Performance Tuning

21      In-Memory OLTP

Part IV    SQL Server and Business Intelligence

22      Business Intelligence: An Introduction

23      SQL Server Analysis Services

24      Business Intelligence and Transact-SQL

25      SQL Server Reporting Services

26      Optimizing Techniques for Data Warehousing

27      Columnstore Indices

28      Intelligent Query Processing

Part V      Beyond Relational Data

29      JSON Integration in the Database Engine

30      Spatial and Temporal Data

31      SQL Server Graph Databases

Part VI    Machine Learning

32      SQL Server Machine Learning Services: R Support

33      SQL Server Machine Learning Services: Python Support

Appendix Exercise Solutions

Index

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.144.17.91