
SQL Server 2016 Developer's Guide
Key item features
- SQL Server 2016 Developer's Guide: Build efficient database applications for your organization with SQL Server 2016, (Paperback)
- Author: Packt Publishing
- ISBN: 9781786465344
- Format: Paperback
- Publication Date: 2017-03-22
- Page Count: 616
Specs
Edition, 1
Skill level, Advanced
Pages, 616
Language, English
Brand, Dejan Sarka
About this item
Product details
Get the most out of the rich development capabilities of SQL Server 2016 to build efficient database applications for your organization
Key Features:
- Utilize the new enhancements in Transact-SQL and security features in SQL Server 2016 to build efficient database applications
- Work with temporal tables to get information about data stored in the table at any point in time
- A detailed guide to SQL Server 2016, introducing you to multiple new features and enhancements to improve your overall development experience
Book Description:
Microsoft SQL Server 2016 is considered the biggest leap in the data platform history of the Microsoft, in the ongoing era of Big Data and data science.
This book introduces you to the new features of SQL Server 2016 that will open a completely new set of possibilities for you as a developer. It prepares you for the more advanced topics by starting with a quick introduction to SQL Server 2016's new features and a recapitulation of the possibilities you may have already explored with previous versions of SQL Server. The next part introduces you to small delights in the Transact-SQL language and then switches to a completely new technology inside SQL Server - JSON support. We also take a look at the Stretch database, security enhancements, and temporal tables.
The last chapters concentrate on implementing advanced topics, including Query Store, column store indexes, and In-Memory OLTP. You will finally be introduced to R and learn how to use the R language with Transact-SQL for data exploration and analysis.
By the end of this book, you will have the required information to design efficient, high-performance database applications without any hassle.
What You Will Learn:
- Explore the new development features introduced in SQL Server 2016
- Identify opportunities for In-Memory OLTP technology, significantly enhanced in SQL Server 2016
- Use columnstore indexes to get significant storage and performance improvements
- Extend database design solutions using temporal tables
- Exchange JSON data between applications and SQL Server in a more efficient way
- Migrate historical data transparently and securely to Microsoft Azure by using Stretch Database
- Use the new security features to encrypt or to have more granular control over access to rows in a table
- Simplify performance troubleshooting with Query Store
- Discover the potential of R's integration with SQL Server
Who this book is for:
This book is for database developers and solution architects who plan to use the new SQL Server 2016 features for developi
- SQL Server 2016 Developer's Guide: Build efficient database applications for your organization with SQL Server 2016, (Paperback)
- Author: Packt Publishing
- ISBN: 9781786465344
- Format: Paperback
- Publication Date: 2017-03-22
- Page Count: 616
Specifications
Book format
Edition
Skill level
Pages
Warnings
Similar items you might like
Mastering SQL: Query Databases Like a Pro: A Step-by-Step Guide to Writing and Optimizing SQL Queries, (Paperback) $19.99
$1999current price $19.99Mastering SQL: Query Databases Like a Pro: A Step-by-Step Guide to Writing and Optimizing SQL Queries, (Paperback)
Database Professional's Library PostgreSQL 8 for Windows, (Paperback) $42.26
$4226current price $42.26Database Professional's Library PostgreSQL 8 for Windows, (Paperback)
SQL Server 2017 Developer s Guide: A professional guide to designing and developing enterprise database applications, (Paperback) $59.45
$5945current price $59.45SQL Server 2017 Developer s Guide: A professional guide to designing and developing enterprise database applications, (Paperback)
Getting Started with Taipy: The definitive guide to creating production-ready Python applications for data professionals, (Paperback) $44.99
$4499current price $44.99Getting Started with Taipy: The definitive guide to creating production-ready Python applications for data professionals, (Paperback)
Document Generation From Oracle XML A Practical Guide in colour (Paperback) $45.99
$4599current price $45.99Document Generation From Oracle XML A Practical Guide in colour (Paperback)
SQL Usage Guide 2026: Go from Beginner Basics to Confident Querying, Safer Changes, and Everything In Between, (Paperback) $22.99
$2299current price $22.99SQL Usage Guide 2026: Go from Beginner Basics to Confident Querying, Safer Changes, and Everything In Between, (Paperback)
KeySQL The Definitive Guide: SQL for NoSQL Data, (Paperback) $29.99
$2999current price $29.99KeySQL The Definitive Guide: SQL for NoSQL Data, (Paperback)
Data Systems Unpacked: A Beginner's Hands-On Guide to Building Reliable and Scalable Application, (Paperback) $29.99
$2999current price $29.99Data Systems Unpacked: A Beginner's Hands-On Guide to Building Reliable and Scalable Application, (Paperback)
SQL Server: La NO guÃa práctica de optimización, (Paperback) $39.50
$3950current price $39.50SQL Server: La NO guÃa práctica de optimización, (Paperback)
SQL Crash Course: Learn essential skills in querying, security, and database management (English Edition), (Paperback) $34.95
$3495current price $34.95SQL Crash Course: Learn essential skills in querying, security, and database management (English Edition), (Paperback)
Beginner SQL Programming Using Microsoft SQL Server 2012 (Paperback) $20.56
$2056current price $20.56Beginner SQL Programming Using Microsoft SQL Server 2012 (Paperback)
MS Access 2016 SQL Comprehensive (Paperback) $40.69
$4069current price $40.69MS Access 2016 SQL Comprehensive (Paperback)
SQL Cookbook: Query Solutions and Techniques for All SQL Users, (Paperback) $41.99
$4199current price $41.99SQL Cookbook: Query Solutions and Techniques for All SQL Users, (Paperback)
Mastering SQL Injection: A Comprehensive Guide to Exploiting and Defending Databases (Paperback) $47.99
$4799current price $47.99Mastering SQL Injection: A Comprehensive Guide to Exploiting and Defending Databases (Paperback)
IBM Cognos 8 Business Intelligence: The Official Guide (Paperback) $38.52 Was $54.83
$3852current price $38.52, Was $54.83$54.83IBM Cognos 8 Business Intelligence: The Official Guide (Paperback)
Books for Professionals by Professionals SQL Server 2008 Transact-SQL Recipes, (Paperback) $43.39
$4339current price $43.39Books for Professionals by Professionals SQL Server 2008 Transact-SQL Recipes, (Paperback)
The Complete PostgreSQL Guide The Complete PostgreSQL Guide VOL.1: A Step-by-Step Guide for Beginners to Learning SQL, Designing Databases, Writing Po, Book 1, (Paperback) $26.99
$2699current price $26.99The Complete PostgreSQL Guide The Complete PostgreSQL Guide VOL.1: A Step-by-Step Guide for Beginners to Learning SQL, Designing Databases, Writing Po, Book 1, (Paperback)
Pro SQL Server 2022 Administration: A Guide for the Modern DBA, (Paperback) $46.02
$4602current price $46.02Pro SQL Server 2022 Administration: A Guide for the Modern DBA, (Paperback)
MS Access 2013 SQL Comprehensive $40.69
$4069current price $40.69MS Access 2013 SQL Comprehensive
Visual Basic and Databases 2019 Edition: A Step-By-Step Database Programming Tutorial, (Paperback) $44.20
$4420current price $44.20Visual Basic and Databases 2019 Edition: A Step-By-Step Database Programming Tutorial, (Paperback)
Customer ratings & reviews
- Free shipping
Free 90-day returns
How do you want your item?
Try 30 days of Walmart+ for just $1!
Related pages
- Ms Sql Server
- Excel 2016 Vs Excel 365 Formulas
- Power Query Excel 2016
- Best Sellers In Books Microsoft SQL Server
- Microsoft Sql Learning
- SQL Server Software
- Windows Administration Books
- Project Management Software Books
- Collaboration Software Books
- Quality Assurance & Testing Books
- Spreadsheets Books
- Data Warehousing Books
