Synopses & Reviews
Synopsis
Up-to-date Microsoft SQL Server 2019 skills made easy
Get up and running on Microsoft SQL Server 2019 in no time with help from this thoroughly revised, practical resource. The book offers thorough coverage of SQL management and development and features full details on the newest machine learning, BI, reporting, and security features.
Filled with new 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 will learn how to write Transact-SQL statements; execute simple and complex database queries; handle management, backup, and security; and use the powerful analysis and BI tools. XML, spatial data, and full-text search are also covered in this complete and rigorous introductory guide.
- Revised from the ground up to cover the latest version of SQL Server
- Designed for new users as well as experienced users who are migrating to SQL Server 2019
- Written by a prominent professor and best-selling author
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(R) SQL Server(R) 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