|
More on Single User, Multi User & Network Licences
PACKAGE INCLUDES2 CD-ROMs featuring live instructor-led classroom sessions with full audio, video and demonstration components Printable courseware Step-by-step hands-on-labs Comprehensive, understandable, and reusable as reference material Microsoft Authorized MeasureUp Exam Simulation Focused on practical solutions to real-world development problems
COURSE INTRODUCTIONSchedule our instructor led classroom training at your convenience and never miss another lecture or fall behind. You are in complete control. We invited the Best Microsoft-Certified Trainers in the industry to help us develop the ultimate training & certification program which includes everything you will need to succeed.
This instructor-led course 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.
|
COURSE OUTLINE
|
Module 1 - Managing and Automating Databases and ServersLesson 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 ServicesLesson 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
|
|