Monitoring and Maintaining a Database in SQL Server 2005

To monitor a database, automate database maintenance tasks, and configure reporting services for SQL Server 2005

Candidates for the MCITP: Database Administrator certification should have taken and passed exam 70-431 to be certified as an MCTS: SQL Server 2005.

Professionals pursuing a career as a Database Administrator

WEB

Establishing Performance Baselines and Thresholds| - identify the steps for establishing a performance baseline.|Monitoring the Database with SQL Server Profiler| - use SQL Server Profiler to monitor a database in a given scenario.|Tuning a Database using Database Engine Tuning Advisor| - recognize how to tune a database using the Database Engine Tuning Advisor in a given scenario.|Monitoring and Tuning a Database| - monitor and tune a database using SQL Server Profiler and Database Engine Tuning Advisor.|Automating Database Administration Tasks| - recognize how to automate database administration tasks using SQL Server Agent in a given scenario.|Creating Alerts and Operators| - recognize how to create alerts and operators in a given scenario.|Creating a Database Maintenance Strategy| - create and implement a database maintenance strategy for a given scenario.|Managing Database Maintenance| - recognize how to use the Maintenance Plan Wizard to automate database maintenance tasks.|Managing Reporting Services| - manage reports in SQL Server 2005.|Configuring Reporting Services| - configure reporting services in SQL Server 2005.|

123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace: E-Learning available for - ABAP 6. 10 - Access 2003 - Acrobat 6. 0 - ASP - ASP. NET - C - Captivate 1. 0 - Crystal Reports 8. 5 - Crystal Reports v10 -...