Publisher: Microsoft

Version: 2008
Length: 2 day s
Course-ID: SX681GRB

Course Overview

Students will learn to install and configure SQL Server 2008 Standard Edition. A full range of implementation and administration subjects is covered.

Target Student

This 2 day course is intended for students who need to learn the skills necessary to maintain a Microsoft SQL Server 2008 database infrastructure. Being comprehensive and hands-on, it is aimed at quickly getting students familiar with the Microsoft SQL Server 2008 Standard Edition administration concepts, tools and utilities.

Prerequisites

No previous knowledge of SQL Server 2008 is assumed although an understanding of relational database concepts would be helpful. An understanding of working in a Microsoft Windows operating system environment. An understanding of relational databases and design principles. Some experience of the SQL language would be beneficial.


Installing and configuring SQL Server 2008
  • Hardware and Software Requirements
  • SQL Server Editions
  • Installing and Configuring SQL Server Instances
  • Configuring Database Mail
Database configuration and maintenance
  • Configuring Files and Filegroups
  • Database Options
  • Maintaining Database Integrity
Tables
  • Creating Tables
  • Implementing Constraints
Designing SQL Server indices
  • Index Architecture
  • Designing Indices
  • Maintaining Indices
Importing and exporting data
  • Importing and Exporting Data
  • Bulk Copy Program
  • The Bulk Insert Command
Backing up and restoring a database
  • Backing up Databases
  • Restoring Databases
  • Database Snapshots
Automating SQL Server
  • Creating Jobs
  • Creating Alerts
SQL Server security
  • TCP Endpoints
  • Configuring the SQL Server Surface Area
  • Creating Principals
  • Managing Permissions
  • Auditing SQL Server Instances
  • Encrypting Data
  • Working with the Performance Data Warehouse