Module 1

• What’s New in SQL Server 2005 for Administrators
  SQL Server 2005 Overview
  Database Engine Enhancements
  Analysis Services Enhancements
  Reporting Services Enhancements
  Replication Enhancements
  Demo - Reporting Services
  SQL Server Integration Services
  Notification Services
  Service Broker
  Native HTTP Support
  SQL CLR Support
  Demo - Creating an HTTP Endpoint
  Demo - Common Language Runtime
  Lab - Creating An HTTP Endpoint
  Module 1 Wrap-up

Module 2

• Installing SQL Server 2005
  
  Editions of SQL Server 2005 Hardware Requirements Software Requirements Coexistence with SQL Server 2000 System Consistency Checker Installing SQL Server 2005 Demo - Installing a 2nd Instance of SQL Adding or Removing Components Uninstalling SQL Server 2005 Lab - Installing an SQL Server Instance Module 2 Wrap-up

Module 3

• New SQL Server 2005 Admin Tools
  SQL Server Management Studio
  Demo - Management Studio
  SQL Configuration Manager
  Demo - Configuration Manager
  Surface Area Configuration
  Bus Intelligence Development Studio
  Demo - Development Environment
  The sqlcmd Utility
  Demo - Sequel Command
  SQL Management Objects
  Lab - Creating a Solution
  Module 3 Wrap-up

Module 4

• New SQL Server Monitoring Features
  SQL Profiler Enhancements
  DDL Trigger Overview
  Creating DDL Triggers
  Using DDL Trigger Event Data
  Demo - Creating a DDL Trigger
  Managing DDL Triggers
  Event Notifications
  Demo - Creating an Event Notification
  Management Views
  Two Types of Management Views
  Demo - Querying System Metadata
  Lab - Querying Metadata
  Module 4 Wrap-up

Module 5

• Tuning SQL Server 2005 Databases
  New Index Features
  Managing Indexes
  XML Indexes
  Managing Index Fragmentation
  Database Engine Tuning Advisor
  Using Database Engine Tuning Advisor
  Demo - Database Engine Tuning Advisor
  Lab - Tuning a Database
  Module 5 Wrap-up

Module 6

• Security in SQL Server 2005
  SQL 2005 Security Enhancements
  SQL 2005 Security Architecture
  ANSI Schemas in SQL Server 2005
  Demo - Schemas
  Managing SQL Server 2005 Logins
  Demo - Logins
  Managing SQL Server Users and Roles
  Managing SQL Server 2005 Permissions
  Demo - User ID's in Databases
  Managing Execution Context
  Demo - Permissions
  Demo - Execution Context
  Lab - Managing Security
  Module 6 Wrap-up

Module 7

• New SQL Server 2005 Disaster Recovery & Availability Features
  Disaster Recovery Enhancements
  Database Snapshots
  Database Snapshots and Recovery
  Changes to BACKUP
  SQL 2005 Restore Enhancements
  Online Restores
  Demo - Backup
  Recovering the Master Database
  SQL 2005 High Availability Options
  SQL Server 2005 Database Mirroring
  Mirror Server Prerequisites
  Partnerships and Witnesses
  Lab - Creating a Database Snapshot
  Module 7 Wrap-up

Module 8

• New SQL Server 2005 Replication Features
  Replication Architectural Enhancements
  Performance and Scalability
  Replication Tool Enhancements
  Heterogeneous Replication
  Peer-to-Peer Replication
  HTTP Replication
  Demo - Creating a Publication
  Lab - Creating a Publication
  Module 8 Wrap-up
  Course Closure