COURSE: Building and Managing High Availability Solutions with SQL Server 2017 - 2014

Build a reliable High Availability solution with Windows Server

Master your T-SQL Querying, Query Tuning and Programming skills. Create highly efficient solutions to your common business tasks

UPCOMING DATES

ONLINE Aug 7, 2018 Enroll here
ONLINE  Oct 23, 2018 Enroll here
Nov 12, 2018 – Stockholm-Kista Enroll here

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 2016, maintain it, monitor and troubleshoot your solution.

COURSE DELIVERY OPTIONS

3-DAYS CLASSROOM

The course will take place in a classroom with no more than 20 students in order to maintain a good level of interactivity.

INSTRUCTOR-LED ONLINE

The training will be an instructor-led 100% online course, where you will be able to talk to the mentor and solve your problems in real time It wil lbe run in six 3-hour long sessions.

PRIVATE ONSITE

The course will take place in your company’s facilities. We limit attendance to no more than 20 students in order to maintain a good level of interactivity. Request a quote now.

Course Coverage

Build a reliable High Availability solution with Windows Server 2012 R2/2016 and SQL Server 2014/2016

Manage a High Availability solution with Windows Server 2012 R2/2016 and SQL Server 2014/2016

Build Disaster Recovery Solutions

Troubleshoot problems with High Availability in SQL Server 2016 and 2014

“Itzik’s course opened my eyes and helped me re-discover the passion I have for solving problems using creative and efficient methods”

John Smith

DBA

“I am extremely happy after Herbert’s class. I will need more time to process everything I´ve learnt from this course”

Matt Johnson

Developer

“I can see why people love T-SQL. Being able to learn from Itzik has been a pleasure”

Jason Harris

DBA

COURSE OUTLINE

Module 01: Introduction to High Availability

  • Basic aspects of High Availability

Module 02: Windows Server 2016 High Availability Features Overview

  • Overview of HA features in Windows Server 2016

Module 03: SQL Server 2016 High Availability Features Overview

  • Failover Cluster Instances
  • Availability Group
  • Log Shipping

Module 04: Windows Server 2016 Failover Clustering

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

Module 05: SQL Server 2016 Failover Clustering Instance

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

Module 06: SQL Server 2016 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

Meet our Instructors

 Herbert Albert

Herbert Albert is a Mentor and Managing Director of SolidQ’s Central and Eastern Europe subsidiary. Since SQL Server 6.0 Albert worked as a consultant, a database developer and trainer and holds several Microsoft certifications including MCT. He was involved in the development of several Microsoft Official Curriculum courses. Herbert co-authored “SQL Server Upgrade Technical Reference Guide” for SQL Server 2008 and 2012 and the Microsoft Press book “SQL Server 2005 Step-by-Step Applied Techniques”. He is a regular speaker at international conferences and events. As a trainer Herbert is focused on courses for T-SQL programming and performance tuning, which he delivers successfully all over Europe.

Would you like to register for this course?

Fill out the form at the top of this page