> > > 20465

Designing a Data Solution with Microsoft SQL Server (20465)

Course Description Kurs tarihleri Course Outline Lab Topology

Kimler katılmalı

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 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

Kurs hedefi

  • 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

Kurs içeriği

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.

Reservasyon için şehir adını tıklayınKurs tarihleri

Currently no local training dates available.  For enquiries please write to info@fastlane.si.

2018-01-22 - 2018-01-24 Ljubljana Kurs dili: Ingilizce Enroll
Instructor-led Online Training WebEx aracılığıyla VoIP ortamında gerçekleştirilir. Herhangi bir online kurslar hakkında sorularınız varsa, bize bu numaradan +49 (0)40 25334610 ulaşabilir veya e-mail ile info@flane.de iletişime geçebilirsiniz.

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!