Updating Your Skills to SQL Server 2016

Descrizione del corso

This three-day instructor-led course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016.

Programma

1. Introduction to SQL Server 2016
   • Overview of SQL Server 2016
   • SQL Server 2016 Editions and Components
   • Installing SQL Server 2016
   • SQL Server Management Studio Enhancements
2. What’s New in SQL Server Performance
   • Columnstore Indexes for Operational Analytics
   • In-memory OLTP Enhancements
   • The Query Data Store
   • Native JSON
   • Temporal Tables
3. What’s New in SQL Server Security?
   • Using Always Encrypted
   • Row-level Security
   • Dynamic Data Masking
4. What’s New in SQL Server availability and Scalability?
   • Enhanced AlwaysOn availability Groups
   • What’s New in Database Caching?
   • Using Windows Server 2016
5. What’s New in SQL Server Reporting and BI
   • Reporting Services Enhancements
   • PowerBI Enhancements
6. What’s New in SQL Server Data Access?
   • PolyBase
   • Enhancements to Integration Services
7. New and Enhanced Features in SQL Server OLAP
   • New and Enhanced Features in SQL Server OLAP
   • What’s New in SQL Server Analysis Services
8. What’s New for SQL Server in the Cloud?
   • Stretch Database
   • Enhanced Backups to Azure
   • Introduction to SQL Server 2016 Hybrid Cloud
   • What’s New in SQL Server Azure Database