Course Schedule:
| Location |
Days |
Course dates |
Duration |
Cost (ex GST) |
Availability |
Enrol Here |
| City |
Wed |
12 Nov 2008 |
1 day |
540.00 |
Open |
Corporate Group / Individual |
Overview:
This course will provide you with the knowledge and skills to administer and automate SQL Server 2005 databases and servers. This course focuses on the need to maintain administering and automation information.
Learning method:
Instructor led.
There is a heavy emphasis on individual exercises.
Who will benefit from this course?
Current professional database administrators who have some on-the-job experience administering SQL Server database solutions.
Pre-requisites:
Before attending this course, you should:
- understand how replication works and how replication is implemented
- have working knowledge of source control software. Specifically, what it is used for and how it works
- have some working knowledge of networking. Specifically, how to isolate a failure to identify where a failure is occurring
- have basic working knowledge of security infrastructures. Specifically, active directory service infrastructure
- be able to design a database to third normal form (3NF)
- know the trade offs when backing out of the fully normalised design (denormalisation) and designing for performance and business requirements
- be familiar with design models, such as Star and Snowflake schemas
- have basic monitoring and troubleshooting skills
- be familiar with SQL Server 2005 features, tools, and technologies
What can you expect to gain from this course?
After attending this course you will have a thorough understanding of the mechanisms with which to manage MS SQL Server, to ensure continuity of service and optimum performance.
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 knowledge required to maintain a run book
Module 2: Managing SQL Server Supporting Services
- This module introduces the concept of SQL Server Integration Services (SSIS) packages
- provides the guidelines to deploy and manage SSIS packages
- provides the guidelines and considerations for maintaining replication and reporting services