There are no items in your cart. Continue shopping on our Course Directory page.
Pay now -or- pay later
Pay by credit card at checkout
-or- pay later by invoice, as always.
This two-day official Microsoft instructor-led course (10998) is aimed at database professionals looking to update their skills to cover SQL Server 2017. If you have SQL Server 2016 MCSA certification, this course will also prepare you for the upgrade exam for SQL Server 2017 certification.
LIVE, INSTRUCTOR-LED
TRAINING AT YOUR SITE
Customize Your Team Training Experience
CONTACT USOur FlexVouchers help you lock in your training budgets without having to commit to a traditional 1 voucher = 1 course classroom-only attendance. FlexVouchers expand your purchasing power to modern blended solutions and services that are completely customizable. For details, please call 888-843-8733 or chat live.
Sep 16 - 17 9:00 AM - 4:30 PM EDT Rockville, MD / Online (AnyWare) Reserve Your Seat
Oct 7 - 8 9:00 AM - 4:30 PM EDT Toronto / Online (AnyWare) Reserve Your Seat
Oct 21 - 22 9:00 AM - 4:30 PM EDT Ottawa / Online (AnyWare) Reserve Your Seat
Nov 4 - 5 9:00 AM - 4:30 PM EST Herndon, VA / Online (AnyWare) Reserve Your Seat
Dec 2 - 3 9:00 AM - 4:30 PM EST New York / Online (AnyWare) Reserve Your Seat
Dec 16 - 17 9:00 AM - 4:30 PM EST Rockville, MD / Online (AnyWare) Reserve Your Seat
Jan 6 - 7 9:00 AM - 4:30 PM EST Toronto / Online (AnyWare) Reserve Your Seat
Jan 21 - 22 9:00 AM - 4:30 PM EST Ottawa / Online (AnyWare) Reserve Your Seat
Feb 3 - 4 9:00 AM - 4:30 PM EST Herndon, VA / Online (AnyWare) Reserve Your Seat
Feb 24 - 25 9:00 AM - 4:30 PM EST New York / Online (AnyWare) Reserve Your Seat
Mar 16 - 17 9:00 AM - 4:30 PM EDT Rockville, MD / Online (AnyWare) Reserve Your Seat
Apr 6 - 7 9:00 AM - 4:30 PM EDT Toronto / Online (AnyWare) Reserve Your Seat
Apr 20 - 21 9:00 AM - 4:30 PM EDT Ottawa / Online (AnyWare) Reserve Your Seat
May 4 - 5 9:00 AM - 4:30 PM EDT Herndon, VA / Online (AnyWare) Reserve Your Seat
May 26 - 27 9:00 AM - 4:30 PM EDT New York / Online (AnyWare) Reserve Your Seat
Jun 15 - 16 9:00 AM - 4:30 PM EDT Rockville, MD / Online (AnyWare) Reserve Your Seat
Guaranteed to Run
When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time, location — will run. Guaranteed.In addition to their professional experience, students who attend this training should already have the following technical knowledge:
The primary audience for this course is existing database professionals with experience with SQL Server 2016 who want to update their skills to SQL Server 2017.
The secondary audience is existing SQL Server 2016 MCSAs who want to prepare for the Upgrade exam for SQL Server 2017 certification.
Module Goal: Describe key capabilities and components of SQL Server 2017
LessonsAfter completing this module, students will be able to:
This module introduces the performance enhancements provided by Adaptive Query Processing and Automatic Tuning, as well as the scalability and availability enhancements provided by new Availability Group architectures, including Read-Scale Availability Groups and Availability Groups with SQL Server on Linux.
LessonsAfter completing this module, students will be able to:
SQL Server 2017 introduces SQL Graph which enables you to define the relationships between your data items in a table rather than calculating them during a query, reducing the query cost and simplifying your data structure.
LessonsAfter completing this module, students will be able to:
This module describes what’s new in SQL Server reporting and BI.
LessonsAfter completing this module, students will be able to:
This module introduces new and enhanced features in SQL Server Analysis Services, with particular emphasis on the tabular data model.
LessonsAfter completing this module, students will be able to:
This module introduces new and enhanced data analytics features.
LessonsAfter completing this module, students will be able to:
Organizations want the best value from a mixture of cloud services and their existing investment in on-premises hardware and software. This module covers a comparison between the features of Microsoft Azure SQL Database and Microsoft SQL Server 2017, as well as new features that make it easier for you to migrate databases from on-premises SQL Server instances to Azure SQL Database.
LessonsAfter completing this module, students will be able to:
This module covers the features of SQL Server on Linux, as well as the process for deploying SQL Server on Linux and using Docker.
LessonsAfter completing this module, students will be able to:
Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs wherever you want. This course is available in class, online, and on demand.