- Microsoft SQL Training
- 2733: Updating Your Database Administration Skills to Microsoft SQL Server 2005
This course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can support, configure, and maintain enterprise SQL Server 2005 databases and servers.
- Course Outline
Lesson 1: Overview of SQL Server 2005 Architecture
Overview of SQL Server 2005
System Enhancements for Administrators Lesson 2: Installing SQL Server 2005 Preparing to Install SQL Server 2005
Performing a SQL Server 2005 Installation
Maintaining a SQL Server 2005 Installation Lesson 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 Lesson 4: Monitoring SQL Server 2005 Using SQL Profiler
Using DDL Triggers
Using Event Notifications
Using Metadata Views Lesson 5: Maintaining Databases and Indexes Managing Indexes
Using the Database Tuning Advisor Lesson 6: Securing SQL Server 2005 SQL Server 2005 Security Overview
Managing SQL Server 2005 Security
Managing Certificates Lesson 7: Disaster Recovery Disaster Recovery in SQL Server 2005
Using Database Snapshots
Backup and Restore Operations Lesson 8: Data Availability in SQL Server 2005 Introduction to Data Availability
Introduction to Database Mirroring
Configuring Database Mirroring Lesson 9: SQL Server 2005 Replication Overview of Replication Enhancements
New Types of Replication
- Prerequisites & Certificates
- Cancellation Policy
Cancellations or postponements received more than ten business days prior to the first day of the course will be fully refunded less a $75 processing fee. The cost of the course is payable, in full, for any cancellations or postponements received within ten business days, or less, prior to the first day of the course.
- Map & Reviews
Acend Corporate Learning
[ View Provider's Profile ]
ReviewsHere are some reviews of the training vendor.
This course has not yet been rated by one of our members.
If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.
This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.
This page has been viewed 467 times.