Search on keywords


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:

a

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.

a

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