MCTS: Microsoft SQL Server 2008, Database Development & Implementation and Maintenance

  • Overview

    This course is targeted at the Technology Specialist Certification of SQL Server 2008 Database Development and Implementation and Maintenance. After the completion of this course, candidates will be able to implement tables and views, implement programmable objects, work with query fundamentals and apply additional query techniques in SQL Server 2008 R2. They will also learn how to work with additional SQL Server 2008 R2 components, XML data and gather performance information. Apart from that the candidates will be able to install and configure SQL Server 2008 R2, 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.

    Course Objectives

    • Implementing tables and views
    • Implementing programming objects
    • Working with query fundamentals
    • Applying additional query techniques
    • Working with additional SQL Server components
    • Working with XML data
    • Gathering performance information 

    Course Content / Exam(s)

    Schedule for MCTS: Microsoft SQL Server 2008, Database Development & Implementation and Maintenance Boot Camp Training
    Course# Course Contents Exam# Exam Regular Track (days) Fast Track (days) Super Fast Track (days)
    2778A Writing Queries Using Microsoft SQL Server 2008 Transact-SQL 70-433 TS: Microsoft SQL Server 2008, Database Development 3 2 1
    6232B Implementing a Microsoft SQL Server 2008 R2 Database 6 4 2
    6231B Maintaining a Microsoft SQL Server 2008 R2 Database 70-432 TS: Microsoft SQL Server 2008, Implementation and Maintenance 6 4 2
    Balance Days MCTS .Net Framework for day of arrival, exam(s) and practice 4 3 2
    Total 19 13 7
    • Knowledge of Relational Database Management Concepts.
    • Knowledge of some .Net based language (C#, VB .Net).
    • Some basic knowledge of Structured Query Language desirable
    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
    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
    Marcel Runte  Koenig IT Training Student

    Namaste! My name is Marcel Runte and I am a System Administrator and Technical Application Administrator (as well as a teacher of French) in The Netherlands. For my new job starting in August, I...

    Read MoreMarcel Runte Netherlands
    Adam Cadman  Koenig IT Training Student

    In May 2012, I did the MCTS: SQL Server 2008, Database Development & Implementation and Maintenance Boot Camp with Koenig Solutions in Shimla. The journey from the UK to Shimla was long and tiring,...

    Read MoreAdam Cadman 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
    View All Testimonials
  • Schedule & Prices
  • Enquire Now