![]() |
This set of training videos provides students with the knowledge and skills to administer and automate Microsoft SQL Server 2005 databases and servers. This course focuses on the need to maintain administration and automation information. It is intended for current professional database administrators who have three or more years of on-the-job experience administering SQL Server database solutions in an enterprise environment. Price: $195
|
| Meet
The Certified Instructor:
|
Mark Russell - SQL 2005 Trainer (MCT, MCDBA, MCSD.NET, MCSE Security, CEH, Security+) Mark Russell has over twenty years total networking and programming experience with a current focus enterprise database development and training using Microsoft SQL Server tools and technologies. Mark is a Certified Technical Trainer. He has taught over 500 Desktop Applications classes and over 500 Technical classes. Mark has completed Microsoft approved Train-the Trainer Program. He was named Instructor of the Year in 1999 with New Horizons Worldwide. As a Microsoft Certified Trainer, Mark has maintained an overall class (Instructor score) average of 9.62 on a 10 scale. |
Course Introduction Module 1 - Managing and Automating Databases and Servers
Lesson 1: An Automated System for Database Maintenance
Automating Database Administration
Using SQL Server Agent Assessing System Dependencies on the Database Identifying Maintenance Needs Automating Database Maintenance Plans Lesson 2: An Automated System for Server Maintenance
Implementing Application Database Changes
Implementing Windows and SQL Server Updates Lesson 3: Administration and Automation Information
Maintaining a Run Book
The SQL Health and History Tool Additional Automation Tools Lab 1 Introduction Module 2 - Review Module 2 - Managing SQL Server Supporting Services
Lesson 1: SSIS Packages
SSIS Packages
Monitoring SSIS Packages Lesson 2: Replication
Choosing Replication Monitoring Tools
Lesson 3: Reporting Services
Managing the Report Server Configuration Managing Report Services Databases Managing Report Servers Module 2 - Review |