We can host this training at your preferred location. Contact us!

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.

Experience administering a recent version of Microsoft SQL Server

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

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

Why have you chosen us?

I have attended a training from Bilginc IT Academy before and I was satisfied.

I have attended a training from a different provider and it was not helpful.

Other

How many employees do you have in your IT department?

0 – 50

50 – 250

250 – 1000

1000+

Upcoming Trainings

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

12 January 2025 (3 Days)
Toronto, Montreal, Calgary
Classroom / Virtual Classroom

18 January 2025 (3 Days)
Toronto, Montreal, Calgary
Classroom / Virtual Classroom

27 January 2025 (3 Days)
Toronto, Montreal, Calgary
Classroom / Virtual Classroom

12 January 2025 (3 Days)
Toronto, Montreal, Calgary
Classroom / Virtual Classroom

18 January 2025 (3 Days)
Toronto, Montreal, Calgary
Classroom / Virtual Classroom

17 February 2025 (3 Days)
Toronto, Montreal, Calgary
Classroom / Virtual Classroom

27 January 2025 (3 Days)
Toronto, Montreal, Calgary
Classroom / Virtual Classroom

27 February 2025 (3 Days)
Toronto, Montreal, Calgary
Classroom / Virtual Classroom

Building and Managing High Availability Solutions with SQL Server Training Course in Canada

Canada is a North American country. Known as the second-largest country of the world, Canada’s capital city is Ottawa. Toronto, Vancouver and Montreal are the biggest and most popular cities of this country. The 8,891-kilometer southern and western border between Canada and the United States is the world's longest intergovernmental land border. This country also has the longest coastline in the world.

Canada is a constitutional monarchy. The country was originally a British Empire colony and is now a part of the British Commonwealth. Both French and English are Canada’s official languages. Canada’s national animal is a beaver and the its flag design is a vertical triband of red and white with a red maple leaf charged in the centre. Some of the top-rated tourist attractions in Canada are Niagara Falls, Banff National Park and Rocky Mountains, CN Tower in Toronto City, Bay of Fundy, Old Quebec (Vieux-Quebec in French), the ski resort of Whistler, Ottawa's Parliament Hill and Vancouver Island.

Choose from our extensive selection of IT courses, covering programming, data analytics, software development, business skills, cloud computing, cybersecurity, project management. Our highly skilled instructors will deliver hands-on training and valuable insights at a location of your choice within Canada.

Building and Managing High Availability Solutions with SQL Server Training in Canada

Prerequisites

What You Will Learn

Outline

Upcoming Trainings