Home > Categories > Programming > Microsoft SQL Server 2019 A Beginner's Guide
Microsoft SQL Server 2019 A Beginner's Guide
📥 Download PDF

Microsoft SQL Server 2019 A Beginner's Guide

by Dusan Petkovic

Programming

Book Details

Book Title

Microsoft SQL Server 2019 A Beginner's Guide

Author

Dusan Petkovic

Publisher

McGraw-Hill Education

Publication Date

2020

ISBN

9781260458879

Number of Pages

865

Language

English

Format

PDF

File Size

6.22MB

Subject

Databases

Table of Contents

  • Cover
  • Title Page
  • Copyright Page
  • About the Author
  • Contents at a Glance
  • Contents
  • Introduction
  • Part I. Basic Concepts and Installation
  • Chapter 1. Relational Database Systems: An Introduction
  • Chapter 2. Planning the Installation and Installing SQL Server
  • Chapter 3. Front-End Tools for the Database Engine
  • Part II. Transact-SQL Language
  • Chapter 4. SQL Components
  • Chapter 5. Data Definition Language
  • Chapter 6. Queries
  • Chapter 7. Modification of a Table’s Contents
  • Chapter 8. Stored Procedures and User-Defined Functions
  • Chapter 9. System Catalog
  • Chapter 10. Indices
  • Chapter 11. Views
  • Chapter 12. Security System of the Database Engine
  • Chapter 13. Concurrency Control
  • Chapter 14. Triggers
  • Part III. SQL Server: System Administration
  • Chapter 15. System Environment of the Database Engine
  • Chapter 16. Backup, Recovery, and System Availability
  • Chapter 17. Automating System Administration Tasks
  • Chapter 18. Data Replication
  • Chapter 19. Query Optimizer
  • Chapter 20. Performance Tuning
  • Chapter 21. In-Memory OLTP
  • Part IV. SQL Server and Business Intelligence
  • Chapter 22. Business Intelligence: An Introduction
  • Chapter 23. SQL Server Analysis Services
  • Chapter 24. Business Intelligence and Transact-SQL
  • Chapter 25. SQL Server Reporting Services
  • Chapter 26. Optimizing Techniques for Data Warehousing
  • Chapter 27. Columnstore Indices
  • Chapter 28. Intelligent Query Processing
  • Part V. Beyond Relational Data
  • Chapter 29. JSON Integration in the Database Engine
  • Chapter 30. Spatial and Temporal Data
  • Chapter 31. SQL Server Graph Databases
  • Part VI. Machine Learning
  • Chapter 32. SQL Server Machine Learning Services: R Support
  • Chapter 33. SQL Server Machine Learning Services: Python Support
  • Appendix. Exercise Solutions
  • Index