Course 3178: Designing a Transaction Strategy for a Microsoft SQL Server 2005 Solution

Introduction In this 2 hour course you will learn how to design a transaction strategy that provides higher transaction rates while maintaining a high level of performance and a low response time. You will also learn how the design will address production issues such as excessive locking, blocking, deadlocking, performance, and scalability.

This course will also help prepare you for certification exam 70-441.

Objectives At the end of the course, students will be able to:

• Define data behavior requirements
• Define transaction isolation levels
• Design a resilient transaction strategy

Modules & Lessons Course Overview Module Introduction Navigation Overview Lab Information Designing a Server-Side Solution for SQL Server 2005 Designing a Transaction Strategy for a SQL Server 2005 Solution Module Introduction Defining Data Behavior Requirements Lesson Introduction The Process of Identifying Data Stores and Data Behavior Requirements Guidelines for Identifying Data Behavior Guidelines for Defining Data Behavior Requirements Self Test Defining Isolation Levels Lesson Introduction Considerations for Choosing an Isolation Level for a Database The Behavior of Transactions Using Snapshot Isolation Level Considerations for Offloading Concurrent Activities Guidelines for Accessing Data Across Multiple Data Stores Self Test Designing a Resilient Transaction Strategy Lesson Introduction Best Practices for Designing a Resilient Transaction Strategy Guidelines for Designing an Object Access Strategy Considerations for Transaction Rollback Considerations for Designing Large Transactions Guidelines for Using Locking Hints Evaluating Whether Transactions Adhere to Object Access Strategies Self Test Lab: Designing a Transaction Strategy for a SQL Server 2005 Solution Lesson Introduction Scenario Exercise: Determining the Database Isolation Level Exercise: Designing a Transaction Strategy for SQL Server 2005 Proposed Transaction Strategy: Solution A Proposed Transaction Strategy: Solution B Lab Review Module Summary Glossary Module Introduction System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled