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.
*Events with the Partial Day Event clock icon run longer than normal but provide the convenience of half-day sessions.
Aug 10 - 11 9:00 AM - 4:30 PM EDT Online (AnyWare) Reserve Your Seat
Aug 17 - 18 9:00 AM - 4:30 PM PDT Online (AnyWare) Reserve Your Seat
Aug 31 - Sep 1 9:00 AM - 4:30 PM EDT Online (AnyWare) Reserve Your Seat
Sep 21 - 22 9:00 AM - 4:30 PM EDT Online (AnyWare) Reserve Your Seat
Oct 6 - 7 9:00 AM - 4:30 PM EDT Toronto / Online (AnyWare) Reserve Your Seat
Oct 19 - 20 9:00 AM - 4:30 PM EDT Ottawa / Online (AnyWare) Reserve Your Seat
Nov 2 - 3 9:00 AM - 4:30 PM EST Herndon, VA / Online (AnyWare) Reserve Your Seat
Nov 16 - 17 9:00 AM - 4:30 PM PST San Francisco / Online (AnyWare) Reserve Your Seat
Nov 30 - Dec 1 9:00 AM - 4:30 PM EST New York / Online (AnyWare) Reserve Your Seat
Dec 14 - 15 9:00 AM - 4:30 PM EST Rockville, MD / Online (AnyWare) Reserve Your Seat
Jan 4 - 5 9:00 AM - 4:30 PM EST Toronto / Online (AnyWare) Reserve Your Seat
Jan 11 - 12 9:00 AM - 4:30 PM EST Ottawa / Online (AnyWare) Reserve Your Seat
Feb 1 - 2 9:00 AM - 4:30 PM EST Herndon, VA / Online (AnyWare) Reserve Your Seat
Feb 8 - 9 9:00 AM - 4:30 PM PST Seattle / Online (AnyWare) Reserve Your Seat
Mar 1 - 2 9:00 AM - 4:30 PM EST New York / Online (AnyWare) Reserve Your Seat
Mar 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 — will run. Guaranteed.Partial Day Event
Learning Tree offers a flexible schedule program. If you cannot attend full day sessions, this option consists of four-hour sessions per day instead of the full-day session.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.