We are happy to advise you!
0845 470 1000     Contact

Instructor-Led Online Training (ILO)
Live Online Classes in the Virtual Classroom

Find out more and view dates

Designing Database Solutions for Microsoft SQL Server (20465)


Who should attend

This course is intended for IT professionals whose primary responsibilities include planning and implementing:

  • Database infrastructure
  • Consolidation strategies
  • High availability solutions
  • Disaster recovery solutions


This course is part of the following Certifications:


This course requires that you have at least 2 years’ experience of working with relational databases, including:

  • Planning and implementing databases
  • Managing databases
  • Querying with Transact-SQL
  • Some basic knowledge of high availability and disaster recovery

Course Objectives

  • Understand the considerations for enterprise data infrastructure
  • Use the MAP Toolkit to assess an existing enterprise data environment
  • Implement Policy-Based Management
  • Use System Center to manage database infrastructure
  • Understand the options for multi-server health monitoring in SQL Server 2014
  • Configure Data Collector
  • Understand the considerations for consolidating databases and database servers
  • Explain the options for managing resources in various consolidation scenarios.
  • Explain the fundamental concepts behind cloud computing, and describe the technologies that underpin Microsoft cloud solutions
  • Provide SQL Server based data services in a private cloud infrastructure
  • Understand the core concepts and options for implementing high availability in SQL Server 2014
  • Implement high availability for individual databases by using log shipping
  • Describe the key benefits and features of Windows Server Failover Clustering
  • Describe how to use SQL Server AlwaysOn Failover Cluster Instances to maintain high availability for SQL Server instances
  • Describe the fundamental concepts and terminology for AlwaysOn Availability Groups
  • Explain how work with AlwaysOn Availability Groups
  • Explain the considerations for implementing high availability and disaster recovery by using SQL Server 2014, and describe some common scenarios
  • Explain the considerations for implementing high availability and disaster recovery by using SQL Server 2014 and Microsoft Azure services, and describe some common scenarios.
  • Describe SQL Server replication
  • Identify an appropriate replication solution for a particular scenario

Course Content

The focus of this three-day instructor-led course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies. It describes how to consolidate SQL Server workloads and how to plan and implement high availability and disaster recovery solutions.

Note: This course is relevant for both SQL Server 2012 and SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Online Training

Duration 3 days

Price (excl. VAT)
  • £ 1,845.-
  • SA Voucher: 3
    hardcoded default SA
Classroom Training

Duration 3 days

Price (excl. VAT)
  • United Kingdom: £ 1,845.-
  • SA Voucher: 3
    hardcoded default SA

Currently there are no training dates scheduled for this course.  Enquire a date