SQL Server 2016 Admin High Availability & Performance Tuning Training


Sql Server 2016 Admin High Availability and Performance Tuning Certification Training Course Overview

Enroll for 5-day Sql Server 2016 Admin High Availability and Performance Tuning training course from Koenig Solutions accredited by Microsoft. Sql Server 2016 Admin High Availability and Performance Tuning course imparts skills and knowledge to manage and maintain SQL server 2016 administration with high availability and performance tuning.

Through a blend of hands-on labs and interactive lectures, you will be able to learn SQL server security models, logins and users along with tracing access to SQL Server with Extended Events which introduces on how to use SQL Profiles and SQL Trace Stored procedures to capture information about SQL server. This course also deals in Performance tuning and High availability which will prepare you on topics such as replication of high availability, Log shipping, database mirroring, index management and much more.

Download Course Contents

SQL Server 2016 Admin High Availability & Performance Tuning Training Course schedule & Prices

Course Details Schedule
Live Virtual Classroom (Instructor-Led)
Duration : 5 Days (10 Days for 4 Hours/Day)
Fee : 1,800 (Includes Taxes) 
9 AM - 5 PM (Flexible Time Slots for 4 hours option)






February
8 Hours/Day
4 Hours/Day
01-05
07-11
08-12
01-12
07-18
08-19
March
8 Hours/Day
4 Hours/Day
01-05
07-11
08-12
01-12
07-18
08-19
April
8 Hours/Day
4 Hours/Day
05-09
11-15
12-16
05-16
11-22
12-23
Client's Location
As per mutual convenience

Classroom training is available in select Cities
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request

Special Solutions for Corporate Clients! Click here

Hire Our Trainers! Click here

Request More Information

Course Prerequisites

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.
  • Some experience with database design


Target Audience:

  • Candidate who manages, maintain and administer SQL Database.
  • Candidate who are responsible for writing queries and ensuring optimal performance of workload.
  • Candidate responsible for High Availability and performance tuning.

Learning Objectives

After completing this course, you will learn about:

  • SQL Server Security’ introduces SQL Server security models, logins and users.
  • Authorizing Users to Access Resources.
  • Assigning Server and Database Roles.
  • Backup of SQL Server databases.
  • Automating SQL Server management.
  • Monitoring SQL Server with Alerts and Notifications.
  • Replication For HA.
  • Log Shipping (HA - DR).
  • DB Mirroring (HA - DR).
  • Cluster Configuration.
  • Tuning - Tuning Tools, Locks.
  • Always on availability.
  • Tuning – Index Management.