20465C: Designing Database Solutions for Microsoft SQL Server 2014

  • Overview

    This module will teach students how to plan and execute enterprise database infrastructure solutions with the help of SQL Server 2014 and other MS technologies. This module is intended for candidates who are willing to learn SQL Server 2014 or 2012. After completing this course, students will be able to evaluate an existing enterprise environment and implement Policy-Based Management.

    Course Objectives

    • Implementing Policy-Based Management
    • Managing Resources in a Consolidated Database Infrastructure
    • Configuring tempdb to use Local Storage
    • Planning High Availability and Disaster Recovery Solutions by Using Microsoft Azure
    • Connecting to an AlwaysOn Availability Group
    • Creating a prepared Instance
    • Creating a Microsoft Azure Storage Account
    • Creating Databases in a Microsoft Azure Virtual Machine
    • Configuring tempdb to Use Local Storage
    • Planning Replication
    • Implementing Replication
    • Configuring Microsoft Azure SQL Database Security
    • Executing an AlwaysOn Availability Group
    • Installing an AlwaysOn Failover Cluster Instance

    Course Details / Exam(s)

    Schedule for 20465C: Designing Database Solutions for Microsoft SQL Server 2014
    Course # Course Contents Exam #

    Regular Track
    (days)

    20465C Designing Database Solutions for Microsoft SQL Server 2014 70-465 5
    Total 5
    Prerequisites
    • At least 2 years of experience of working with relational databases
    Recommended Courses and Certification:
    Give an edge to your career with technical certifications and training courses. Students can join the classes for 20465C: Designing Database Solutions for Microsoft SQL Server 2014 at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.
  • Students Reviews
    Jose Biniecki Mariusz Koenig IT Training Student

    During my stay, I did 2 fast track courses, MCSA: Windows Server 2012 R2 and MCSA SQL Server 2012 at Koenig Goa, India. I spent my time pretty nicely. I achieved MCSA certificates and met with new...

    Read MoreJose Biniecki MariuszPoland
    Hassan  Alawi Koenig IT Training Student

    My name is Hassan and I'm from Copenhagen in Denmark. I have no IT education on paper since I'm self-taught into IT. So I decided it is time to be certified, to get my knowledge on paper. I found...

    Read MoreHassan AlawiDenmark
    Clotilde Mundlovo  Soiane Koenig IT Training Student

    It was a great pleasure to have attended MCSA SQL Server 2012 course in Koenig Dubai. The training exceeded my expectations, taking into account the environment and ambience which were quite...

    Read MoreClotilde Mundlovo SoianeUnited Arab Emirates
    Daniel  Thompson Koenig IT Training Student

    This was my second trip to train with Koenig in India. My first time was in Dehradun, northern India and the experience is a life changing one. This time I decided to choose Goa and one of the forces...

    Read MoreDaniel ThompsonUnited Kingdom
     Robert Bakyayita    Koenig IT Training Student

    I came for training on Implementing Data Models and Reports with Microsoft SQL Server 2012. I have 7 years of experience in Information Technology across African Continent of which the current is...

    Read More Robert Bakyayita Uganda
    View All Testimonials
  • Schedule & Course Fees
    1
    5
    5
    Classes will be conducted from 09:00 am - 05:00 pm at Your Local Time
    Price includes Official Curriculum.
    For any Query or Custom Plan info@koenig-solutions.com +1 877 226 2244
  • Enquire Now
    * Required Fields
    •