MCTS: Microsoft SQL Server 2008, Database Development

  • Overview

    This instructor-led course is intended for Microsoft SQL Server database developers who are responsible for implementing a database on SQL Server 2008 R2. In this course, students learn the skills and best practices on how to use SQL Server 2008 R2 product features and tools related to implementing a database server. After completing this course, students will be able to use FOR XML and XPath queries, describe and use spatial data types in SQL Server, and implement and query full-text indexes.

    Course Objectives

    • Understand the product, its components, and basic configuration.
    • Work with the data types supported by SQL Server.
    • Design and implement tables and work with schemas.
    • Design and implement views and partitioned views.
    • Describe the concept of an index and determine the appropriate data type for indexes and composite index structures.
    • Identify the appropriate table structures and implement clustered indexes and heaps.
    • Describe and capture execution plans.
    • Design and implement non-clustered indexes, covering indexes, and included columns.

    Course Details / Exam(s)

    Schedule for MCTS: Microsoft SQL Server 2008, Database Development 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
    Balance Days MCTS: Microsoft SQL Server 2008, Database Development Training Boot Camp, Certification Exam (70-433) for day of arrival, exam(s) and practice 3 3 2
    Total duration 12 9 5

    Before attending this course, students must have:

    • Working knowledge of relational databases (database design skills).
    • Core Windows Server skills.
    • Basic programming language.
    Recommended Courses and Certification:
    Give an edge to your career with technical certifications and training courses. Students can join the classes for MCTS: Microsoft SQL Server 2008, Database Development at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.
  • Students Reviews
    Navinchandra Bhanu Arjan Vadgama  Koenig IT Training Student

    If I were asked to describe my experience at Koenig Solutions in Goa in one word - BRILLIANT!I work as a Data Analyst in the UK and chose the MCTS: MS SQL Server 2008 Developer course as I am...

    Read MoreNavinchandra Bhanu Arjan Vadgama United Kingdom
    Paulo Jorge De Oliveira Ramos  Koenig IT Training Student

    I’m Paulo Ramos currently employed as a Database Administrator in Angola. This is my second trip to India to attend a Boot Camp with Koenig Solutions. My first trip to Koenig Solutions was for Oracle...

    Read MorePaulo Jorge De Oliveira Ramos Angola
    Sule Nma Abdullahi  Koenig IT Training Student

    I have successfully completed my SQL Server 2008 training on MCTS: Microsoft SQL Server 2008, Database Development Fast Track Training Program (1-on-1™ training) in Goa and it has been a wonderful...

    Read MoreSule Nma Abdullahi Nigeria
    Sujeet Kumar  Koenig IT Training Student

    Dear All, I am a SQL Server DBA, based in Delhi and am going to tell you the shortcut to make more money in your career. Though I have good hands-on in my 11 years experience but to earn more, you...

    Read MoreSujeet Kumar India
    Batbold Chuluunbaatar  Koenig IT Training Student

    Hello, It was my first time come to India. I was introduced to Koenig Solutions by a friend who has been here. I have done my MCTS certification course with the help from my instructor who was...

    Read MoreBatbold Chuluunbaatar Mongolia
    View All Testimonials
  • Schedule & Course Fees
  • Enquire Now