Petkovic Dusan. Microsoft SQL Server 2019: A Beginner's Guide

7th ed. — McGraw-Hill, 2020. — 864 p. — ISBN: 1260458873.Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Get Up to Speed on Microsoft SQL Server 2019 Quickly and EasilyStart working with Microsoft SQL Server 2019 in no time with help from this thoroughly revised, practical resource. Filled with real-world examples and hands-on exercises, Microsoft SQL Server 2019: A Beginner’s Guide, Seventh Edition starts by explaining fundamental relational database system concepts. From there, you’ll learn how to write Transact-SQL statements, execute simple and complex database queries, handle system administration and security, and use powerful analysis and reporting tools. New topics such as SQL and JSON support, graph databases, and support for machine learning with R and Python are also covered in this step-by-step tutorial.Basic Concepts and Installation
Relational Database Systems: An Introduction
Planning the Installation and Installing SQL Server
Front-End Tools for the Database EngineTransact-SQL Language
SQL Components
Data Definition Language
Queries
Modification of a Table’s Contents
Stored Procedures and User-Defined Functions
System Catalog
Indices
Views
Security System of the Database Engine
Concurrency Control
TriggersSQL Server: System Administration
System Environment of the Database Engine
Backup, Recovery, and System Availability
Automating System Administration Tasks
Data Replication
Query Optimizer
Performance Tuning
In-Memory OLTPSQL Server and Business Intelligence
Business Intelligence: An Introduction
SQL Server Analysis Services
Business Intelligence and Transact-SQL
SQL Server Reporting Services
Optimizing Techniques for Data Warehousing
Columnstore Indices
Intelligent Query ProcessingBeyond Relational Data
JSON Integration in the Database Engine
Spatial and Temporal Data
SQL Server Graph DatabasesMachine Learning
SQL Server Machine Learning Services: R Support
SQL Server Machine Learning Services: Python Support