10998: Updating Your Skills to SQL Server 2017

offered by NetCom Learning


Subjects:


 

Updating Your Skills to SQL Server 2017 course is aimed at database professionals looking to update their skills to cover SQL Server 2017.

This course is based on the objectives of the course version 10998A.

SATV Eligible Course
Don’t let your SATVs expire – put them to work for your organization today. Reserve your seat for the SATV eligible courses. To place your schedule request call at 1-888-563-8266 or chat live with a Learning Consultant.

Next Class Dates

Contact us to customize this class with your own dates, times and location. You can also call 1-888-563-8266 or chat live with a Learning Consultant.

Intended Audience for this 10998: Updating Your Skills to SQL Server 2017

» The primary audience for this course is existing database professionals with experience of 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.

Course Prerequisites for 10998: Updating Your Skills to SQL Server 2017

» Required: Experience of building and managing database, data warehouse, and business intelligence (BI) solutions with SQL Server 2016
» Required: Familiarity with Microsoft Office 2016
» Required: Familiarity with the Windows Server 2016 operating system and networking

10998: Updating Your Skills to SQL Server 2017 Course Objectives

» Describe key capabilities and components of SQL Server 2017
» Describe new and enhanced features in SQL Server Performance, Availability, and Scalability
» Describe new and enhanced features in SQL Server data access
» Describe new and enhanced features in SQL Server reporting and BI
» Describe new and enhanced features in SQL Server OLAP
» Describe new and enhanced data analytics features
» Describe new and enhanced features in SQL Server Cloud deployments
» Describe SQL Server on Linux functionality

10998: Updating Your Skills to SQL Server 2017 Course Outline

Introduction to SQL Server 2017
Overview of SQL Server 2017
Functionality across versions
What’s new in SQL Server Performance, Scalability, and Availability.
Adaptive query processing
Automatic tuning
Availability Scalability
Lab : Performance and availability – adaptive query processing
Interleaved execution
Batch mode memory grant feedback
Batch mode adaptive joins
What’s New in SQL Server data Access
SQL Graph
Lab : SQL Graph
Create a Graph database
Query a Graph database
What’s new in SQL Server Reporting and BI
Power BI report Server
Reporting Services update
Lab : Reporting and BI
Deploy Power BI report server
Add commenting to a report
New and Enhanced Features in SQL Server Analysis Services
Tabular model updates
Lab : Ragged hierarchies
View existing reports
Hide blank members
New and Enhanced data Analytics Features
New and enhanced data analytics features
Lab : Data analytics with Python
Enable external script execution
Run Python scripts
What’s new in SQL Server in the Cloud
Azure SQL database features
Managed Instances
Lab : Managed instances
SQL Server on Linux
SQL Server on Linux
Deploying SQL Server on Linux
Lab : SQL Server in Docker containers
Deploy a SQL Server Docker image
Run a SQL Server instance inside a Docker container
Connect to a SQL Server Instance running in a Docker container