Updating Your Skills to SQL Server 2016 (10986)

Module 1: Introduction to SQL Server 2016
· Describe key capabilities and components of SQL Server 2016
Lessons
· Overview of SQL Server 2016
SQL Server 2016 Editions and Components
· Installing SQL Server 2016
· SQL Server Management Studio Enhancements
· Lab : Installing SQL Server 2016

Module 2: What’s New in SQL Server Performance
· This module describes new and enhanced features in SQL Server performance.
· Columnstore Indexes for Operational Analytics
· In-memory OLTP Enhancements
· The Query Data Store
Native JSON
· Temporal Tables
· Lab : Implementing SQL Server 2016 Performance Improvements

Module 3: What’s New in SQL Server Security?
· This module describes new and enhanced features in SQL Server security.
· Using Always Encrypted
· Row-level Security
· Dynamic Data Masking
· Lab : Implementing SQL Server 2016 Security Improvements

Module 4: What’s New in SQL Server Availability and Scalability?
· This module introduces what’s new in SQL Server Availability and Scalability.
· Enhanced AlwaysOn Availability Groups
· What’s New in Database Caching?
Using Windows Server 2016
· Lab : Availability and Scalability with SQL Server 2016

Module 5: What’s New in SQL Server Reporting and BI
· This module introduces reporting and BI enhancements and new features in SQL Server 2016.
· Reporting Services Enhancements
PowerBI Enhancements
· Lab : Implementing PowerBI

Module 6: What’s New in SQL Server Data Access?
· At the end of this module you will be able to describe data access enhancements in SQL Server 2016.
· PolyBase
· Enhancements to Integration Services
· Lab : Using PolyBase

Module 7: New and Enhanced
· Features in SQL Server OLAP
This module describes enhancements in SQL Server OLAP.
· New and Enhanced Features in SQL Server OLAP
· What’s New in SQL Server Analysis Services
· Lab : OLAP with SQL Server

Module 8: What’s New for SQL Server in the Cloud?
· This module describes new SQL Server cloud functionality.
· Stretch Database
Enhanced Backups to Azure
· Introduction to SQL Server 2016 Hybrid Cloud
· What’s New in SQL Server Azure Database
· Lab : Using SQL Server in a Hybrid Cloud

To ensure successful completion of this course, we recommend the following:

· Experience of building and managing database, data warehouse, and business intelligence (BI) solutions with SQL Server 2014.
· Familiarity with the Windows Server 2012 R2 operating system and networking.
Familiarity with Microsoft Excel and Microsoft SharePoint Server 2013