English | 2020 | ISBN: ‎ 1260458873 , 978-1260458879 | 865 pages | True PDF | 35.77 MB

Start working with Microsoft SQL Server 2019 in no with help from this thoroughly revised, practical resource.

Filled with real-world examples and hands-on exercises,
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.

[list]

 Install, configure, and customize Microsoft SQL Server 2019

 Create and modify database objects with Transact-SQL statements

 Write stored procedures and user-defined functions

 Handle backup and recovery, and automate administrative tasks

 Tune your database system for optimal availability and reliability

 Secure your system using authentication, encryption, and authorization

 Work with SQL Server Analysis Services, Reporting Services, and other BI tools

 Gain knowledge of relational storage, presentation, and retrieval of data stored in the JSON format

 Manage graphs using SQL Server Graph Databases

 Learn about machine learning support for R and Python





DOWNLOAD
uploadgig.com