|
|
 |
Microsoft SQL Server 2005
Administering and Automating Microsoft SQL Server 2005 Databases and Servers (2789)
|
|
|
Who Should Attend
| This course is intended for current database administrators who have three or more years of on-the-job experience administering SQL Server database solutions in an enterprise environment. |
Prerequisites
| Before attending this workshop, students must understand how replication works and implemented, have working knowledge of source control software, networking, and security infrastructures. They should be able to design a database to third normal form (3NF) and know the trade offs when backing out of the fully normalised design and designing for performance and business requirements in addition to being familiar with design models, such as Star and Snowflake schemas.
|
|
|
| Additionally, they should have basic monitoring and troubleshooting skills, experience in creating drawings using Microsoft Visio and have basic knowledge of the operating system and platform. Students are also expected to have knowledge of application architecture, be familiar with SQL Server 2005 features, tools and technologies, and have completed a Microsoft Certified Technology Specialist: Microsoft SQL Server 2005, or equivalent experience. It is recommended, but not required, that students should have completed Writing Queries Using Microsoft SQL Server 2005 Transact-SQL (2778), Implementing a Microsoft SQL Server 2005 Database (2779), Maintaining a Microsoft SQL Server 2005 Database (2780). |
Course Objectives
| This 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 administering and automation information. |
Course Content
| 1. Managing and Automating Databases and Servers
|
| 2. Managing SQL Server Supporting Services |
Dates Europe
To book a course, please click on the required city name.
Germany
|
|
|
|
Berlin