|
Updating Your Database Administration Skills to SQL Server 2005 - (Microsoft Training Course: 2733) - 3 days
|
|
|
Target Audience
|
Pre-requisites
|
|
Purpose
|
Print 2 Page Flyer
|
|
Exams
|
Price Options
|
| |
|
COURSE OUTLINE
|
| |
|
Overview of SQL Server 2005 Architecture
|
Installing SQL Server 2005
|
|
SQL Server 2005 Administrative Tools
|
Monitoring SQL Server 2005
|
|
Maintaining Databases and Indexes
|
Securing SQL Server 2005
|
|
Disaster Recovery
|
Data Availability
|
|
|
Target Audience:
This learning product will enable database administrators experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005 so that they can support, configure, and maintain enterprise SQL Server 2005 databases and servers. It is aimed at IT professionals.
Pre-requisites:
Before attending this course, students must have the following pre-requisites:- MCDBA certification or equivalent knowledge.
- Administration experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0.
- Knowledge of SQL Server 2000/7.0 to include database and server architecture, installation and configuration, database security, database recovery (backup and restore), SQL Server technologies used for database availability such as log shipping and clustering, job automation, database and server monitoring, troubleshooting and replication.
- In addition, it is recommended, but not required, that students have completed Course 2072, Administering a Microsoft SQL Server 2000 Database.
Purpose:
At the end of the course, students will be able to 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.
|
|
|
Module 1: Overview of SQL Server 2005 Architecture
- Overview of SQL Server 2005
- System Enhancements for Administrators
Skills
- Describe the components of SQL Server 2005
- Describe new and enhanced features for administrators in SQL Server 2005.
Top |
|
Module 2: Installing SQL Server 2005
- Preparing to Install SQL Server 2005
- Performing a SQL Server 2005 Installation
- Maintaining a SQL Server 2005 Installation
- Lab: Installing SQL Server 2005
- Installing a SQL Server Instance.
Skills
- Plan a SQL Server 2005 installation.
- Install SQL Server 2005.
- Maintain a SQL Server 2005 installation.
Top |
|
|
Module 3: SQL Server 2005 Administrative Tools
- Using SQL Server Management Studio
- Using SQL Server Computer Manager
- Using the sqlcmd Utility
- Using the SQL Management Objects
- Lab: Administering SQL Server 2005
- Creating the Personnel database.
- Populating the Personnel database.
- Backing Up the Personnel Database.
Skills
- Choose the appropriate tool or utility to perform an administrative task.
- Use SQL Server Management Studio to manage databases.
- Use SQL Server Computer Manager to manage a server.
- Use the sqlcmd utility to execute Transact-SQL from the command prompt.
- Use SQL Management Objects to script common administrative tasks.
Top |
|
Module 4: Monitoring SQL Server 2005
- Using SQL Profiler
- Using DDL Triggers
- Using Event Notifications
- Using Metadata Views
- Lab: Monitoring SQL Server 2005
- Using Profiler
- Creating DDL Triggers
- Creating Event Notifications
Skills
- Use SQL Profiler to monitor SQL Server 2005.
- Use DDL triggers to respond to DDL events.
- Use event notifications to respond to database events.
- Query SQL Server metadata.
Top |
|
|
Module 5: Maintaining Databases and Indexes
- Managing Indexes
- Using the Database Tuning Advisor
- Lab: Maintaining a Database
- Defining Indexes
- Tuning a Database
Skills
- Maintain indexes in a SQL Server 2005 database.
- Use the Database Tuning Advisor to assist with database design.
- Maintain SQL Server 2005 databases.
Top |
|
Module 6: Securing SQL Server 2005
- SQL Server 2005 Security Overview
- Managing SQL Server 2005 Security
- Managing Permissions
- Managing Certificates
- Lab: Securing a SQL Server 2005 Database
- Managing securables
- Managing principals
- Managing Permissions
- Dropping a User that Created Objects.
Skills
- Describe the security architecture of SQL Server 2005.
- Manage securables and principals.
- Manage permissions.
- Use certificates in SQL Server 2005.
Top |
|
|
Module 7: Disaster Recovery
- Disaster Recovery in SQL Server 2005
- Using Database Snapshots
- Backup and Restore Operations
- Lab: Managing Disaster Recovery
- Creating a Database Snapshot
- Backing up a Database
Skills
- Describe common disaster recovery enhancements in SQL Server 2005.
- Use database snapshots.
- Perform backup and restore operations.
Top |
|
Module 8: Data Availability
- Introduction to Data Availability
- Introduction to Database Mirroring
- Configuring Database Mirroring
- Lab: Maintaining Availability
- Preparing the Principal and Mirror Server
- Establishing a Mirroring Session
- Establishing a Witness Server
- Executing Transactions
- Simulating Principal Server Failure
- Restarting the Failed Server
- Terminating the Mirror Session
Skills
- Describe the data availability technologies included in SQL Server 2005.
- Describe the concepts of database mirroring.
- Configure database mirroring.
Top |
|
|
|
Exams:
-
There are no exams directly associated with this course
|
|
Price Options ex VAT:
Classroom Training
? |
Distance Learning
? |
eLearning Options
? |
Book Learning
? |
£
1050
(€1491)
|
£
674.00
(€957)
|
- |
No Books Supported for Course at present
|
|
|
Call Free on 0800 169 1890
Print 2 Page Flyer
Last Modified 01 May 2008
|
|
