MS-10998 - Updating Your Skills to SQL Server 2017

This two-day instructor-led course is aimed at people looking to update their skills to include SQL Server 2017.

Click here to print this page »


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 2016.
  • Familiarity with the Windows Server 2016 operating system and networking.
  • Familiarity with Microsoft Office 2016.

Detailed Class Syllabus

Module 1: Introduction to SQL Server 2017

Overview of SQL Server 2017
Functionality across versions

Module 2: What’s new in SQL Server Performance, Scalability, and Availability.

Adaptive query processing
Automatic tuning
Availability Scalability

Module 3: What’s New in SQL Server data Access

SQL Graph

Module 4: What’s new in SQL Server Reporting and BI

Power BI report Server
Reporting Services update

Module 5: New and Enhanced Features in SQL Server Analysis Services

Tabular model updates

Module 6: New and Enhanced data Analytics Features

New and enhanced data analytics features

Module 7: What’s new in SQL Server in the Cloud

Azure SQL database features
Managed Instances

Module 8: SQL Server on Linux

SQL Server on Linux
Deploying SQL Server on Linux