(Click Category to List Courses)
40 - IT-O - Information Technology - Operating Systems and System Administration
IT-O 115 - High Availability for Windows Server, SQL Server and IIS (7 Days)
Code | Start Date | Duration | Venue | |
---|---|---|---|---|
IT-O 115 | 09 October 2023 | 7 Days | Istanbul | Registration Form Link |
IT-O 115 | 04 December 2023 | 7 Days | Istanbul | Registration Form Link |
Course Description
Windows Server and applications on it are ubiquitous in almost all of the of the organizations. Their popularity brings its own issues like making these products always available, against hardware and software issues and hacking attacks. Windows and related products has had many options for high availability. This course is designed to provide necessary information and practice for these options.
Course Objectives
- Familiarizing with Windows services
- Explaining the built-in high availability options
- Explaining Domain Controllers in a Windows domain and availability they provide
- Explaining the SQL Server Always On Mechanism
- Explaining the Network Load Balancing and DNS Round-Robin Mechanism for IIS
Who Should Attend?
- IT professionals
- IT Developers
- Anyone with basic understanding of Hyper-V
Course Details/Schedule
Day 1
- Basic concepts in High Availability
- Defining Levels of Availability
- Planning High Availability Solutions
- Determining the appropriate High Availability Solution
- Windows Server, File Services, Domain Controller Functionality
- Availability options for File services
- Availability options for Domain Controllers
- Availability options for Active Directory
- Role of the DNS Server
- Availability options for Domain Controllers and Active Directory
- Availability options without using Domain Controllers and Active Directory
- Hands On Lab for implementation / configuration of all of the above
Day 2
- Creating a failover cluster
- Need for a Shared Disk
- Configuring ISCSI on Windows Server
- Creating and configuring a new failover cluster
- Verifying quorum settings and adding a node
- Evicting a node and verifying quorum settings
- Changing the quorum from disk witness to file-share witness, and defining node voting
- Verifying high availability
- Maintaining a failover cluster
- Troubleshooting a failover cluster
- Implementing site high availability with stretch clustering
- Availability options without using Domain Controllers and Active Directory
- Hands On Lab: Implementation / configuration of all of the above
Day 3
- Overview of the integration of Hyper-V Server 2016 with failover clustering
- Implementing Hyper-V VMs on failover clusters
- Key features for VMs in a clustered environment
- Configure iSCSI storage
- Configuring a failover cluster for Hyper-V
- Configuring a highly available VM
- Hands On Lab for implementation / configuration of all of the above
Day 4
- Configuring an NLB cluster
- Planning an NLB implementation
- Implementing a Network Load Balancing (NLB) cluster
- Configuring and managing the NLB cluster
- Validating high availability for the NLB cluster
- Hands On Lab for implementation / configuration of all of the above
- NLB for IIS
- Explaining the IIS components
- DNS server-Web Server Relation
- Implementing the DNS Round-Robin Mechanism
- Implementing the Network Load Balancing Mechanism
- Discussing the Hardware Load Balancers Like F5
- Hands On Lab for implementation / configuration of all of the above
Day 5
- SQL Server Functionality
- Microsoft SQL Server Features
- Examining the Client Connection Methods to SQL Server
- Explaining the Always On mechanism (including Availability Groups)
- Asynchronous Commit Mode
- Synchronous Commit Mode
- Failover and Failover Modes
- Implementing the Always On mechanism for SQL Server
- Hands On Lab for implementation / configuration of all of the above
Day 6
- SQL Server HA with Mirroring and Replication
- Why back up? Backup and Restore of SQL Server databases
- High Availability using Replication
- High Availability using Mirroring
- Best practice recommendations
- Design your backup strategy
- Hands On Lab for implementation / configuration of all of the above
Day 7
- Encryption Concepts
- Preshared and Public Key Infrastructure
- IPSec and SSL
- Encryption Hierarchy
- Hierarchical Encryption and Key Management Infrastructure
- Certificates, Asymmetric and Symmetric Keys
- Extensible Key Management (EKM) module
- Choose an Encryption Algorithm
- All variants of DES, Triple DES, AES
- Transparent Data Encryption (TDE)
- TDE with Always On Availability Groups
- SQL Server and Database Encryption Keys (Database Engine)
- Service Master Key (SMK)
- Database Master Key (DMK)
- Extensible Key Management (EKM)
- Always Encrypted (Database Engine)
- Deterministic
- Randomized