Providing Technology Training and Mentoring For Modern Technology Adoption
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.
After completing this course, students will be able to:
The primary audience for this course are existing database professionals with experience of SQL Server 2014 who want to update their skills to SQL Server 2016. Additionally this course is for existing SQL Server 2014 MCSAs who want to prepare for the Upgrade exam for SQL Server 2016 certification.
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
Describe key capabilities and components of SQL Server 2016
Lab : Exploring SQL Server 2016
After completing this module, you will be able to:
This module describes new and enhanced features in SQL Server performance.
Lab : Implementing SQL Server 2016 Performance Improvements
This module describes new and enhanced features in SQL Server security.
Lab : Implementing SQL Server 2016 Security Improvements
This module introduces what’s new in SQL Server Availability and Scalability.
Lab : Monitoring tempdb
This module introduces reporting and BI enhancements and new features in SQL Server 2016.
Lab : Implementing PowerBI
At the end of this module you will be able to describe data access enhancements in SQL Server 2016.
Lab : Exploring the new features of SQL Server Integrated services (SSIS)
This module describes enhancements in SQL Server OLAP.
Lab : OLAP with SQL Server
This module describes new SQL Server cloud functionality.
Lab : Using Stretch Database