Book

SQL Server 2017 Developer's Guide

This book is your guide to exploring the various developer capabilities offered by SQL Server 2017. Model your data and the complex relationships within it, and integrate SQL Server with R and Python for efficient analytics. The book also covers the performance and troubleshooting aspects to help you develop efficient database applications.

Offered byPackt Logo

Difficulty Level

Intermediate

Completion Time

27h12m

Language

English

About Book

Who Is This Book For?

Database developers and solution architects looking to design efficient database applications using SQL Server 2017 will find this book very useful. In addition, this book will be valuable to advanced analysis practitioners and business intelligence developers. Database consultants dealing with performance tuning will get a lot of useful information from this book as well. Some basic understanding of database concepts and T-SQL is required to get the best out of this book.

Book content

chapters 27h12m total length

Introduction to SQL Server 2017

Review of SQL Server Features for Developers

SQL Server Tools

Transact-SQL and Database Engine Enhancements

JSON Support in SQL Server

Stretch Database

Temporal Tables

Tightening the Security

Query Store

Columnstore Indexes

Introducing SQL Server In-Memory OLTP

In-Memory OLTP Improvements in SQL Server 2017

Supporting R in SQL Server

Data Exploration and Predictive Modeling with R in SQL Server

Introducing Python for SQl Server

Graph Databases

SQL Server on Linux / In Containers

Related Resources

Access Ready-to-Use Books for Free!

Get instant access to a library of pre-built books—free trial, no credit card required. Start training your team in minutes!

No credit card required