PDP Url

Updating Your Skills to SQL Server 2017 (MS-10998)

This two-day instructor led training course is aimed at database professionals looking to update their skills to cover SQL Server 2017.

Virtual

Learning Style

Intermediate

Difficulty

2 Days

Course Duration

2

SATV Value

Course Info

Download PDF

Certificate

See Sample

Subscribe Buy Individually
When you subscribe, you get:
Master Subscription plan gives you access to this course and over 1181 other popular courses
On Sale!
Now Only $2,999.00 Regular Price $3,499.00
Now Only $2,999.00 Regular Price $3,499.00
/ Year
This two-day instructor led training course is aimed at database professionals looking to update their skills to cover SQL Server 2017.

Course Information

About this course:

This two-day instructor led training course is aimed at database professionals looking to update their skills to cover SQL Server 2017.

 The average salary for a Solutions Developer with Microsoft Azure skills is  $69,606 per year.

Course Objective:

After completing this course, students will be able to: 

  • 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

Audience:

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

Prerequisite:

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. 

Suggested Prerequisite:

Updating Your Skills to Microsoft SQL Server 2016 (MS-10986)

Career Path:

IT Ops & Management…

Outline

Frequently Asked Questions

How will the Updating Your Skills to SQL Server 2017 (MS-10998) certification training benefit me in my current job role?

The Updating Your Skills to SQL Server 2017 (MS-10998) certification training will help you in your Job’s current role by knowing and getting hands on experience in the following areas:
  • Learn about Always Encrypted (More secure than before. Even DBAs and Sysadmins do not have the key to decrypt the data. From business perspective, business application’s data which is now totally encrypted when the data is at rest and when transmitting over the wire.
  • Get hands on experience and knowledge about DDM (Dynamic Data Masking). It will help you in cases where a developer queries data in the production environment for troubleshooting purposes without violating compliance regulations. The sensitive Public Information will not be seen by him/her instead, masked data will be seen in its place.
  • Know about how to save your data if a hacker tries to attack it. Providing extra layer of security, you will be able to get hands on experience on implementing Row Level Security which is an extra layer of data protection. Learning how to enable Row level security, which helps the table in a database, not to be accessed by a person who does not have any permission to, Making security system more reliable and robust by reducing surface area of your security system.
  • You will also learn and implement Adaptive Query Processing (Learns from query plans based on the feedback it receives from previous executions.)
  • How knowing about Graph Data, to define relationships between heavily connected tables.
  • Get hands on experience and knowledge about improvements made In SQL Server 2017 with regards to: Database Engine, SSIS (SQL Server Integration Services), MDS (Master Data Services), SSAS (SQL Server Analysis Services), SSRS (SQL Server Reporting Services and last but not the least, know about Machine aaLearning in SQL Server 2017.

What are the Updating Your Skills to SQL Server 2017 (MS-10998) course benefits?

  • Best practices for improved, security, Track permissions Identify and classify sensitive data
  • Track permissions
  • Track permissions Identify and classify sensitive data
  • What does SQL Server 2017 Auditing tool offer?
  • Track and log server-level events in addition to individual database events
  • It uses Extended Events to help create and run audit-related events. SQL Server Audit includes several audit components.

Which tools are provided in SQL Server 2017 for Programmability?

  • SQL Server Management Studio
  • SQL Server Data Tools
  • Visual Studio Code mssql extension
  • Native Command Line Tools-sqlcmd, bcp

On what platforms SQL Server 2017 is available on?

  • Yum Install, Apt-Get, and Zypper
  • Linux distributions including RedHat Enterprise Linux (RHEL), Ubuntu, and SUSE Enterprise Linux (SLES)
  • Docker: Windows & Linux containers
  • Windows Server / Windows 10
  • Package-based installation

More Information

More Information
Brand Microsoft
Subjects IT Ops & Management
Lab Access No
Technology Microsoft
Learning Style Virtual Classroom
Difficulty Intermediate
Course Duration 2 Days
Language English
SATV Value 2
VPA Discount VPA Discount

Reviews

Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account

Contact A Learning Consultant


click here