Sign in  |  Register
Advanced search
Publication Cover

CITATION

Petkovic, Dusan. Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition. New York: McGraw-Hill Education, 2020.

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

Authors: Dusan Petkovic

Published:  January 2020 Pages: 896

eISBN: 9781260458886 | ISBN: 9781260458879
Open eBook
  • 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
  • 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