SQL Server 2005 DBA Professional Certified Programme

Please choose one of these Certification Tracks:

Windows Server^® 2003: A Comprehensive Hands-On Introduction
(Course 595 - 5 days)

This course provides the essential foundation for managing your Windows Server 2003 system. You gain experience in the first steps toward evaluating, designing and deploying a Windows Server 2003 environment. You learn to organise and administer the Active Directory, optimise file system resources, implement security and upgrade to Windows Server 2003 R2.

SQL Server 2005 Comprehensive Introduction: Hands-On
(Course 131 - 4 days)

In this course, you gain the knowledge and practical skills needed to exploit the essential development and administrative tools of SQL Server 2005. You learn to create and manage databases with SQL Server Management Studio; configure merge replication and handle data conflicts; and deploy business intelligence solutions using Integration, Analysis and Reporting Services.

SQL Server 2005 Database Administration: Hands-On
(Course 132 - 5 days)

This in-depth course provides extensive experience using SQL Server 2005 tools to install SQL Server, create and modify storage structures, back up and recover databases, and manage security. You also learn to create and manage databases, transaction logs and database snapshots; deploy transactional replication; and manage complex multistep jobs with SQL Server Agent.

Windows Server^® 2003: A Comprehensive Hands-On Introduction
(Course 595 - 5 days)

SQL Server 2000 Database Administration: Hands-On
(Course 531 - 5 days)

In this hands-on course, you gain practical experience performing real-world administrative tasks with SQL Server 2000 using Enterprise Manager and Transact-SQL. You learn to install multiple SQL Server instances, manage multistep jobs with SQL Server Agent and set up transactional replication.

SQL Server 2005 Administration: Hands-On Skills Upgrade
(Course 129 - 3 days)

This skills upgrade course, designed for experienced SQL Server administrators, provides the knowledge required to effectively administer SQL Server 2005. You gain experience to exploit a wide range of administrator tools to achieve maximum benefit for your organisation. You learn to build database availability solutions with database snapshots and database mirroring, deploy a peer-to-peer replication topology, and implement enhanced security features.