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 EventData
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
|
