SQL Server Data Management

In this series you will learn how to perform a variety of data management tasks using SQL Server 2008. You will learn how to import and export data to and from tables and files, how to manage data partitions, how to create and maintain indexes including clustered, non-clustered and XML indexes, how to manage data compression, and how to work with collations.

Total Time: 3 Hour 12 Minutes              Video Tutorials: 14

Series Author: Susan Ibach

Lesson 1 - Importing and Exporting Data

In this lesson you will learn how to use a number of tools and commands in SQL Server 2008 to import and export data including the bcp command line utility, the T-SQL commands BULK INSERT and OPENROWSET, the SQL Server Import and Export Wizard, and SQL Server Integration Services.

• Video 1: Using the bcp Command Line Utility

  Duration: 21 Minutes 41 Seconds



• Video 2: Using BULK INSERT

  Duration: 8 Minutes 58 Seconds



• Video 3: Using OPENROWSET

  Duration: 11 Minutes 04 Seconds



• Video 4: Using SQL Server Import and Export Wizard

  Duration: 15 Minutes 12 Seconds



• Video 5: An introduction to SQL Server Integration Services

  Duration: 12 Minutes 24 Seconds

Lesson 2 - Managing Data Partitions

In this lesson you will learn how to create data partitions in SQL Server 2008 to horizontally partition the rows in your database table. Data partitions allow you to divide the rows in your database table across filegroups and control which records are stored in each filegroup using partition functions and partition schemes.

• Video 1: Creating a partitioned table

  Duration: 10 Minutes 58 Seconds



• Video 2: Managing partitioned tables

  Duration: 16 Minutes 17 Seconds

Lesson 3 - Maintaining Indexes

• Video 1: Clustered Indexes

  Duration: 16 Minutes 08 Seconds



• Video 2: Non-Clustered Indexes

  Duration: 9 Minutes 47 Seconds



• Video 3: Non-Clustered Indexes Advanced Concepts

  Duration: 12 Minutes 47 Seconds



• Video 4: XML Indexes

  Duration: 15 Minutes 03 Seconds



• Video 5: Managing Indexes

  Duration: 14 Minutes 28 Seconds

Lesson 4 - Controlling Collations and Compression

In this lesson you will learn how to compress data in SQL Server 2008 using Page compression, row compression, and sparse columns. You will also learn how to handle different languages in a database using collations.

• Video 1: Data Compression

  Duration: 14 Minutes 38 Seconds



• Video 2: Collations

  Duration: 12 Minutes 49 Seconds