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.


SQL Server 2016 Admin High Availability & Performance Tuning Training (Duration : 40 Hours) Download Course Contents

Instructor - Led Online Training Fee For Both Group Training & 1-on-1 Training 1700
Group Training

19,20,21,22,23 Apr
09:00 AM - 05:00 PM CST
(8 Hours/Day)
03,04,05,06,07 May
09:00 AM - 05:00 PM CST
(8 Hours/Day)
07,08,09,10,11 Jun
09:00 AM - 05:00 PM CST
(8 Hours/Day)
GTR=Guaranteed to Run
1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Week End


Available

Not Available

Booked By You

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.