M10986:Updating Your Skills to SQL Server 2016
About this course
Update your SQL Server skills with this introduction to the new features of SQL Server 2016. You’ll learn the new features for performance, security, availability and scalability, reporting and Power BI, data access, and SQL Server OLAP, and you’ll learn about new SQL Server cloud functionality.
OUTLINE
1. Introduction to SQL Server 2016
2. What’s New in SQL Server Performance
3. What’s New in SQL Server Security?
4. What’s New in SQL Server Availability and Scalability?
Enhanced AlwaysOn Availability Groups
What’s New with tempdb?Using Windows Server 2016
PowerShell 5.0
5. What’s New in SQL Server Reporting and BI?
Reporting Services Enhancements
PowerBI Enhancements
Mobile Report Publisher
6. What’s New in SQL Server Data Access?
PolyBase
Enhancements to Integration Services
Working with SSIS and Azure
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