Maintaining a Microsoft SQL Server 2005 Database
Course
In London and Birmingham
Description
-
Type
Course
-
Location
-
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
Start date
Start date
Reviews
Course programme
- Preparing to InstallSQLServer
- InstallingSQLServer 2005
- Managing aSQLServer 2005 Installation
- Performing an Installation
- ManagingSQLServer
- Explain how to prepare the hardware and other resources necessary to installSQLServer 2005
- InstallSQLServer 2005
- Manage and configure aSQLServer 2005 installation
- Planning Databases
- Creating Databases
- Managing Databases
- Creating a Database
- Monitoring and Managing Filegroup Usage
- Viewing Database Metadata
- Plan how to implement a database that meets an organization's requirements
- Create aSQLServer database
- Manage aSQLServer database
- 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
- Implementing a Backup Strategy
- Restoring and Recovering a Database
- Performing Piecemeal Backup and Restore Operations
- Restoring the master Database
- 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
- Overview ofSQLServer Security
- Protecting the Server Scope
- Protecting the Database Scope
- Managing Keys and Certificates inSQLServer
- Creating Logins and Assigning Server-Scope Permissions
- Creating and Managing Users
- Using a Certificate to Protect Data
- Describe howSQLServer manages security
- ProtectSQLServer at the server level
- ProtectSQLServer databases
- Use keys and certificates to protectSQLServer objects
- Viewing Current Activity
- Using System Monitor
- UsingSQLServer Profiler
- UsingDDLTriggers
- Using Event Notifications
- MonitoringSQLServer Performance
- TracingSQLServer Activity
- ImplementingDDLTriggers
- 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
- Overview of Data Transfer
- Introduction toSQLServer Integration Services
- UsingSQLServer Integration Services
- Features ofSQLServer Integration Services
- Creating anSSISPackage
- Deploying anSSISPackage
- UsingSSISto Extract Data, Perform Lookups, Sort, and Split Data
- 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
- Automating Administrative Tasks inSQLServer 2005
- Configuring theSQLServer Agent
- Creating Jobs and Operators
- Creating Alerts
- Managing Multiple Servers
- ManagingSQLServer Agent Security
- ConfiguringSQLServer Agent
- Creating Operators and Jobs
- Creating Alerts
- 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
- Overview of Replication
- Implementing Replication
- Configuring Replication in Some Common Scenarios
- Creating a Publication
- Creating a Subscription
- ImplementingHTTPMerge Replication
- Describe replication and its components
- Configure and implement replication
- Use replication to meet the requirements of some common scenarios
- Introduction to High Availability
- Implementing Server Clustering
- Implementing Database Mirroring
- Implementing Log Shipping
- Implementing Peer-to-Peer Replication
- Implementing Distributed High Availability
- 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