Maintaining a Microsoft SQL Server 2005 Database

Course

In London and Birmingham

£ 1,295 + VAT

Description

  • Duration

    5 Days

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.

Facilities

Location

Start date

Birmingham (West Midlands)
Spring House, 3010 The Crescent, Solihull Parkway, Birmingham Business Park Birmingham, B37 7YE

Start date

On request
London
See map
3-5 Crutched Friars, EC3N 2HR

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Course contentModule 1: Installing and ConfiguringSQLServer 2005This module explains how to plan for and installSQLServer 2005, how to manage aSQLServer 2005 installation, and how to use theSQLServer 2005 administrative tools.
  • Preparing to InstallSQLServer
  • InstallingSQLServer 2005
  • Managing aSQLServer 2005 Installation
Lab 1: Installing and ConfiguringSQLServer 2005
  • Performing an Installation
  • ManagingSQLServer
After completing this module, students will be able to:
  • Explain how to prepare the hardware and other resources necessary to installSQLServer 2005
  • InstallSQLServer 2005
  • Manage and configure aSQLServer 2005 installation
Module 2: Managing Databases and FilesThis module explains how to manage databases and files.
  • Planning Databases
  • Creating Databases
  • Managing Databases
Lab 2: Managing Databases and Files
  • Creating a Database
  • Monitoring and Managing Filegroup Usage
  • Viewing Database Metadata
After completing this module, students will be able to:
  • Plan how to implement a database that meets an organization's requirements
  • Create aSQLServer database
  • Manage aSQLServer database
Module 3: Disaster RecoveryThis module explains how to plan and implement a backup and restore strategy.
  • Planning a Backup Strategy
  • Backing Up User Databases
  • Restoring User Databases
  • Performing Online Restore Operations
  • Recovering Data from Database Snapshots
  • System Database and Disaster Recovery
Lab 3: Disaster Recovery
  • Implementing a Backup Strategy
  • Restoring and Recovering a Database
  • Performing Piecemeal Backup and Restore Operations
  • Restoring the master Database
After completing this module, students will be able to:
  • Plan a backup strategy for a database
  • Back up user databases
  • Restore user databases from backups
  • Restore data in a user database while it is online
  • Recover data for a user database from a database snapshot
  • Restore and recover systems databases
Module 4: Managing SecurityThis module explains how to manage principals, securables, and permissions, and how to implement cryptography in aSQLServer database.
  • Overview ofSQLServer Security
  • Protecting the Server Scope
  • Protecting the Database Scope
  • Managing Keys and Certificates inSQLServer
Lab 4: Managing Security
  • Creating Logins and Assigning Server-Scope Permissions
  • Creating and Managing Users
  • Using a Certificate to Protect Data
After completing this module, students will be able to:
  • Describe howSQLServer manages security
  • ProtectSQLServer at the server level
  • ProtectSQLServer databases
  • Use keys and certificates to protectSQLServer objects
Module 5: MonitoringSQLServerThis module explains how to monitorSQLServer performance and activity.
  • Viewing Current Activity
  • Using System Monitor
  • UsingSQLServer Profiler
  • UsingDDLTriggers
  • Using Event Notifications
Lab 5: MonitoringSQLServer
  • MonitoringSQLServer Performance
  • TracingSQLServer Activity
  • ImplementingDDLTriggers
After completing this module, students will be able to:
  • Examine the current activity in aSQLServer instance
  • Use System Monitor to obtain performance data about your computer and the instances ofSQLServer running on your computer
  • UseSQLServer Profiler to trace server and database activity
  • ImplementDDLtriggers that enable you to audit changes to the structure of database objects
  • Use event notifications to capture and monitor significant events for aSQLServer instance
Module 6: Transferring DataThis module explains how to transfer and transform data.
  • Overview of Data Transfer
  • Introduction toSQLServer Integration Services
  • UsingSQLServer Integration Services
  • Features ofSQLServer Integration Services
Lab 6: Transferring Data
  • Creating anSSISPackage
  • Deploying anSSISPackage
  • UsingSSISto Extract Data, Perform Lookups, Sort, and Split Data
After completing this module, students will be able to:
  • Describe the problems surrounding data transfer and the tools thatSQLServer 2005 provides to perform data transfer
  • Describe the purpose ofSQLServer Integration Services
  • UseSQLServer Integration Services to transfer data into aSQLServer database
  • Describe the features ofSQLServer Integration Services
Module 7: Automating Administrative TasksThis module explains how to use theSQLServer Agent to automate administrative tasks.
  • Automating Administrative Tasks inSQLServer 2005
  • Configuring theSQLServer Agent
  • Creating Jobs and Operators
  • Creating Alerts
  • Managing Multiple Servers
  • ManagingSQLServer Agent Security
Lab 7: Automating Administrative Tasks
  • ConfiguringSQLServer Agent
  • Creating Operators and Jobs
  • Creating Alerts
After completing this module, students will be able to:
  • DefineSQLServer 2005 administrative tasks and schedule these tasks to run automatically
  • ConfigureSQLServer Agent to support automatic task scheduling
  • Script tasks by usingSQLServer jobs, and define operators for managing these jobs
  • Define alerts to warn operators about events raised bySQLServer
  • Define and manage administrative tasks that span multiple servers
  • ConfigureSQLServer Agent security
Module 8: Implementing ReplicationThis module explains the purpose of replication, introduces the concepts underpinning replication, and describes how to implement replication in several common scenarios.
  • Overview of Replication
  • Implementing Replication
  • Configuring Replication in Some Common Scenarios
Lab 8: Implementing Replication
  • Creating a Publication
  • Creating a Subscription
  • ImplementingHTTPMerge Replication
After completing this module, students will be able to:
  • Describe replication and its components
  • Configure and implement replication
  • Use replication to meet the requirements of some common scenarios
Module 9: Maintaining High AvailabilityThis module explains how to implement high availability technologies withSQLServer 2005.
  • Introduction to High Availability
  • Implementing Server Clustering
  • Implementing Database Mirroring
  • Implementing Log Shipping
  • Implementing Peer-to-Peer Replication
Lab 9:Configuring Database Mirroring to Support Failover
  • Implementing Distributed High Availability
After completing this module, students will be able to:
  • Describe the factors affecting database availability
  • Explain how to implement clustering to support fast failover of computers running MicrosoftSQLServer instances
  • Describe how to useSQLServer mirroring to implement a software solution for fast failover
  • Describe how to implement log shipping to support fast recovery of a standbySQLServer database
  • Explain how to use peer-to-peer replication to implement high availability in a distributed environment

Maintaining a Microsoft SQL Server 2005 Database

£ 1,295 + VAT