M2733: Updating Your Database Admininstration Skills to MS SQL Server 2005
Starting dates and places
Description
Prerequisites:
Before attending this course, students must have: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
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.
Replication.
In addition, it is recommended, but not required, that students have completed:
Course MS2072, Administering a Microsoft SQL Server 2000 Database
Course Description:
This course provides deleg…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
Prerequisites:
Before attending this course, students must have: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
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.
Replication.
In addition, it is recommended, but not required, that students have completed:
Course MS2072, Administering a Microsoft SQL Server 2000 Database
Course Description:
This course provides delegates with an upgrade path to SQL Server 2005 offering the skills required to administer and troubleshoot.
This course includes the following modules:
Overview of SQL Server 2005 Architecture
- Overview of SQL Server 2005
- System Enhancements for Administrators
Installing SQL Server 2005
- Preparing to Install SQL Server 2005
- Performing a SQL Server 2005 Installation
- Maintaining a SQL Server 2005 Installation
SQL Server 2005 Administrative Tools
- Using SQL Server Management Studio
- Using SQL Server Computer Manager
- Using the sqlcmd Utility
- Using the SQL Management Objects
Administering SQL Server 2005
- Creating the Personnel database.
- Populating the Personnel database.
- Backing Up the Personnel Database.
Monitoring SQL Server 2005
- Using SQL Profiler
- Using DDL Triggers
- Using Event Notifications
- Using Metadata Views
Maintaining Databases and Indexes
- Managing Indexes
- Using the Database Tuning Advisor
Disaster Recovery
- Disaster Recovery in SQL Server 2005
- Using Database Snapshots
- Backup and Restore Operations
Data Availability in SQL Server 2005
- Introduction to Data Availability
- Introduction to Database Mirroring
- Configuring Database Mirroring
SQL Server 2005 Replication
- Overview of Replication Enhancements
- New Types of Replication
- Configuring Replication
For online live training advice please visit our Learning Advice Centre on our website. Be sure to follow us on Twitter to receive special course offers, news and updates!
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.