Every registration supports local education. TrainUp Gives Back
Logo

Your Career Training Marketplace

Questions? Call Toll-Free: 1-866-540-9677

  • Instant Access ImageInstant Access
    From Anywhere
  • Unlimited Viewing ImageUnlimited
    Viewing
  • calendar Image 6-12 Months
    To Complete

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.

Learning Objectives
  • 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
  • Audience

Get the latest industry news, recommended courses, & promotions from TrainUp.com sent straight to your inbox.