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.

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 »

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