Microsoft SQL Server 2005 Databases and Services

Mondale IT Solutions Ltd.
London, Birmingham, Manchester, Leeds, Glasgow, Edinburgh, Reading, Bristol, Exeter, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This one-day instructor-led course provides students with the knowledge and skills to administer and automate Microsoftï¿?SQL ServerT 2005 databases and servers. This course focuses on the need to maintain administering and automation information.

This course 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 Content

Module 1: Managing and Automating Databases and Servers

This module provides you with the guidelines and considerations for planning automated systems for databases and servers. This module also provides you with the knowledge required to maintain a run book.

Lessons

ï¿?Planning an Automated System for Database Maintenance
ï¿?Planning an Automated System Server Maintenance
ï¿?Documenting Administration and Automation Information

Lab 1: Managing and Automating Databases and Servers

ï¿?Creating Maintenance Plans
ï¿?Creating Database Change Control Procedures
ï¿?Configuring and Using the SQL H2 Tool

After completing this module, students will be able to:

ï¿?Plan an automated system for database maintenance.
ï¿?Plan an automated system for server maintenance.
ï¿?Document administration and automation information in a run book.

Module 2: Managing SQL Server Supporting Services

This module introduces the concept of SQL Server Integration Services (SSIS) packages and provides the guidelines to deploy and manage SSIS packages. This module also provides the guidelines and considerations for maintaining replication and reporting services.

Lessons

ï¿?Managing SSIS Packages
ï¿?Managing Replication
ï¿?Managing Reporting Services

Lab 2: Managing SQL Server Supporting Services

ï¿?Moving Packages Between Database Servers
ï¿?Initializing a Transactional Subscription from a Backup
ï¿?Configuring Reporting Services

After completing this module, students will be able to:

ï¿?Manage SSIS packages.
ï¿?Manage replication.
ï¿?Manage reporting services.
...''

Elements of this syllabus are subject to change.

Phone:01635 281 888

School Address:

Mondale IT Solutions Ltd
Poplar House
Compton Road
East Ilsley
Newbury
Berkshire
United Kingdom
RG20 7LH

Jobs & Resumes: London, Birmingham, Manchester, Leeds, Glasgow, Edinburgh, Reading, Bristol, Exeter
Houses & Roommates: London, Birmingham, Manchester, Leeds, Glasgow, Edinburgh, Reading, Bristol, Exeter
Travel Agencies: London, Birmingham, Manchester, Leeds, Edinburgh, Bristol,

Search other schools for Microsoft SQL Server 2005 Databases and Services training resources.

Oracle Reports Developer 10g: Build Reports
Oracle Discoverer Administrator 10g: Develop an EUL
Building an Effective Web Site
Developing Web Applications with Active Server Pages and VBScript
Getting Started with PHP and MySQL
Internet Technology Fundamentals
Script Programming with VBScript
Web Publishing using Dreamweaver
Web Publishing using Microsoft FrontPage
Web Site Authoring using Dreamweaver CS3
Designing a Business Intelligence Solution for the Enterprise Using Microsoft SQL Server 2005
Microsoft SQL Server 2005 Infrastructure
Designing a Reporting Solution Architecture Using Microsoft SQL Server 2005 Reporting Services
Designing an ETL Solution Architecture Using Microsoft SQL Server 2005 Integration Services
Designing High Availability Solutions for Microsoft SQL Server 2005
Designing Microsoft SQL Server 2005 Databases
Designing Microsoft SQL Server 2005 Server-side Solutions
Designing on Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself.