There are no items in your cart. Continue shopping on our Course Directory page.
Pay now -or- pay later
Pay by credit card at checkout
-or- pay later by invoice, as always.
PDF Add to WishList
SQL Server provides a full range of technologies that allow organizations to reduce downtime and maintain high levels of availability. In this 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.
Characterizing high availability
Planned vs. unplanned downtime
Defining components of a cluster
Preparing for Windows failover clustering
Planning for SQL Server failover clustering
Creating a SQL Server failover cluster
Preparing for a warm standby server
Implementing transaction log shipping
Switching to the standby server
Comparing mirroring architectures
Getting ready for mirroring
Mirroring a database
Administering mirroring
Employing a mirror for reporting
Enhancing the capabilities of database mirroring
Clustering and deployment
Selecting the appropriate strategies
Pulling it all together
Hassle-Free Enrollment: No advance payment required to reserve your seat.
Tuition due 30 days after you attend your course.
Tuition — Standard: $2650 Government: $2355
Apr 17 - 19
(
3 Days)
9:00 AM - 4:30 PM EDT
Rockville, MD / Online (AnyWare)
Reserve Your Seat
Aug 28 - 30
(
3 Days)
9:00 AM - 4:30 PM EDT
Ottawa / Online (AnyWare)
Reserve Your Seat
Oct 16 - 18
(
3 Days)
9:00 AM - 4:30 PM EDT
Rockville, MD / Online (AnyWare)
Reserve Your Seat
Guaranteed to Run
When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time, location — will run. Guaranteed.Enrolling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training.
For details, call 1-888-843-8733 or Click Here »
$2650
$2355
Course Tuition Includes:
Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm
Learning Tree's comprehensive training and exam preparation guarantees that you will gain the knowledge and confidence to achieve professional certification and advance your career.
Earn 17 Credits from NASBA
This course qualifies for 17 CPE credits from the National Association of State Boards of Accountancy CPE program. NOTE: Only live, in-class attendance qualifies for NASBA CPEs. Read more ...