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
Questions about the course?
Ing. Jitka Sotonová
Leader of training center
Dates
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.
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.
Installing, Administering and Maintaining a Microsoft SQL Server and Database Infrastructure DB-ADM
Implementing a SQL Data Warehouse DB-DW
Fundamentals of SQL Language for Users SQL-Jazyk 0
Need some advice?
Do not hesitate to contact us. We are at your disposal and will be happy to help you.
Why OKškolení?
What are the main advantages of our training centre?
36+ years in business
We have been on the market for more than 36 years and have a wealth of experience in this field.
We are a training center with a rich history and tradition.
Experienced tutors
The basis of any quality education is good and experienced lecturers and this is something that we at OKškolení take particular pride in. Our top lecturers are waiting for you.
Modern classrooms
All classrooms are spacious, air-conditioned, barrier-free and equipped with high-standard computers, with Wi-Fi connection.
Bonus program
Protect your investments into education, loyalty program, advantageous offers, refreshments, grants...
Contact us
Do not hesitate to contact us with any questions you may have.
Do you need to know more about us or would you prefer to contact us using the form?
