Course Code: 5766

OD10986 Updating Your Skills to SQL Server 2016

Class Dates:
90 Days
Class Time:


  • Course Overview
  • This course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016.

    Details for Microsoft Labs Online for this course: Introduction to SQL Databases
    Microsoft Labs Online is a secure, cost-effective, compliant, and convenient way to deliver Microsoft Official Courseware hands-on labs to your customers. This internet-based lab hosting service provides online access to the labs for this MOC On-Demand Course via a browser.
    Microsoft Labs Online is integrated within the MOC On-Demand Course and there are step-by-step instructions provided on how to access and perform the labs. The student will have 24x7 access to the labs for the duration of course access.
    Minimum requirements for Microsoft Labs Online include:
    Browser:current version of Internet Explorer, Microsoft Edge, Google Chrome™ or Firefox®, broadband Internet connection (recommended: network bandwidth of over 4Mbps)
  • Audience
  • This course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements.

    At Course Completion

    After completing this course, students will be able to:
    Describe key capabilities and components of SQL Server 2016
    Describe new and enhanced features in SQL Server performance
    Describes new and enhanced features in SQL Server security
    Describe what’s new in SQL Server Availability and Scalability
    Describe new and enhanced features in reporting and PowerBI in SQL Server 2016
    Describe new and enhanced data access features
    Describe new and enhanced features in SQL Server OLAP
    Describe new SQL Server cloud functionality


  • 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.

Course Details