SQL Server 2008 Data Management

This course is included in our On-demand training solution.

Overview

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 2008 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 exam number 70-432. Passing this exam will earn the learner the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, 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 or two to three years of experience using a previous version of SQL Server

Expected Duration

150 min.

Course Objectives

Managing Table Partitions in SQL Server 2008

  • recognize how to partition a table
  • recognize how to partition an index
  • recognize how to modify a partition
  • SQL Server 2008 Data Compression in a Database

  • recognize how row compression works in SQL Server 2008
  • recognize how to enable data compression on a new table or index
  • Introduction to Indexes in SQL Server 2008

  • recognize the basic principles of indexes in SQL Server 2008
  • Index Creation in SQL Server 2008

  • recognize how to create indexes in a database
  • Managing Indexes in SQL Server 2008

  • recognize how to manage indexes in a database
  • Transferring Bulk Data in SQL Server 2008

  • recognize the considerations for using SQL Server 2008 to perform a bulk import
  • recognize how to use Transact-SQL to perform a bulk data transfer
  • Importing and Exporting Data in SQL Server 2008

  • 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
  • Managing Tables, Indexes, and Data in SQL Server 2008

    SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?