MS-10986 - Updating Your Skills to SQL Server 2016

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.

Instructor did a great job, from experience this subject can be a bit dry to teach but he was able to keep it very engaging and made it much easier to focus. Student
Excellent presentation skills, subject matter knowledge, and command of the environment. Student
Instructor was outstanding. Knowledgeable, presented well, and class timing was perfect. Student

Click here to print this page »

Prerequisites


In addition to their professional experience, students who attend this training should already have the following technical knowledge:
  • 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.

Detailed Class Syllabus


Module 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

Module 2: What’s New in SQL Server Performance


Operational Analytics
In-memory OLTP Enhancements
Query Store
Live Query Statistics
Native JSON
Temporal Tables

Module 3: What’s New in SQL Server Security?


Using Always Encrypted
Row-level Security
Dynamic Data Masking

Module 4: What’s New in SQL Server Availability and Scalability?


Enhanced AlwaysOn Availability Groups
What’s New with tempdb?
Use Windows Server 2016 with SQL Server 2016

Module 5: What’s New in SQL Server Reporting and BI


Reporting Services Enhancements
PowerBI Enhancements
Mobile Report Publisher

Module 6: What’s New in SQL Server Data Access?


PolyBase
What’s new in Integration Services
Working with SSIS and Azure

Module 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

Module 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