|
|
 |
Microsoft SQL Server 2005
Designing Microsoft SQL Server 2005 Server-Side Solutions (2781)
|
|
|
Who Should Attend
| This course is intended for current professional database developers who have three or more years of on-the-job experience developing SQL Server database solutions in an enterprise environment. |
Prerequisites
| Before attending this workshop, students must have experience reading user requirements and business-need documents. They should able be able to understand Transact SQL syntax and programming logic, XML and security requirements. Additionally, they should be able to design a database to 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 schemes.
|
|
|
| They should have basic monitoring and troubleshooting skills, basic knowledge of the operating system and platform, and application architecture. Students should also have experience with a reporting tool, and be familiar with SQL Server 2005 features, tools and technologies. Furthermore, they should have a Microsoft Certified Technology Specialist: Microsoft SQL Server 2005 credential or relevant experience. |
Course Objectives
| This three-day course provides students with the knowledge and skills to design server-side solutions for Microsoft SQL Server 2005T. The course focuses on teaching database developers who work in enterprise environments to identify and place database technologies during design to achieve a suitable solution that meets the needs of an organisation. Students will also learn to consider the solution from a system-wide view instead of from a single database or server perspective.
|
|
|
| After completing this course, students will be able to select SQL Server services to support an organisation’s business needs and design a security strategy for a SQL Server 2005 solution. Students will be able to design a data modelling strategy, a transaction strategy for a SQL Server solution, a Notification Services solution and a Service Broker solution. Students will be able to plan for source control, unit testing, and deployment to meet an organisation’s needs. Lastly, they will also be able to evaluate advanced query techniques and advanced query techniques. |
Course Content
| 1. Selecting SQL Server Services to Support Business Needs
|
| 2. Designing a Security Strategy for Components of a SQL Server 2005 Solution
|
| 3. Designing a Data Modeling Strategy
|
| 4. Designing a Transaction Strategy for a SQL Server 2005
|
| 5. Designing a Notification Services Solution
|
| 6. Designing a Service Broker Solution
|
| 7. Planning for Source Control, Unit Testing and Deployment
|
| 8. Evaluating Advanced Query Techniques
|
| 9. Evaluating Advanced XML Techniques |
Dates Europe
To book a course, please click on the required city name.
Germany
|
|
|
|
Koblenz