20462: Administering Microsoft SQL Server 2014 Databases Training & Certification Course

  • Overview

    This module will teach students how to maintain a MS SQL Server 2014 database. After completing this module, students will be able to explain core database administration tasks, restore databases from backups, carry out ongoing database maintenance and set up and configure SQL Server 2014.

    Course Objectives

    • Describe common database administration tasks
    • Perform post-installation configuration tasks
    • Configure the buffer pool extension
    • Perform copy-only, compressed, and encrypted backups
    • Use Performance Monitor to monitor SQL Server
    • Manage database-level security principals
    • Implement SQL Server audit
    • Manage SQL Server audit
    • Configure Database Mail
    • Generate Database Tuning Recommendations
    • Monitor SQL Server errors
    • Manage Server-Level Security
    • Manage Database-Level Security
    • Use captured traces to test, troubleshoot, and optimize database performance

    Course Details / Exam(s)

    Schedule for 20462: Administering Microsoft SQL Server 2014 Databases
    Course # Course Contents Exam #

    Regular Track
    (days)

    20462D Administering Microsoft SQL Server 2014 Databases 70-462 5
    Total 5
    Prerequisites
    • Some experience with database design
    • Working knowledge of Transact-SQL
    • Working knowledge of relational databases
    • Knowledge of the MS Windows operating system
    Recommended Courses and Certification:
    Give an edge to your career with Microsoft certification training courses. Students can join the classes for 20462: Administering Microsoft SQL Server 2014 Databases Training & Certification Course at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.
  • Students Reviews
    Mohammad Hassan Mahamud Koenig IT Training Student

    The SQL Server Performance Tuning and Optimization training I received at Koenig Delhi was very informative and practical. The course was quite relevant to my job and will help me in most aspects of...

    Read MoreMohammad Hassan MahamudBangladesh
    Juvencio  Manhique Koenig IT Training Student

    The experience I had with Koenig Solutions in Dubai was very good and rewarding, since the beginning till the very end. Instructor was able to guide his students very well, through his knowledge of...

    Read MoreJuvencio ManhiqueUnited 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
    Bert  Ham Koenig IT Training Student

    I would like to thank you and your team for a very good course, I am very pleased with the results (MCSA 2012 graduation) and the acquired knowledge. The MCSA training was very good and the trainer...

    Read MoreBert HamNetherlands
     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
    •