Installing SQL Server 2005

SQL Server Database Components

Prepare for SQL Server Installation

Install SQL Server

Perform a SQL Server Unattended and Remote Installation

Working with Multiple Instances

Manage a SQL Server Installation

Discovering the SQL Server Tools

Manage SQL Server From a Command Prompt

Working with SQL Server Management Objects

 

Configuring SQL Server Options

SQL Server Storage

SQL Server Database Components

Transaction Logs and Database Recovery Models

Working with Filegroups

Schemas

Managing and Maintaining Datafiles

 

Database Capacity Planning

SQL Server Datatypes

How Data is Stored Within SQL Server 2005

SQL Server Fixed and Variable Datatypes

Datatype Best Practices

 

SQL Server Security

SQL Server Security Architecture

Managing Server and Database Security with Roles

Implementing a Security Design

Working with Schemas for Security

SQL Server Encryption and Cryptographic Storage

Working with Certificates

 

Creating and Partitioning Tables

Creating Tables

Working with Ffilegroups

Partitioning Tables Using Schemas and Functions

Implementing Database Integrity

Working with Constraints and Defaults

Enforcing Row Level Integrity

Working with Ttriggers

 

Creating and Maintaining Indexes

Indexing Guidelines

Creating Indexes

Optimizing Queries Using the Database Tuning Advisor

Working with Stored Procedures and UDFs

Creating Stored Procedures

Error Handling in Stored Procedures

Designing Stored Procedures

Executing Stored Procedures

Creating User Defined Functions

 

Extending Functionality Using Managed Code

Working with XML Data

Retrieve XML with FOR XML

Shred XML with OPENXML

Using the XML Datatype

Defining XML Schemas

Querying XML Data Using XQUERY

Combining XML Data with Relational Data

Optimizing XML Datatypes Querying Using XML Indexes

Working with Views

Designing Views

Creating Views

Using Views over Multiple Servers

Indexing Views

 

Using Managed Code

Defining .NET CLR Integration

Functionality of Using Managed Code

Creating User Defined Aggregates

Creating User Defined Functions

Creating Triggers in Managed Code

 

Using SQL Service Broker

Defining a SQL Service Broker Architecture

Creating a SQL Service Broker Application

Using SQL Service Broker Architecture with SQL Native Client Dependencies

 

Monitoring SQL Server

Creating DDL Triggers

Monitoring SQL Server Using SQL Profiler

Working with Event Notifications

 

Implementing High Availability and Disaster Recovery

Designing and Planning a Backup Strategy

Backup Databases

Restore Databases

Implementing and Maintaining Database Snapshots

Backup and Restore System Databases

Designing and Planning High Availability Solutions

SQL Server 2005 Clustering

Log Shipping

Implementing Database Mirroring

 

Implementing Replication with SQL Server 2005

The Need for Distributed Data

Replication Architecture

Replication Topology

Implementing Replication

Monitoring SQL Server Replication

Replication Management Objects

 

Automating SQL Server Administration

Automating SQL Server Overview

Configuring SQL Server Database Mail

Configure the SQL Server Agent Service

Creating SQL Server Jobs

Create and Manage User Defined Messages and Alerts

Working with Operators

Monitoring and Optimizing SQL Server Automation

 

Transferring Data

Data Transformation Mechanism

Designing a Data Process Flow

SQL Server Integration Services

Implementing Data Transformations

Working with XML Data Streams

Performing Bulk Inserts