Designing Database Solutions for SQL Server (20465)

This course describes how to design and monitor high performance, highly available data solutions with SQL Server 2012. This course focuses on creating plans and designs for database structure, storage, objects, and servers. Students will have the opportunity to practices hands-on skills and design tasks in a virtual lab environment and will learn about topics such as data compression, high availability, data migration, security, and scalability.

  • Experience with Transact-SQL
  • Familiarity with SQL Server 2012 components and tools
  • Familiarity with objects in a SQL Server database
  • Familiarity with enterprise Windows network and security architecture
  • 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

Exam 70-465

Course Days: 3 Days