SQL Server 2005 Components
SQL Server Services
System and User Databases
SQL Server Management Studio
Transact-SQL
SQLCMD
SQL Management Objects

SQL Server Installation
Installation options
SQL Server Instances
Upgrading SQL Server 2000
Configuration settings
Network protocols

Managing Databases
Understanding disk storage
Planning databases
Creating databases and transaction logs
Dealing with database growth
Reclaiming unused space
Database snapshots
Detaching and attaching databases
The Copy Database Wizard

Server and Database Security
Windows and SQL Server authentications
Authorising logins
Logins and roles
Enforcing password policy
Designing schemas
Adding users
Defining new roles
Delegating privileges with roles
Assigning users to roles
Granting server, database, schema-scoped and object permissions
Roles and permissions
Securing Common Language Runtime (CLR) assemblies
Encryption algorithms
Asymmetric or symmetric keys
Password and passphrase encryption

Monitoring SQL Server
Identifying bottlenecks
SQL Server Health and History tool (SQLH2)
SQLH2 data collection
The SQLH2 repository
Creating DDL Triggers
Monitoring SQL Server Using SQL Profiler
Working with Event Notifications

Backup and Recovery
Transaction log architecture
Recovery models
Backup types (Full, Log and Differential)
Recovering system and user databases
Mirroring architecture
Configuring the mirror and witness servers
Monitoring database mirroring

Automating Tasks
Configuring the SQL Server Agent
Setting up database mail
Defining jobs to handle routine tasks
Creating alerts and operators
Associating alerts with jobs

Replication
Understanding replication
Replication types
Replication agents
Configuring the Publisher and Distributor
Establishing publications
Subscribing to publications