Book

SQL Server 2016 Developer's Guide

This book is designed to get you up to speed with SQL Server 2016, covering the essential concepts and techniques. By the end of this book, you’ll be able to design efficient, high-performance database applications confidently.

Offered byPackt Logo

Difficulty Level

Intermediate

Completion Time

20h32m

Language

English

About Book

Who Is This Book For?

This book is for database developers and solution architects who plan to use the new SQL Server 2016 features for developing efficient database applications. It is also ideal for experienced SQL Server developers who want to switch to SQL Server 2016 for its rich development capabilities. Some understanding of the basic database concepts and Transact-SQL language is assumed.

Book content

chapters 20h32m total length

Introduction to SQL Server 2016

Review of SQL Server Features for Developers

SQL Server Tools

Transact-SQL Enhancements

JSON Support

Stretch Database

Temporal Tables

Tightening the Security

Query Store

Columnstore Indexes

Introducing SQL Server In-Memory OLTP

In-Memory OLTP Improvements in SQL Server 2016

Supporting R in SQL Server

Data Exploration and Predictive Modeling with R in SQL Server

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