20465: Designing Database Solutions for Microsoft SQL Server




    5 Day(s) Course


    Official Courseware


    Exam Voucher


    Certified Trainer


    1:1 Training Available on Demand


    Customize Your Batch



    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.


    • Considerations for Enterprise Data
    • Assessing an Existing Infrastructure

    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


    • Microsoft System Center
    • Policy-Based Management

    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.


    • Introduction to Health Monitoring
    • Data Collector
    • SQL Server Utility

    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.


    • Considerations for Database Server Consolidation
    • Managing Resources in a Consolidated Database Infrastructure

    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.


    • SQL Server in a Private Cloud
    • Cloud Computing Overview

    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.


    • Log Shipping
    • High Availability Concepts and Options in SQL Server 2014

    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.


    • SQL Server AlwaysOn Failover Cluster Instances
    • Introduction to Windows Server Failover Clustering

    Module 8: AlwaysOn Availability Groups

    This module discusses AlwaysOn Availability Groups in SQL Server 2014, explains the key concepts of AlwaysOn Availability Groups.


    • Introduction to AlwaysOn Availability Groups
    • Considerations for Using AlwaysOn Availability Groups
    • Working with AlwaysOn Availability Groups

    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.


    • SQL Server High Availability and Disaster Recovery Solutions
    • High Availability and Disaster Recovery with SQL Server 2014

    Module 10: Replicating Data

    This module explains the SQL Server replications and explains the agents used to implement replication.


    • SQL Server Replication
    • Planning Replication

    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:

    • Planning and implementing database infrastructure.
    • Planning and implementing disaster recovery solutions.
    • Planning and implementing high availability solutions.
    • Planning and implementing consolidation strategies.

    This course requires that you meet the following prerequisites:

    • At least 2 years’ experience of relevant experience with relational databases, including:
    • Querying with Transact-SQL
    • Managing databases
    • Planning and implementing databases
    • Some basic knowledge of high availability and disaster recovery

    Name Code Fee
    Microsoft Certified Professional (MCP) - [70-465] 70-465 USD 127



    What Our Trainees Say

    Mercury Solutions Ltd. is rated 4.6 stars by based on 18 reviews.