Microsoft SQL Server 2012: Managing Indexes, Full-Text Search and Partitions


Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
SQL Server 2012 provides features to allow administrators to ensure that data is accessed efficiently, this includes the use of indexes, table and index partitions, and full-text search. Indexes in SQL Server 2012 database allow data to be accessed quickly using keys that are stored in a B-tree structure. Indexes need to be created and managed to ensure for the best database performance. SQL Server 2008 provides table and index partitioning to allow data to be stored across multiple filegroups within a database. This makes tables and indexes that contain large amounts of data more manageable. Partitions in the database may need to be split to allow for more data to be stored, or data from one partition may need to be moved to another partition. SQL Server's full-text search component can be implemented to ensure that specific data is returned based on search words and phrases. This course demonstrations how to create and manage indexes, table and index partitions, and how to configure and use the full-text search component in SQL Server 2012. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft SQL Server 2012 exam 70-462: Administering Microsoft SQL Server 2012 Databases. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.

Target Audience
Professionals typically pursuing a career as a Database Administrator; individuals who do not work directly with SQL Server as part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators among others; Database Administrators who as part of their daily task perform installation, maintenance, and configuration tasks

Expected Duration (hours)
2.5

Lesson Objectives

Microsoft SQL Server 2012: Managing Indexes, Full-Text Search and Partitions

  • match the indexes that can be used in SQL Server 2012 to their descriptions
  • recognize the considerations associated with creating different types of indexes
  • recognize the options available for managing indexes
  • perform index maintenance
  • describe the characteristics of indexes in SQL Server 2012
  • manage and maintain indexes
  • recognize the steps for enabling full-text search
  • implement full-text search in SQL Server 2012
  • describe the features of partitioning in SQL Server 2012
  • recognize how to manage partitioning in SQL Server 2012
  • use full-text search in SQL Server 2012
  • recognize how to employ partitioning in SQL Server 2012
  • Course Number:
    md_msdb_a06_it_enus

    Expertise Level
    Beginner