Building and Managing High Availability Solutions with SQL Server Training in South Africa

  • Learn via: Classroom
  • Duration: 3 Days
  • Level: Intermediate
  • Price: Please contact for booking options

Along the course you will learn the basics on how to create a high available solution, along with the potential threats the platform may face. You will learn how to install Windows Server 2019, maintain it, monitor and troubleshoot your solution.

Read more +
We can host this training at your preferred location.

Prerequisites

Experience administering a recent version of Microsoft SQL Server

Read more +

What You Will Learn

  • Build a reliable High Availability solution with Windows Server 2019 and SQL Server 2019
  • Manage a High Availability solution with Windows Server 2019 and SQL Server 2019
  • Build Disaster Recovery Solutions
  • Troubleshoot problems with High Availability in SQL Server 2019
Read more +

Outline

Module 01: Introduction to High Availability

  • Basic aspects of High Availability

Module 02: Windows Server 2019 High Availability

  • Features Overview Overview of HA features in Windows Server 2019

Module 03: SQL Server 2019 High Availability Features Overview

  • Failover Cluster Instances
  • Availability Group
  • Log Shipping

Module 04: Windows Server 2019 Failover Clustering

  • Installation
  • Storage configuration
  • Quorum configuration
  • Maintenance
  • Patching/Upgrading
  • Adding/Removing nodes to/from cluster
  • Monitoring Troubleshooting

Module 05: SQL Server 2019 Failover Clustering Instance

  • SQL Server FCI configuration
  • Active/Active
  • Active/Passive
  • MS DTC
  • Maintenance
  • Patching/Upgrading
  • Adding/Removing SQL Server to/from cluster Monitoring Troubleshooting

Module 06: SQL Server 2019 Availability Groups

  • SQL Server AG configuration
  • Sync/Async
  • Read Only Routing and Load Balancing
  • Direct seeding
  • Distributed AG
  • Maintenance
  • Patching/Upgrading
  • Adding/Removing files to/from database in AG
  • Adding/Removing database to/from AG
  • Monitoring
  • Troubleshooting

Module 07: SQL Server Interoperability

  • Interoperability
  • with Integration Services
  • with Analysis Services
  • with Reporting Services
Read more +


Contact us for more detail about our trainings and for all other enquiries!

Avaible Training Dates

Join our public courses in our South Africa facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

04 May 2025 (3 Days)
Cape Town, Durban, Johannesburg
Classroom / Virtual Classroom
07 May 2025 (3 Days)
Cape Town, Durban, Johannesburg
Classroom / Virtual Classroom
15 May 2025 (3 Days)
Cape Town, Durban, Johannesburg
Classroom / Virtual Classroom
17 May 2025 (3 Days)
Cape Town, Durban, Johannesburg
Classroom / Virtual Classroom
23 May 2025 (3 Days)
Cape Town, Durban, Johannesburg
Classroom / Virtual Classroom
04 June 2025 (3 Days)
Cape Town, Durban, Johannesburg
Classroom / Virtual Classroom
11 June 2025 (3 Days)
Cape Town, Durban, Johannesburg
Classroom / Virtual Classroom
05 August 2025 (3 Days)
Cape Town, Durban, Johannesburg
Classroom / Virtual Classroom
Building and Managing High Availability Solutions with SQL Server Training Course in South Africa

Formerly known as Union of South Africa, now officially known as Republic of South Africa is the Southernmost country in Africa. South Africa's population is over 60 million people, which makes the country the world's 23rd-most populous nation. South Africa has three capital cities: executive Pretoria, judicial Bloemfontein and legislative Cape Town, while the largest city is Johannesburg. The official languages of South Africa are Afrikaans, English, Ndebele, Pedi, Sotho, Swati, Tsonga, Tswana, Venda, Xhosa and Zulu.

South Africa can be rainy from November to February, so the best time to visit South Africa is from May to September. Despite the rainy season South Africa is a year-round destination, with varying regional climates. Blyde River Canyon, Durban, Drakensberg, Kruger National Park and of course, Cape Town are the tourist attractions of the country.

Expand your IT knowledge with our comprehensive range of courses, including programming, software development, business skills, data science, cybersecurity, cloud computing and virtualization. Our skilled instructors will facilitate hands-on training and share practical insights, all conveniently conducted at your preferred location within South Africa.
By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.