Designing Database Solutions for Microsoft SQL Server Certification Course 20465D is an expert-level program that lays emphasis on planning, design and implementing database solutions through SQL Server 2014 technologies. The course will teach you to plan and implement consolidation strategies, high availability solutions, and disaster recovery solutions. This training course is intended for professionals who seek interest in learning SQL Server 2012 or 2014, with new features in SQL 2014 version.
Note* - This training is part 2 of the series of two courses for MCSE: Data Platform for SQL Server 2014. Participants need to qualify certification for both the course exams to earn the credentials of MCSE.
Module 1: Introduction to Enterprise Data Architecture
This module lays emphasis on the enterprise data architecture, its provisioning, and management.
Lessons
Module 2: Multi-Server Configuration Management
This module explains Policy-Based Management in SQL Server and describes how it can be used together with enterprise configuration management tools
Lessons
Module 3: Monitoring SQL Server 2014 Health
This module explains Data Collector and the SQL Server Utility Control Point (UCP), two features of SQL Server 2014 to perform in-depth health monitoring across the enterprise.
Lessons
Module 4: Consolidating Database Workloads with SQL Server 2014
This module describes the benefits of consolidating database workloads by using SQL Server 2014, and the different techniques for implementing and managing a consolidation strategy.
Lessons
Module 5: Introduction to Cloud Data Solutions
This module introduces fundamental concepts of cloud computing and outlines how to include SQL Server 2014 in a private cloud infrastructure.
Lessons
Module 6: Introduction to High Availability in SQL Server 2014
This module explains the different ways that you can implement high availability by using SQL Server 2014 and how to use log shipping to promote resilience for individual user databases.
Lessons
Module 7: Clustering with Windows Server and SQL Server 2014
This module describes how Windows Server Failover Clustering and SQL Server AlwaysOn Failover Cluster Instances work, and implementing clustering to protect service availability.
Lessons
Module 8: AlwaysOn Availability Groups
This module discusses AlwaysOn Availability Groups in SQL Server 2014, explains the key concepts of AlwaysOn Availability Groups.
Lessons
Module 9: Planning High Availability and Disaster Recovery
This module explains the planning considerations for high availability and disaster recovery, also provides common implementation scenarios for hybrid, on-premises, and Microsoft Azure environments.
Lessons
Module 10: Replicating Data
This module explains the SQL Server replications and explains the agents used to implement replication.
Lessons
The Microsoft SQL Server Designing Databases Solutions course is intended for database professionals who need who plan, manage, and implement database solutions. Primary responsibilities include:
This course requires that you meet the following prerequisites:
Name | Code | Fee |
---|---|---|
Microsoft Certified Professional (MCP) - [70-465] | 70-465 | USD 127 |
OR