This 3/400-level, 5-day, SQL Server training class is designed to give a solid grounding for database administrators in topics related to high availability and disaster recovery.
The class starts by explaining the methodology for creating a sound HA/DR plan and then covers backup and restore operations in depth. After that, the four major multi-instance technologies (clustering, database mirroring, replication, and availability groups) are covered. Log shipping will be discussed, but not in any great depth. We also cover consolidation and virtualization, both of which play an important role in availability and cost-cutting. Finally we examine database snapshots, and cover consistency checking and recovering from corruptions in depth.
If you have previously attended IE3, you do not need to attend this course.
Availability is an area that is critical in today’s environment and all DBAs should be able to design and appropriate availability strategy and coordinate a successful recovery after a disaster.
This course will cover SQL Server 2005 through SQL Server 2014, and is essential for all SQL Server DBAs and architects. We will answer all your questions, to whatever depth you want to go.
Please note: demos will vary between versions and questions can be answered on any releases from SQL Server 2000 through the current release. And, if you’re a glutton for punishment and have even older versions, feel free to ask questions about any version ever released – someone on the team can probably answer it!
For a detailed agenda click HERE.
If you need help justifying training to your organization, we can help you:
Click HERE to go to our events registration page.
If you have any questions, please contact us.