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