|
|
|
SQL Server 2005 Update Training for Database Administrators (on DVD) (Prices exclude VAT)
|
|
|
[to previous page]
[other products in "Other IT Courses"]
|
|
|
| Product: |
SQL Server 2005 Update Training for Database Administrators (on DVD)
- Single User Licence
|
|
|
| Details: |
Course Description - This course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can support, configure, and maintain enterprise SQL Server 2005 databases and servers.
Course Outline
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
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
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
Module 3 Wrap-up
Module 4 - New SQL Server 2005 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
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
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
Module 6 Wrap-up
Module 7 - New SQL Server 2005 Disaster Recovery and 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
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
Module 8 Wrap-up
Course Closure |
