High Availability in SQL Server

This 3-day instructor led training course describes the design, implementation and maintaining high availability solutions in MS SQL Server.

Code
MSSQL-HA

Course length
3 days (8:30 – 16:00)

Form
In our classroom or online

Main course tutor

Aleš Hejduk

Aleš Hejduk

List price: 16 500 CZK (without VAT)

This course has no dates set. If you are interested in setting a new one, please contact skoleni@oksystem.cz.

This course is intended for

IT managers and database administrators, who need to use high availability solutions in MS SQL Server.

Syllabus

Module 1: Introduction to High Availability Solutions

  • Lesson: High Availability concepts
  • Lesson: Log Shipping
  • Lesson: Database Mirroring
  • Lesson: Windows Server Failover Clustering
  • Lesson: Always On Availability Groups
  • Lesson: Replications
  • Lab: Log Shipping, Database Mirroring

Module 2: Windows Server Failover Clustering

  • Lesson: Failower Clustering
  • Lesson: Design, prerequisities, implementation
  • Lesson: Managing, failover
  • Lab: Windows Server Failover Clustering

Module 3: Always On Availability Groups

  • Lesson: Implementation of Always On Availability Groups
  • Lesson: Failover and Maintaining
  • Lesson: Secondary Replicas
  • Lab: Always On Availability Groups

Module 4: Maintenance, Monitoring, Troubleshooting and Optimizing

  • Lesson: Maintenance, upgrades, changes
  • Lesson: Monitoring, Troubleshooting and Optimizing
  • Lab: Maintenance, Monitoring, Troubleshooting and Optimizing

Module 5: Replicating Data

  • Lesson: Design and replication implementation
  • Lesson: Troubleshooting and Maintaining
  • Lab: Replicating Data

 

Students will be able to

  • Design High Availability Solutions for MS SQL Server.
  • Implement Log Shipping and Database Mirroring.
  • Implement Windows Server Failover Clustering.
  • Implement Always On Availability Groups.
  • Replicate Data.

Course requirements

  • Basic knowledge of SQL Server, SQL and databases.
  • Basic knowledge of the Microsoft Windows operating system.

Hardware

Classrooms are equipped with performing computers with Internet access, including wireless access.

Literature

All participants will get internal OKsystem materials.

PDF to download

Prices do not include VAT. OKsystem a.s. reserves the right to change dates and prices of courses.

Similar courses

Take a look at some similar courses from our wide range.

Subsidized course „Jsem v kurzu“

Fundamentals of SQL Language for Users SQL-Jazyk 0


11 800 CZK Course detail
Subsidized course „Jsem v kurzu“

Installing, Administering and Maintaining a Microsoft SQL Server and Database Infrastructure DB-ADM


27 500 CZK Course detail
Subsidized course „Jsem v kurzu“

Writing Advanced Queries Using SQL SQL-Jazyk 2


17 700 CZK Course detail

Need some advice?

Do not hesitate to contact us. We are at your disposal and will be happy to help you.

Mgr. Barbora Záhlavová

Mgr. Barbora Záhlavová

More information about courses


+420 734 525 195
zahlavova@oksystem.cz

Ing. Lumír Vojtěchovský

Ing. Lumír Vojtěchovský

More information about courses


+420 724 332 135
vojtechovsky@oksystem.cz

Why OKškolení?

What are the main advantages of our training centre?

About us

Contact us

Do not hesitate to contact us with any questions you may have.

Simona Dianová

Simona Dianová

Training and test organization


+420 236 072 251
dianova@oksystem.cz

Ing. Dana Černá

Ing. Dana Černá

Certification tests


+420 236 072 318
cernad@oksystem.cz

Do you need to know more about us or would you prefer to contact us using the form?

Contact page

OKškolení is part of OKsystem a.s.