SQL Server 2008 R2: Data Management


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
SQL Server 2008 R2 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 2008 R2 provides Transact-SQL statements to ensure that administrators can perform these tasks to manage the table partitions. SQL Server also provides data compression at the table row and page level. Indexes can be created to allow for the quick retrieval of data from database tables. Administrators need to monitor and manage these indexes to ensure that they are being used efficiently. Importing and exporting data provides a way for database administrators to move data between tables, databases, and servers. This course demonstrates how to manage table partitions, configure data compression, as well as create and manage indexes in a database. It also shows how to import data using the BULK INSERT and OPENROWSET (BULK...) statements and how to import or export data using the bcp utility and the Import and Export Wizard. This course is one of a series in the SkillSoft learning path that covers the objectives for Microsoft SQL Server 2008 R2 exam number 70-432. Passing this exam will earn the learner the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008 R2, Implementation and Maintenance certification.

Target Audience
Professionals typically pursuing a career as a Database Administrator; individuals who don't 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.

Prerequisites
One to two years of experience using SQL Server 2008, SQL Server 2008 R2, or two to three years of experience using a previous version of SQL Server

Expected Duration (hours)
2.5

Lesson Objectives

SQL Server 2008 R2: Data Management

  • recognize how to partition a table
  • recognize how to partition an index
  • recognize how to modify a partition
  • recognize how row compression works in SQL Server 2008 R2
  • recognize how to enable data compression on a new table or index
  • recognize the basic principles of indexes in SQL Server 2008 R2
  • recognize how to create indexes in a database
  • recognize how to manage indexes in a database
  • recognize the considerations for using SQL Server 2008 R2 to perform a bulk import
  • recognize how to use Transact-SQL to perform a bulk data transfer
  • recognize how to use bcp to import and export data between SQL Server and data files
  • recognize how to use the SQL Server Import and Export Wizard
  • modify a partition
  • modify a function
  • determine the fragmentation of an index
  • export data
  • Course Number:
    md_mcir_a05_it_enus