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.

Student Testimonials

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 »


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