Image of computer keyboard NC State University
NC State University - Computer Training Unit

MCTS Maintaining a SQL Server 2008 Database

Description: This course will help you to specialize your technological knowledge for Microsoft SQL Server 2008. It will prepare you to take the Microsoft Certified Technology Specialist certification exam that will demonstrate an IT professional's in-depth, current skills in SQL Server 2008. The course will cover maintaining databases using specific instructions and specifications. You will gain thorough knowledge of the product, understand how to use the tools and Transact-SQL language, and how to explore the user interface.

Suggested Prerequisites:  

  • MCTS Implementing SQL 2008 Server or experience equivalent
  • Querying and processing SQL Server Data with SQL Statements
 

Attend and You Will Learn
Lesson 1:
Review Managing Databases
Configure log and data files

Specifying a Recovery Model

Lesson 2:
Backing Up, Restoring, and Moving a Database
Backing up a database

Restoring a Database

Moving a Database
Lesson 3:
Managing Database Snapshots
Creating a Database Snapshot

Reverting a Database from a Database Snapshot

Lesson 4:
Automating Administrative Tasks
Create a SQL Server Agent Job

Creating a Maintenance Plan

Using DTUTIL

Configuring Operators

Configuring Alerts

Configuring Database Mail

Lesson 5:
Managing SQL Server Security
Using the Surface Area Configuration Tool and SAC

Configuring Server Security Principals

Configuring Database Securables

Configuring Encryption

Configuring Linked Servers

Lesson 6:
SQL Server High Availability Technologies: Clustering
Introduction to Clustering

Clustering requirements

Clustering Features

Clustering Limitations

GEO Clusters

Lesson 7:
SQL Server High Availability Technologies: Database Mirroring
Understanding Database Mirroring Roles

Preparing Databases for Database Mirroring

Establishing Endpoints

Understanding Operating Modes

Failing over a Database Mirror

Removing Database Mirroring

Lesson 8:
SQL Server High Availability Technologies: Log Shipping
Preparing to Log Ship

Configuring Log Shipping Options

Configuring Log Shipping Mode

Configuring Monitoring

Lesson 9:
SQL Server High Availability Technologies: Replication
Understanding Replication Types

Setting Up Replication

Configuring Replication Security

Configuring Conflict Detection for Merge Replication

Monitoring Replication

Lesson 10:
Monitoring SQL Server
Working with SQL Profiler

Working with System Monitor

Using DTA

Using Dynamic Management Views and Monitoring Data

Correlating Performance and Monitoring Data

Resolving Blocking and Deadlocks

Resolving Database Errors

Using DAC

Lesson 11:
Transferring Data
Preparing to Work with Flat Files

Running BCP

Performing a Bulk Insert Task

Importing Bulk XML Data

Introduction to SSIS

Using the SSIS Import/ Export Wizard

Lesson 12:
Creating Full-Text catalogs
Cresting a Full-Text Catalog

Creating a Full-Text index

Populating a Full-Text Index

Querying Data by Using a Full-Text Index

For available dates, Click Here.

Upcoming Events

919.515.8163 - NC State University - 1101 Gorman Street - Campus Box 7401 - Raleigh, NC 27695
Computer Training Unit is a unit of McKimmon Center for Extension & Continuing Education
Copyright © 2008 - North Carolina State University - All Rights Reserved - Policy Disclaimer

Valid XHTML 1.0 Strict Valid CSS