Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition

Dusan Petkovic

ISBN 10: 1260458873 / ISBN 13: 9781260458879

Published by McGraw-Hill Education, US, 2020

About this Item

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. 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.

Seller Inventory # LU-9781260458879

Bibliographic Details

• Title: Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition
• Publisher: McGraw-Hill Education, US
• Publication Date: 2020
• Language: English
• ISBN 10: 1260458873
• ISBN 13: 9781260458879
• Binding: Paperback
• Condition: New
• Weight: 1460 grams

About this title

Synopsis

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 Easily

Start 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.

• 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

About the Author

Dusan Petkovic is a professor in the computer science department at the Polytechnic in Rosenheim, Germany. He is the best-selling author of 5 editions of SQL Server: A Beginner’s Guide and has authored numerous articles for SQL Server Magazine and technical papers for Embarcadero.