Customer Service or Enrol: 0800 282 353 or +44 1372 364610
 

SQL Server 2005 Administration: Hands-On Skills Upgrade

Course: 129   Type: Hands-On   Duration: 3 Days
Quick Enrol  

You Will Learn How To

  • Leverage SQL Server 2005 features and administration tools
  • Build database availability solutions with database mirroring & database snapshots
  • Deploy a peer-to-peer replication topology
  • Implement encryption and other enhanced security features
  • Enable and secure Common Language Runtime (CLR) capabilities
  • Integrate Database Mail with SQL Server Agent

Course Benefits
The release of SQL Server 2005 includes an extensive array of new tools and capabilities for SQL Server administrators. Those migrating from SQL Server 7 or SQL Server 2000 must upgrade their skills in order to leverage the enhanced feature set.

This skills upgrade course provides the knowledge required to effectively administer SQL Server 2005. You learn to exploit the wide range of new administrator tools to gain maximum benefit for your organization.



Who Should Attend
This course is valuable for experienced SQL Server administrators considering or currently migrating to SQL Server 2005. Familiarity administering SQL Server at the level of Course 531, "SQL Server 2000 Database Administration", is assumed.

Hands-on Training
Throughout this course, extensive hands-on exercises provide practical experience administering SQL Server 2005. Exercises, performed under the guidance of an expert instructor, include:
  • Implementing peer-to-peer replication
  • Mirroring a database
  • Building a permission hierarchy that enforces the least privilege principle
  • Encrypting data with certificates
  • Deploying SQLH2 and reviewing collected data
  • Configuring Database Mail

Course Content
Introduction to SQL Server 2005
  • Installing SQL Server 2005
  • Upgrading from previous versions
  • SQL Server Management Studio
  • Health and History Tool (SQLH2)
Exploring the SQL Server 2005 tools
SQL Server Management Studio
  • Registering servers
  • Writing and issuing queries
  • Generating scripts with Object Explorer
Additional administrator tools
  • SQLCMD
  • Surface Area Configuration
  • SQL Server Configuration Manager
  • Dedicated Administrator Connection (DAC)
Enhancing Database Availability
Implementing database mirroring
  • Selecting mirroring architecture
  • Configuring the mirror and witness servers
Managing database snapshots
  • Taking database snapshots
  • Improving performance with snapshots
  • Combining snapshots and mirroring
Replicating Information
Installing a peer-to-peer topology
  • Concepts and terminology
  • Configuring peer servers
Handling replication security
  • Studying the agent security model
  • Securing the Distributor, Publisher and Subscribers
Securing SQL Server 2005
Defining the new terminology
  • Principals
  • Securables
  • Scope
Applying password policy
  • Exploring Windows security policy
  • Specifying policy enforcement and expiration for a SQL Server login
Administering schemas
  • Designing schemas
  • Assigning a default schema to a user
Upholding the principle of least privilege
  • Granting fine-grained permissions
  • Securing CLR assemblies
Encrypting sensitive data
  • Selecting encryption algorithms
  • Choosing asymmetric or symmetric keys
  • Implementing certificate-based encryption
Leveraging the SQL Server Health and History (SQLH2) Tool
Deploying SQLH2
  • Gathering SQL Server instance information with Collector
  • Establishing a repository
  • Viewing SQLH2 reports
SQL Server Agent
Securing Agent
  • Creating and mapping a credential to a proxy
  • Specifying a proxy for CmdExec and ActiveScript steps
Setting up Database Mail
  • Creating a mail profile
  • Configuring Agent's properties
  • Testing the mail setup
Moving to SSIS
  • SQL Server Integration Services fundamentals
  • Upgrading DTS packages
  • Building an ETL package
SQL Server is a trademark of Sybase, Inc.
  

request more info Salutation*:

First Name*:

Last Name*:

Job Title:

Company*:

Post Code*:

Country*:
   Codes
Office Telephone*:

Extension:

E-mail*:

* Required

A Learning Tree representative will contact you to follow up your request for information.

Save 55%
SQL Server 2005 Administration: Skills Upgrade
Course Schedule
23 - 25 Jul, 2008
London
19 - 21 Nov, 2008
London

Participants encrypting data with certificates.

£ 1,395 - Standard Tuition
Savings Plans
£ 810 - 10-Day Training Pass
£ 995 - Flex-Training Passport
£ 800 - Short Course Vouchers
£ 1,255 - Alumni Gold Tuition

 
Certification Core Course
 
SQL Server 2005 for the Enterprise
 
Customer Service or Enrol: 0800 282 353 or +44 1372 364610