• info@koenig-solutions.com
  • +91 81307 98752
  • +1 877 226 2244

10775: Administering Microsoft SQL Server 2012 Databases

  • Overview

    Administering Microsoft SQL Server 2012 databases instructor-led course at Koenig provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database. Also this course helps you prepare for the Exam 70-462.

    Audience: The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

    The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

    Course Objectives

    • Enabling Named Pipes Protocol for Both Instances
    • Creating an Alias for AdvDev
    • Working with Point-in-time recovery
    • Resolving Concurrency Issues
    • Resolving Login and Connectivity Issues 
    • Working with Server Roles
    • Working with Fixed Database Roles 
    • Restoring System Databases and Individual Files

    Course Content / Exam(s)

    Schedule for 10775: Administering Microsoft SQL Server 2012 Databases
    Course# Course Contents Exam# Exam Regular Track
    (days)
    10775 Administering Microsoft SQL Server 2012 Databases 70-462 Administering Microsoft SQL Server 2012 Databases 5
    Total 5
    Prerequisites
    • Working knowledge of Transact-SQL.
    • Working knowledge of relational databases.
    • Some experience with database design.

    Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills:

    • 10774A: Writing T-SQL Queries for Microsoft SQL Server 2012
    Recommended Courses and Certification:
  • 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
    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
    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
    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
    View All Testimonials
  • Schedule & Prices
  • Enquire Now