Publisher: Microsoft

Version: 2008
Length: 4 day s
Course-ID: SX680GRB

Course Overview

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

Target Student

This 4 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 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
Full Text indexing
  • Creating and Populating Full Text Indices
  • Querying Full Text Data
  • Managing Full Text Indices
Distributing and partitioning data
  • Creating a Partition Function
  • Creating a Partition Scheme
  • Creating Partitioned Tables and Indices
  • Managing Partitions
Importing and exporting data
  • Importing and Exporting Data
  • Bulk Copy Program
  • The Bulk Insert Command
Designing Policy Based Management
  • Facets
  • Conditions
  • Policy Targets
  • Policies
  • Policy Categories
  • Policy Compliance
  • Import and Export Policies
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
Monitoring SQL Server
  • The System Monitor
  • The SQL Server Profiler
  • Diagnosing Service Failures
  • Diagnosing Service Startup Failures
  • Diagnosing Hardware Failures
  • Resolving Blocking and Deadlocking Issues
Optimising performance
  • Using the Database Engine Tuning Advisor
  • Working with the Resource Governor
  • Using Dynamic Management Views and Functions
  • Working with the Performance Data Warehouse
Failover Clustering
  • Designing Windows Clustering
  • Designing Failover Cluster Instances
Database mirroring
  • Overview of Mirroring
  • Initialising Database Mirroring
  • Designing Failover and Failback Strategies
Log shipping
  • Overview of Log Shipping
  • Initialising Log Shipping
  • Designing Failover and Failback Strategies
Replication
  • Overview of Replication
  • Transactional Replication
  • Merge Replication