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

  • 14h 26m
  • Dušan Petković
  • Oracle Press
  • 2020

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.

In this Book

  • Introduction
  • Relational Database Systems—An Introduction
  • Planning the Installation and Installing SQL Server
  • Front-End Tools for the Database Engine
  • SQL Components
  • Data Definition Language
  • Queries
  • Modification of a Table's Contents
  • Stored Procedures and User-Defined Functions
  • System Catalog
  • Indices
  • Views
  • Security System of the Database Engine
  • Concurrency Control
  • Triggers
  • System Environment of the Database Engine
  • Backup, Recovery, and System Availability
  • Automating System Administration Tasks
  • Data Replication
  • Query Optimizer
  • Performance Tuning
  • In-Memory OLTP
  • Business Intelligence—An Introduction
  • SQL Server Analysis Services
  • Business Intelligence and Transact-SQL
  • SQL Server Reporting Services
  • Optimizing Techniques for Data Warehousing
  • Columnstore Indices
  • Intelligent Query Processing
  • JSON Integration in the Database Engine
  • Spatial and Temporal Data
  • SQL Server Graph Databases
  • SQL Server Machine Learning Services—R Support
  • SQL Server Machine Learning Services—Python Support
SHOW MORE
FREE ACCESS