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

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

Book Description
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

Content

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

Download Microsoft SQL Server 2019: A Beginner's Guide, 7th Edition PDF or ePUB format free


Free sample


Download in .ePUB format


Add comments
Прокомментировать
Введите код с картинки:*
Кликните на изображение чтобы обновить код, если он неразборчив
Copyright © 2019