|
|
 |
Microsoft SQL Server 2005
Designing a Microsoft SQL Server 2005 Infrastructure (2786)
|
|
|
Who Should Attend
| This course is intended for current professional database developers 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 the trade-offs among the different redundant storage types, understand how replication works and how it is implemented. They should be familiar with reading user requirements and business-need documents and have some knowledge of how queries execute. Students should also have basic knowledge of the dependencies between system components, be able to design a database to third normal form (3NF) and know the trade-offs when backing out of a fully normalised design.
|
|
|
| Additionally, students are expected to have monitoring and troubleshooting skills, knowledge of the operating system and platform and application architecture. Students should also know how to use a data modeling tool, Microsoft Visio, SQL Server 2005 features, tools and technologies. Lastly, they should have a Microsoft Certified Technology Specialist: Microsoft SQL Server 2005 credential or equivalent experience.
|
|
|
| It is also recommended that they have completed the following: (2278) Writing Queries Using Microsoft SQL Server 2005 Transact-SQL, (2779) Implementing a Microsoft SQL Server 2005 Database and (2780) Maintaining a Microsoft SQL Server 2005 Database |
Course Objectives
| This two-day instructor-led clinic provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL ServerT 2005 database infrastructure. The course focuses on the development of strategies for data archiving, consolidation, distribution, and recovery. The course also stresses the importance of capacity analysis and emphasises the trade-offs that need to be made during design.
|
|
|
| This is the first course in the database administration curriculum and will serve as the entry point for other courses in the curriculum. At the end of the course, students should be able to analyse storage, CPU, memory and network capacity needs. They will also be able to design a strategy for data archiving, database server consolidation, data distribution and data recovery. They will also be able to design a database server infrastructure and establish database conventions and standards. |
Course Content
| 1. Analysing Capacity Needs
|
| 2. Designing a Strategy for Data Archiving
|
| 3. Designing a Strategy for Database Server Consolidation
|
| 4. Designing a Strategy for Data Distribution
|
| 5. Designing a Database Server Infrastructure
|
| 6. Designing a Strategy for Data Recovery
|
| 7. Establishing Database Conventions and Standards |
Dates Europe
To book a course, please click on the required city name.
Germany
|
|
|
|
Heidelberg