Microsoft SQL Server 2005

Global Knowledge UK
Coventry, Dublin, London, Wakefield, Wokingham, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This three-day instructor-led hands-on 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.

Objectives
Describe the architecture of SQL Server 2005.
Install SQL Server 2005.
Use SQL Server 2005 administrative tools and utilities.
Maintain SQL Server 2005 servers and databases.
Secure a SQL Server 2005 server and database.
Monitor SQL Server 2005.
Implement a Backup and Restore solution for SQL Server 2005.
Implement a data availability solution with database mirroring or clustering.
Use enhanced SQL Server 2005 replication features.

Content
Overview of SQL Server 2005 Architecture
Overview of SQL Server 2005
System Enhancements for Administrators
Installing SQL Server 2005
Preparing to Install SQL Server 2005
Performing a SQL Server 2005 Installation
Maintaining a SQL Server 2005 Installation
SQL Server 2005 Administrative Tools
Using SQL Server Workbench
Using SQL Server Computer Manager
Using the sqlcmd Utility
Using the SQL Management Objects
Monitoring SQL Server 2005
Using SQL Profiler
Using DDL Triggers
Using Event Notifications
Using the System Virtual Tables
Configuring System Policies
Maintaining Databases and Indexes
Using the Database Maintenance Plan Wizard
Managing Indexes
Securing SQL Server 2005
SQL Server 2005 Security Overview
Managing SQL Server 2005 Security
SQL Agent Security
Disaster Recovery
Disaster Recovery in SQL Server 2005
Using Database Snapshots
Backup and Restore Operations
Configuring HTTP Filtering
Configuring Application and Web Filters
Data Availability
Introduction to Data Availability
Introduction to Database Mirroring
Configuring Database Mirroring
Replication
Overview of Replication Enhancements
New Types of Replication
Configuring Replication

...''

Phone:+44 (0) 118 977 7766

School Address:

Global Knowledge UK
Mulberry Business Park,
Fishponds Rd, Wokingham, RG41 2GY

Jobs & Resumes: Coventry, Dublin, London, Wakefield, Wokingham
Houses & Roommates: Coventry, Dublin, London, Wakefield, Wokingham

Microsoft Windows XP Operating System
MS Windows Server 2003 Active Directory & Network Infrastructure
Microsoft Windows XP Professional
ASP.NET Web Application Using Visual Studio .NET
Programming the Microsoft .NET Framework with C#
Visual Basic.Net
ADO.NET
XML Web Services Using Microsoft ASP.Net
MS Internet Information Services (IIS) 6.0
Microsoft Identity Integration Server (MIIS) 2003
Security for MS SQL Server 2005
Network Security
Internet Security and Acceleration (ISA) Server 2004
Networking for Call Pilot
VOIP Technologies
Call Pilot Rls. 4.0 Administration and Applications
Meridian 1 Large Switch Installation & Maintenance
Nortel Communication Server 1000 Telephony Manager Release 3.0
Communication Server 1000E Installation, Maintenance & Configuration

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We provide free training course catalog service since 2003, in English and Chinese. Tens of thousands of visitors search our database from our portal and partners' websites each day.