New Features in SQL Server 2016 for Developers

Offered By: LinkedIn Learning

Course Description

Overview

Take a developer-focused tour of SQL Server 2016. Learn how to use new features to write less code and bring increased security, performance, and reliability to your applications.

Syllabus

Introduction

Introduction
What you should know

1. Developers! Developers! Developers!

Query store
Developer Edition license is now free
Consistent programmability surface area
StretchDB
Temporal tables
Backup to Azure BLOB
PolyBase
SQL Server on Linux

2. Database Engine: Security

Row-level security
Dynamic data masking
Always encrypted
Pool blocking period

3. Database Engine: Programmability

STRING_SPLIT
CREATE or ALTER
JSON Support
SQLClient on .NET Core
Visual Studio and Entity Framework

4. Database Engine: Performance

In-memory OLTP enhancements
Operational analytics
XEvent library performance improved

Conclusion

Next steps

Taught by

Anton Delsink

Related Courses

Advanced Monitoring and Optimizing with DynamoDB (Korean)
Amazon Web Services via AWS Skill Builder ممارسات التدريب
University of California, Davis via Coursera Create a 6-Sigma Improvement Event in PDSA in Google Slides
Coursera Project Network via Coursera Create an A3 Problem-Solving Diagram in Google Slides
Coursera Project Network via Coursera Leadership Skills for New Managers
CreativeLive