-
-
Cart
There are no items in your cart. Continue shopping on our Course Directory page.
SUBTOTALPay now -or- pay later
Pay by credit card at checkout
-or- pay later by invoice, as always.
-
SQL Server High Availability Training
Level: Advanced
Rating:
4.81/5 Based on 27 Reviews
SQL Server provides a full range of technologies that allow organizations to reduce downtime and maintain high levels of availability. In this SQL Server High Availability training course, you gain experience using SQL Server 2017 AlwaysOn technologies for building a variety of high availability solutions, and learn how to implement failover clustering, log shipping, database mirroring, and peer-to-peer transactional replication.
Key Features of this SQL Server High Availability Training:
- After-course instructor coaching benefit
- Learning Tree end-of-course exam included
You Will Learn How To:
- Design a service level agreement that matches business requirements
- Plan, prepare, and install a SQL Server failover cluster
- Mirror a database to ensure instant failover
- Automate deployment with AlwaysOn technologies
- Ensure business continuity through failover cluster
Certifications/Credits:
Choose the Training Solution That Best Fits Your Individual Needs or Organizational Goals
TRAINING AT YOUR SITE
Team Training
- Bring this or any training to your organization
- Full - scale program development
- Delivered when, where, and how you want it
- Blended learning models
- Tailored content
- Expert team coaching
Save More On Training with FlexVouchers – A Unique Training Savings Account
Our FlexVouchers help you lock in your training budgets without having to commit to a traditional 1 voucher = 1 course classroom-only attendance. FlexVouchers expand your purchasing power to modern blended solutions and services that are completely customizable. For details, please call 888-843-8733 or chat live.
Team Training
SQL Server High Availability Course Information
-
Course Description
In this 3-day SQL Server High Availability course, you learn to maintain a large number of constantly available database servers to ensure disaster recovery.
SQL Server High Availability Course Outline
-
High-Availability Fundamentals
Characterizing high availability
- The "five nines"
- Site
- Instance
- Database
- Defining a service level agreement
Planned vs. unplanned downtime
- Performing routine maintenance
- Recovering from disasters
- Handling hardware failures
-
Installing Windows 2008/2012 Failover Clustering
Defining components of a cluster
- Single-instance architecture
- Multi-instance architecture
- Shared storage
- Resource group
- Heartbeat
- Quorum
Preparing for Windows failover clustering
- Configuring an iSCSI target
- Managing shared storage
- Installing the failover clustering feature
-
Establishing SQL Server Failover Clustering
Planning for SQL Server failover clustering
- Determining the correct version of Windows Server
- Upgrading to SQL Server 2012
- Leveraging virtual machines for clustering
Creating a SQL Server failover cluster
- Installing a new failover cluster
- Adding a new node
- Failing over to a passive node
-
Employing Log Shipping
Preparing for a warm standby server
- Synchronizing logins
- Creating network shares
Implementing transaction log shipping
- Specifying log backup frequency
- Configuring the log shipping monitor
Switching to the standby server
- Redirecting applications
- Bringing the standby online
-
Configuring Database Mirroring
Comparing mirroring architectures
- High availability
- High protection
- High performance
- Full safety vs. safety off
Getting ready for mirroring
- Setting the recovery model
- Selecting the principal, mirror and witness servers
Mirroring a database
- Configuring the principal, mirror and witness servers
- Initiating the mirroring session
Administering mirroring
- Enabling and disabling mirroring with scripts
- Launching the Database Mirroring Monitor (DMM)
Employing a mirror for reporting
- Taking a database snapshot
- Querying a snapshot of the mirror
-
AlwaysOn Availability Groups
Enhancing the capabilities of database mirroring
- Database mirroring with multiple databases and multiple mirrors
- Manually failing over a group of databases
Clustering and deployment
- Multi-site clustering across subnets
- Automating deployment using AlwaysOn PowerShell cmdlets
- Monitoring the high-availability configuration using the AlwaysOn dashboard
-
Combining High-Availability Technologies
Selecting the appropriate strategies
- Determining the pros and cons of each HA technology
- Failover clustering with a mirror
Pulling it all together
- Creating a complete high-availability solution
- Evaluating the results
SQL Server High Availability Training FAQs
-
What is SQL Server High Availability?
SQL Server High Availability allows 24 hour access to its database if any problem were to arise and you need immediate solutions.
-
What version of SQL Server is this High Availability course applicable to?
The applicable version for this course is SQL Server 2017.
-
Can I learn SQL Server High Availability online?
Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs wherever you want.
Related SQL Server Training
Writing SQL Queries with SQL Server Management StudioSQL Server Reporting Services (SSRS) Report Development
Your Training Comes with a 100% Satisfaction Guarantee!*
*Partner-delivered courses may have different terms that apply. Ask for details.