×

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 »

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