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

MCITP Database Administrator: SQL Server 2008

  • Overview

     

    Candidates for this course intend to work in an environment in which Microsoft SQL Server 2008 is used for database solutions. After completion of the course candidates will be able to install and configure SQL Server 2008, maintain instances, manage security, maintain a database and perform data management tasks. They will also learn how to monitor and troubleshoot SQL Server, optimize performance and implement high availability. Subsequently, the course will move on to designing database infrastructure, designing strategies for automating, securing, distributing data, monitoring and maintaining high availability of a database server.

    Course Objectives

     

    • Implement an administrative solution for SQL Server 2008.
    • Deploy SQL Server 2008.
    • Design the physical structure for SQL Server 2008.
    • Design a strategy for maintaining SQL Server 2008.
    • Design a strategy for managing SQL Server 2008.
    • Automate the database managing strategy for SQL Server 2008.
    • Design a strategy for securing databases in SQL Server 2008.
    • Design a strategy for monitoring SQL Server 2008.
    • Design a strategy for content distribution in SQL Server 2008.
    • Design a strategy for replication in SQL Server 2008.
    • Design a high availability solution for SQL Server 2008.
    • Design a strategy for backup and recovery in SQL Server 2008.

    Course Content / Exam(s)

    MCITP Database Administrator: SQL Server 2008
    Course# Course Contents Exam# Exam Regular Track (days) Fast Track (days) Super Fast Track (days)
    6231B Maintaining a Microsoft SQL Server 2008 R2 Database 70-432 - 6 4 2
    50400 Designing, Optimizing, and Maintaining a Database Administrative Solution for Microsoft SQL Server 2008 70-450 PRO: Designing, Optimizing and Maintaining a Database Server Infrastructure using MS SQL Server 2008 5 3 2
    Balance Days for day of arrival, exam(s) and practice 4 3 2
    Total duration 15 10 6
    Prerequisites
    • Basic knowledge of Microsoft Windows operating system and its core functionality.
    • Working knowledge of Transact-SQL.
    • Working knowledge of relational databases.
    • Some experience with database design.
    • Completed Course 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL.
    Recommended Courses and Certification:
  • Students Reviews
    Abraham Akuei Makuac  Koenig IT Training Student

    I'm Abraham Akuei from South Sudan. I attended MCSA SQL Server 2008 training with my colleague Kachuol Run Arol at Koenig, which was quite good for the benefit of my Company (Dar Petroleum) and...

    Read MoreAbraham Akuei Makuac South Sudan
    Desire  Larue Koenig IT Training Student

    Hi, I previously did my first training in Oracle with Koenig Solutions in GOA. Now I’m back again for a Microsoft certified IT Professional in SQL Server 2008. It has been one of the best learning...

    Read MoreDesire LarueSeychelles
    Derek Garside  Koenig IT Training Student

    I have attended one module (Course# 2778) and MCITP Database Administrator: SQL Server 2008 course in 11 days with Koenig Solutions, Shimla in August 2012. From the moment we arrived in Delhi until I...

    Read MoreDerek Garside United Kingdom
    Winstone Peter  Koenig IT Training Student

    My name is Winstone Peter. I am from Dar es Salaam, United Republic of Tanzania. I work with the Ministry of Finance as a Computer Systems Analyst. Before coming to Koenig Solutions, it took me...

    Read MoreWinstone Peter Tanzania
    Emmanuel Mnzava  Koenig IT Training Student

    My name is Emmanuel Mnzava from Tanzania. I was really impressed by the Koenig staffs from all levels; very helpful, friendly just to list a few. I have been to Koenig Solutions twice (First time I...

    Read MoreEmmanuel Mnzava Tanzania
    View All Testimonials
  • Schedule & Prices
  • Enquire Now